Copy of WCCUSD Insourcing Costing_10.31.25.xlsx

	B	C	D	E	G	O
1	NOTE: These represent three of the contracts that WCCUSD holds--there are more
2	Vendor	IBT Positions contracted	UTR Positions contracted	Total savings from insourcing		Total spent to contract for SPED (all 5000 categories) - 2024/25
3	ProCare-New Directions	Paras, RBT	SLP/Tele SLP, Psychologist/Tele Psych, Tele PT	$5,195,816.38		$ 35,187,688
4	Stepping Stones	Paras, RBT	SPED Teacher, Assisted PE, SLP, OT	$647,622.96		Percent of spending on these three contracts of all sped contracts
5	Sunbelt	None	Virtual Deaf and Hard of Hearing Services	$23,038.75		41%
6				$5,866,478.08
7
8	Total spent contracting out IBT positions	Number of IBT FTEs that could have been hired with that money	Additional hours those in-house IBT staff would have worked in the classroom, compared to the hours worked by contracted staff*	Savings from insourcing	<<They spent $13M to contract out IBT positions and got 150,381 fewer classroom hours than if the positions stayed in house, while spending $5.6M more on wages
9	$13,210,383	228.3	150,381	$5,580,664
10	Total spent contracting out UTR positions	Number of UTR FTEs that could have been hired with that money	Additional hours those in-house UTR staff would have worked in the classroom, compared to the hours worked by contracted staff*	Savings from insourcing	<<They spent over $1M to contract out UTR positions, and got 3,460 fewer classroom hours than if the positions stayed in house, while spending over a quarter of a million dollars more on wages
11	$1,182,960	9.9	3,460	$285,814
12	TOTALS
13	$14,393,343	238.3	153,841	$5,866,478	<<The district would save nearly $6 million by in-sourcing this work--and that reflects only a portion of the district's SPED contracts
14					<<The district could hire 238 union FTEs with the money they spent on these three SPED vendors
15
16	*In-house union staff hours are based on hours for 1 FTE, per IBT and UTR contracts (1380 and 1440, respectively), multiplied by the number of FTEs the district's spending on contracted workers would have covered. This is compared to the hours billed by contractors.
17	In other words: If the district spent $118,947 for 1000 hours of contracted SLP work, the district would have spent the same amount for an in-house UTR members to work 1440 hours--the district gets 440 more hours of work for the same price
18
19
20
21
22	HOURS PER YEAR CALCULATION
23	UTR:	*Article 22 Sec 1 (Work Year: 184 days + 60 hours). UTR Contract language, 10.1.6: "Work hours for Speech and Language Therapist/School Psychologists/Nurse shall be seven and one-half (7.5) hours including a 30-minute duty-free lunch. Start and end time shall be mutually agreed upon by Special Education Director and employees.
24	IBT:	Per IBT staff: Paras work 6-6.5 hours/day for 11 months a year (calculated as ~240 days/year)
25		6.5	hours/day
26		32.5	hours/week
27		240	placeholder for days/year per UTR contract
28		1560	hours/year
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100