SLIP Calculation Estimate Worksheet

	A	C	D	E	F	G	H	J	K	N
1	SLIP LEAVE INSURANCE PROGRAM CALCULATION WORKSHEET
2	TO BE USED TO ESTIMATE SLIP BALANCE
3
4
5
6
7
8	Name
9
10	18-Digit Position Number
11
12	Retirement Date
13
14
15	CALCULATION UPON RETIREMENT
16
17	Biweekly Base			$3,063.21
18	Special Duty Pay			$0.00
19	Lead Worker Pay			$0.00
20	Extra Duty Pay			$0.00
21	Educational Differential			$0.00
22	Volunteer Firefighter Pay			$0.00
23	Longevity Pay			$0.00
24	Shift Differential			$0.00
25	Med Passer Pay			$0.00
26	Total Regular Biweekly Pay			$3,063.21
27
28
29	$2,936.00	/ 80		$38.31
30	Total Regular Biweekly Pay Hourly Rate
31
32	1577	+	100	-	0	=		*This balance is used to determine applicable Sick Leave Conversion Rate
33	Beginning Sick Hours Balance Earned Used Total Sick Hours Balance
34
35	$36.70	X	782		=				$28,699.40
36	Hourly Rate								Total $ Value of Sick Balance
37
38	Total Value of Sick Balance, Not to Exceed $2,000.00									(or total value, if less than $2,000.00)
39	(to be paid with last warrant)								Sick Balance $ to be Paid Upon Retirement
40
41	$28,699.40	-	$2,000.00			=	$26,699.40
42	Total Sick Hours Balance Amount Paid						Remaining Dollar Balance
43
44
45	COMPLETE ONE OF THE FOLLOWING LINES, DEPENDING ON THE EMPLOYEE'S APPLICABLE RATE:
46
47									* Use this amount if the Total Sick Hours Balance shown above is:
48
49	$26,699.40	X	100%		=	$26,699.40			Over 1,500 hours
50	Remaining Dollar Balance		Applicable Rate of 100%			$ Value of Calculated Sick Leave Balance
51
52	$26,699.40	X	80%		=	$21,359.52			Over 750 hours to 1,500 hours
53	Remaining Dollar Balance		Applicable Rate of 80%			$ Value of Calculated Sick Leave Balance
54
55	$26,699.40	X	60%		=	$16,019.64			Zero to 750 hours
56	Remaining Dollar Balance		Applicable Rate of 60%			$ Value of Calculated Sick Leave Balance
57
58
59
60
61
62	This calculation worksheet is to be used as a tool to estimate the value of an employee's Sick Leave Insurance Program balance upon their retirement.
63	A final calculation will be completed upon completion of all termination documents and the employee's last timesheet.
64	Factors impacting the final calculation include the employee's sick balance, accruals and usages up to the last day of their employment, as well as any changes in pay.
65	Only cells highlighted in yellow in the "Calculation Upon Retirement" section need to be populated. All other cells in the spreadsheet will automatically recalculate based
66	on values entered.
67
68
69
70	SLIP Calculation Estimate 06-14-06.xls
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