FY27 Transportation Cost Calculator.xlsx

	B	C	D	E	F	G	I	J	K
1	INSURANCE COST CALCULATOR for TRANSPORTATION EMPLOYEES
2
3	Insurance coverage is for 12 months per year.								10/1/2026
4	Enter your hours per day in the yellow box below for individualized calculations.
5
6
7		4.00	Board-Approved Work Hours per Day (Bus Drivers: enter 4 for insurance purposes / bus drivers + preschool routes enter 6)
8		50.00%	Earned Benefit Factor (Hours entered / 8. 8 hours = 100% benefit)
9
10	MEDICAL
15
16	Plan #1 - $15 Copay					Plan #2 - $20 Copay
17			Single	Family				Single	Family
18		Monthly Premium	$1,872.00	$4,681.00			Monthly Premium	$1,536.00	$3,838.00
19		ISD Paid Benefit	$375.00	$825.00			ISD Paid Benefit	$375.00	$825.00
20		Equals Your Monthly Cost	$1,497.00	$3,856.00			Equals Your Monthly Cost	$1,161.00	$3,013.00
21		Your Deduction per Check	$748.50	$1,928.00			Your Deduction per Check	$580.50	$1,506.50
22		Your Annual Cost	$17,964.00	$46,272.00			Your Annual Cost	$13,932.00	$36,156.00
23
24
25	Plan #3 - Empower HSA $1,700/$3,400 Deductible						Plan #4 - Empower HSA $4,000/$8,000 Deductible
26			Single	Family				Single	Family
27		Monthly Premium	$1,370.00	$3,425.00			Monthly Premium	$835.00	$2,085.00
28		ISD Paid Benefit	$375.00	$825.00			ISD Paid Benefit	$375.00	$825.00
29		Equals Your Monthly Cost	$995.00	$2,600.00			Equals Your Monthly Cost	$460.00	$1,260.00
30		Your Deduction per Check	$497.50	$1,300.00			Your Deduction per Check	$230.00	$630.00
31		Your Annual Cost	$11,940.00	$31,200.00			Your Annual Cost	$5,520.00	$15,120.00
32
33	DENTAL
34			Single	Family
35		Monthly Premium	$42.60	$127.80
36		Maximum ISD Paid Benefit	$16.67	$41.04
37		Equals Your Monthly Cost	$25.94	$86.76	(Deduction one time per month, on 25th)
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
101
102
103
104