Usps Fers Part -time Regular And Part-time Flexible Spreadsheet
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Usps Fers Part -time Regular And Part-time Flexible Spreadsheet as PDF for free.
More details
- Words: 303
- Pages: 4
EXAMPLE: (Source F-28-FERSPart-timeService-2006.pdf) 1986 - 1991 Part-time : 30 hours per week 1991 - 2006 Full-time Full-time Average Salary = $50,000 per year Employee retires at age 60 with 20 years of total service
<---------for web source PDF
Compute the full-time annuity: 1986 - 2006 = 20 years = 20% 20% of the full-time high-3 average salary 20% of $50,000 = $10,000 per year Determine proration factor: 5 years @ 30 hours/week x 52 weeks = 7,800 hours + 15 years @ 40 hours/week x 52 weeks = 31,200 hours 20 = 39,000 hours Divided by 20 years @ 40 hours/week x 52 weeks = 41,600 hours (7,800 + 31,200)/41,6000 =39,000/41,600 =93.75% Multiply full-time annuity by proration factor: $10,000 x 93.75% = $9,375
Enter Values on liteblue cells Gross Retirement: Retirement Date: enter Employment Date: enter
---> --->
Calculation of HIGH-3 Salary: Must be successive 3 yrs. Begin year of High ---------------------> Middle year of High --------------------> Third year of High ----------------------->
Yearly 8,517.95 11/30/2009 8/5/1985
Year 2001 2002 2003 Sum Average 3
Determination of Proration Factor Years of HIGH YR HRS/WK ---------> Years of MID YR HRS/WK ----------> Years of LOW YR HRS/WK -------->
Years 3 2 19 24 29,120
Monthly Yrs. of Service 0.00 24.34
Base Salary 33,000.00 43,000.00 29,000.00 105,000.00 35,000.00
Yearly: 0.00 Hrs./Wk 40 30 20
Monthly 0.00 Weeks/Yr 52 52 52 Total: 40 52
divided by
49,920
% 58.33 Bad formula for Part tim Hours 6,240 3,120 19,760 29,120 49,920 % 0.58 58.33
How Years of Service is Calculated: No. of Days Years of Service 05-Aug-85 30-Nov-09 8883 24.34
Bad formula for Part time maybe ok for Flexi….. Enter the data from taken from the PDF photo above. by replacing JACK's job history.. the percentage will match 93.75% % Years Hrs./Wk 58.33 5 30 0 0 15 40
<---------for web source PDF
Compute the full-time annuity: 1986 - 2006 = 20 years = 20% 20% of the full-time high-3 average salary 20% of $50,000 = $10,000 per year Determine proration factor: 5 years @ 30 hours/week x 52 weeks = 7,800 hours + 15 years @ 40 hours/week x 52 weeks = 31,200 hours 20 = 39,000 hours Divided by 20 years @ 40 hours/week x 52 weeks = 41,600 hours (7,800 + 31,200)/41,6000 =39,000/41,600 =93.75% Multiply full-time annuity by proration factor: $10,000 x 93.75% = $9,375
Enter Values on liteblue cells Gross Retirement: Retirement Date: enter Employment Date: enter
---> --->
Calculation of HIGH-3 Salary: Must be successive 3 yrs. Begin year of High ---------------------> Middle year of High --------------------> Third year of High ----------------------->
Yearly 8,517.95 11/30/2009 8/5/1985
Year 2001 2002 2003 Sum Average 3
Determination of Proration Factor Years of HIGH YR HRS/WK ---------> Years of MID YR HRS/WK ----------> Years of LOW YR HRS/WK -------->
Years 3 2 19 24 29,120
Monthly Yrs. of Service 0.00 24.34
Base Salary 33,000.00 43,000.00 29,000.00 105,000.00 35,000.00
Yearly: 0.00 Hrs./Wk 40 30 20
Monthly 0.00 Weeks/Yr 52 52 52 Total: 40 52
divided by
49,920
% 58.33 Bad formula for Part tim Hours 6,240 3,120 19,760 29,120 49,920 % 0.58 58.33
How Years of Service is Calculated: No. of Days Years of Service 05-Aug-85 30-Nov-09 8883 24.34
Bad formula for Part time maybe ok for Flexi….. Enter the data from taken from the PDF photo above. by replacing JACK's job history.. the percentage will match 93.75% % Years Hrs./Wk 58.33 5 30 0 0 15 40
Related Documents
Student And Part-time Job
June 2020 0
Usps Letter
May 2020 0
Spreadsheet
June 2020 13
