2012-2013 School Year State of Washington Run July 16, 2012 10:53 AM - - PDF document

Page 1 of 23 2012-2013 School Year State of Washington Run July 16, 2012 10:53 AM Superintendent of Public Instruction Spokane School District Educational Service District 101 Spokane County F-203 Worksheet Report CCDDD 32081 Special Education BEA Rate per Student Calculation – Acct 4121 Item Code

BEA Calculated Staff Units

Amount Z219 CIS BEA Teacher FTE K-3 386.166 ([Enroll K-3] / [Class Size K-3]) * (1 + [Planning K-3]) (8,435.48 / 25.23) * (1 + 0.155) (F-203 CIS BEA Teacher FTE K-3 High Poverty 12.416 Undefined) ([Enroll K-3 HighPov] * (1/ [Class Size K-3 HighPov] – (1/[Class Size K-3])) * (1 + [Planning K-3]) (5,784.27 * (1/24.10 – 1/25.23) * (1 + 0.155) Z220 CIS BEA Teacher FTE 4 95.542 ([Enroll 4] / [Class Size 4] * (1 + [Planning 4]) (2,233.44 / 27.00) * (1 + 0.155) Z221 CIS BEA Teacher FTE 5-6 193.452 ([Enroll 5-6] / [Class Size 5-6]) * (1 + [Planning 5-6]) (4,522.25 / 27.00) * (1 + 0.155) Z222 CIS BEA Teacher FTE 7-8 181.205 ([Enroll 7-8] / [Class Size 7-8]) * (1 + [Planning 7-8]) (4,308.14 / 28.53) * (1 + 0.200) Z223 CIS BEA Teacher FTE 9-12 351.368 ([Enroll 9-12] / [Class Size 9-12]) * (1 + [Planning 9-12]) (8,415.26 / 28.74) * (1 + 0.200) Z224 CIS BEA Teacher FTE K-12 0.04371 ([CIS BEA Teacher FTE K-3] + [CIS BEA Teacher FTE K-3 HP] + [CIS BEA Teacher FTE 4] + [CIS BEA Teacher FTE 5-6] + [CIS BEA Teacher FTE 7-8] + [CIS Teacher BEA FTE 9-12]) / [Enroll Total] (386.166 + 12.416 + 95.542 + 193.452 + 181.205 + 351.368) / 27,914.53 (F-203 Undefined) Other CIS K-6 FTE

(([Enroll K-6] * ([Proto Elem Librarian FTE] + [Proto Elem Counselor FTE] + [Proto Elem

49.03 Nurses FTE] + [Proto Elem Social Worker FTE] + [Proto Elem Psychologist FTE])) / [Proto Elem Enroll] ((15,191.13) * (0.663 + 0.493 + 0.076 + 0.042 +0.017)) / 400 (F-203 Undefined) Other CIS 7-8 FTE

(([Enroll 7-8] * ([Proto Middle Librarian FTE] + [Proto Middle Counselor FTE] + [Proto Middle

Nurses FTE] + [Proto Middle Social Worker FTE] + [Proto Middle Psychologist FTE])) / [Proto

Middle Enroll]

16.98 ((4,308.14) * (0.519 + 1.116 + 0.060 + 0.006 + 0.002)) / 432 (F-203 Undefined) Other CIS 9-12 FTE

(([Enroll 9-12] * ([Proto High Librarian FTE] + [Proto High Counselor FTE] + [Proto High

Nurses FTE] + [Proto High Social Worker FTE] + [Proto High Psychologist FTE])) / [Proto

High Enroll]

35.76 ((8,415.26) * (0.523 + 1.909 + 0.096 + 0.015 + 0.007)) / 600 (F-203 Undefined) Other CIS FTE K-12

([Other CIS K-6 FTE] + [Other CIS 7-8 FTE] + [Other CIS 9-12]) / [Enroll Total]

(49.03 + 16.98 + 35.76) / 27,914.53 0.00365

Page 1 of 23 2012-2013 School Year State of Washington Run July 16, 2012 10:53 AM Superintendent of Public Instruction Spokane School District Educational Service District 101 Spokane County F-203 Worksheet Report CCDDD 32081 Sped Rate Salary Allocation Item Code Amount Z225 CIS BEA Salary Maint Total $ 2,557.24 ([CIS BEA FTE K-12] + [Other CIS FTE K-12] * [CIS - Salary Maint] * [CIS Mix] (0.04371 + 0.00365) * 33,401.00 * 1.61659 Z226 CIS BEA Salary Inc Total $ 0.00 ([CIS BEA FTE K-12] + [Other CIS FTE K-12]) * [CIS - Salary Inc] * [CIS Mix] - [CIS BEA Salary Maint Total] (0.04371 + 0.00365) * 33,401.00 * 1.61659 – 2,557.24 Z227 CIS BEA Salary Total $ 2,557.24 [CIS BEA Salary Maint Total] + [CIS BEA Salary Inc Total] 2,557.24 + 0.00 Z228 CAS BEA Salary Maint Total $ 224.98 [CAS BEA FTE K-12] * [CAS - Salary Maint] 0.00400 * 56,246.00 Z229 CAS BEA Salary Inc Total $ 0.00 [CAS BEA FTE K-12] * [CAS - Salary Inc] - [CAS BEA Salary Maint Total] 0.00400 * 56,246.00 - 224.98 Z230 CAS BEA Salary Total $ 224.98 [CAS BEA Salary Maint Total] + [CAS BEA Salary Inc Total] 224.98 + 0.00 Z231 CLS BEA Salary Maint Total $ 531.73 [CLS BEA FTE K-12] * [CLS - Salary Maint] 0.01701 * 31,260.00 Z232 CLS BEA Salary Inc Total $ 0.00 [CLS BEA FTE K-12] * [CLS - Salary Inc] - [CLS BEA Salary Maint Total] 0.01702 * 31,260.00 – 531.73 Z233 CLS BEA Salary Total $ 531.73 [CLS BEA Salary Maint Total] + [CLS BEA Salary Inc Total] 531.73 + 0.00 Z234 TOTAL Salary BEA $ 3,313.95 [CIS BEA Salary Total] + [CAS BEA Salary Total] + [CLS BEA Salary Total] 2,557.24 + 224.98 + 531.73

Page 1 of 23 2012-2013 School Year State of Washington Run July 16, 2012 10:53 AM Superintendent of Public Instruction Spokane School District Educational Service District 101 Spokane County F-203 Worksheet Report CCDDD 32081 Sped Rate Benefits Allocation Item Code Amount Z235

• 1. CIS/CAS BEA Insurance Maint Total

$ 473.33 ([CIS BEA FTE K-12] + [CAS BEA FTE K-12]) * [Health Insurance] (0.04736 + 0.00400) * 9,216.00 Z236

• 2. CIS/CAS BEA Insurance Inc Total

$ 0.00 ([CIS BEA FTE K-12] + [CAS BEA FTE K-12]) * [Health Insurance Inc] (0.04736 + 0.00400) * 0.00 Z237

• 3. CLS BEA Insurance Maint Total

$ 180.59 [CLS BEA FTE K-12] * [Health Insurance] * [CLS Health Factor] 0.01701 * 9,216.00 * 1.152 Z238

• 4. CLS BEA Insurance Inc Total

$ 0.00 [CLS BEA FTE K-12] * [Health Insurance Inc] * [CLS Health Factor] 0.01701 * 0.00 * 1.152 Z239

• 5. CIS/CAS BEA Benefits Maint Total

$ 454.35 ([CIS BEA Salary Maint Total] + [CAS BEA Salary Maint Total]) * [CIS/CAS - Benefits Maint] (2,557.24 + 224.98) * 0.16330 Z240

• 6. CIS/CAS BEA Benefits Inc Total

$ 0.00 ([CIS BEA Salary Inc Total] + [CAS BEA Salary Inc Total]) * [CIS/CAS - Benefits Inc] (0.00 + 0.00) * 0.15690 Z241

• 7. CLS BEA Benefits Maint Total

$ 99.59 [CLS BEA Salary Maint Total] * [CLS - Benefits Maint] 531.73 * 0.18730 Z242

• 8. CLS BEA Benefits Inc Total

$ 0.00 [CLS BEA Salary Inc Total] * [CLS - Benefits inc] 0.00 * 0.15230 Z243

• 9. TOTAL Benefits BEA

$ 1,207.86 [CIS/CAS BEA Insurance Maint Total] + [CIS/CAS BEA Insurance Inc Total] + [CLS BEA Insurance Maint Total] + [CLS BEA Insurance Inc Total] + [CIS/CAS BEA Benefits Maint Total] + [CIS/CAS BEA Benefits Inc Total] + [CLS BEA Benefits Maint Total] + [CLS BEA Benefits Inc Total] 473.33 + 0.00 + 180.59 + 0.00 + 454.35 + 0.00 + 99.59 + 0.00

Page 1 of 23 2012-2013 School Year State of Washington Run July 16, 2012 10:53 AM Superintendent of Public Instruction Spokane School District Educational Service District 101 Spokane County F-203 Worksheet Report CCDDD 32081 Sped Rate Substitutes BEA Item Code Amount Z244 Substitutes BEA $ 26.55 [CIS Teacher BEA FTE K-12] * [Substitutes Days] * [Substitutes Rate] 0.04371 * 4.000 * 151.86 MSOC BEA Item Code Amount Z245 MSOC BEA Per Student $ 546.37 BEA Rate for Special Education Item Code Amount Z246 Total BEA per SpEd student $ 5,094.72 [TOTAL Salary BEA] + [TOTAL Benefits BEA] + [Substitutes BEA] + [MSOC BEA Per Student] 3,313.94 + 1,207.86 + 26.55 + 546.37