AEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Hire date and salary must be entered.
4
Bargaining Unit, Year of phase-in, Medical Coverage Plan, Medical Coverage
5
Type, Prescription Coverage Plan, Prescription Coverage Type, Dental
6
Coverage Plan, Dental Coverage Type, and Months worked must
7
be selected from the drop-down menus.
8
The calculation will provide the approximate monthly deduction
9
exclusive of any coverage buy-up.
10
Please note:
11
Some Coverage Plans or Coverage Types may be restricted
12
by hire date as per Collective Bargaining Agreements.
13
Based upon Bargaining Unit selected and Hire Date entered,
14
the drop-down menus restrict options to those allowed by
15
Collective Bargaining Agreements.
16
17
18
Buy-up of coverage is not included in the calculation and must be
19
added to deduction calculated below.
20
21
Do not attempt to use this spreadsheet to calculate estimates of
22
future deductions as Salary and premium cost are at current rates.
23
24
25
Bargaining UnitHire Date4/28/2025
26
WTSSSPA
27
Year of phase -in1
28
29
Enter Salary $ 65,520
30
31
Select Medical Coverage Plan
POS
32
Select Medical Coverage Type
Single
33
Medical Premium Contribution %
7.25%
34
Medical Premium Rate 14,076.00 Per pay rate
35
Medical Premium Contribution Amount
 1,020.51 20 51.03
36
37
Select Prescription Coverage Plan
Generic $10
38
Select Prescription Coverage Type
Family
39
Prescription Premium Contribution %
4.75%
40
Prescription Premium Contribution Rate
 9,076.80 Per pay rate
41
Prescription Premium Contribution Amount
 431.15 20 21.56
42
43
Select Dental Coverage Plan
PPO
44
Select Dental Coverage Type
Family
45
Dental Premium Contribution %
4.75%
46
Dental Premium Contribution Rate
 1,084.20 Per pay rate
47
Dental Premium Contribution Amount
 51.50 20 2.57
48
49
Medical tax of 1.5%: of salary
$982.80
50
51
Greater of Premium Contribution and 1.5% of salary
$1,503.16
52
53
Months worked 10
54
55
Amount per pay$75.16 75.16
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