Attachment 6_Transaction Volumes_vF.xlsx

32 KB Posted

Attached to
RFP-PERSONNEL ACTION REQUEST (PAR), PAYROLL & BENEFITS SERVICES (PPB2)
Solicitation number
1331L520R13ES0008
Issued by

About this file

Written by GovTribe AI ·

This document contains an attachment to a federal solicitation for personnel action request, payroll and benefits transaction processing services. The Department of Commerce's Enterprise Services intends to award an indefinite delivery, indefinite quantity contract to provide PAR, payroll and benefits processing for offices across the Department of Commerce using existing technology. The attachment includes projected transaction volumes for 2021 by quarter, pay period, bureau and transaction type to provide incumbent contractors with information to develop their proposals. It also contains historical HRIT service and contact center volumes from 2019. Proposals for this opportunity are due no later than June 8, 2020 by 4:00 PM EDT.

View the file

Other files

File Type Posted
Q_A Supplement.pdf PDF
SF1449-PPB2.pdf PDF
Attachment 1_Transition Services_PWS_rev.1.docx DOCX document
Attachment 2_Operational Services_PWS_rev.1.docx DOCX document
Attachment 7_Key Personnel Role Descriptions_rev.1.docx DOCX document
Questions and Answers PPB2_rev.1.xlsx XLSX spreadsheet
Solicitation - PPB2_rev.1.docx DOCX document
Attachment 10_Pricing Template_vF.xlsx XLSX spreadsheet
Attachment 8_Question Template_vF.xlsx XLSX spreadsheet
Attachment 7_Key Personnel Role Descriptions_vF.docx DOCX document
Attachment 3_Target Service Level Agreements_vF.docx DOCX document
Attachment 5_ES HR PPB Scope Document_vF.docx DOCX document
Attachment 1_Transition Services_PWS_vF.pdf PDF
Attachment 9_Staffing Model Template_vF.xlsx XLSX spreadsheet
Attachment 2_Operational Services_PWS_vF.pdf PDF
Attachment 4_Process Map Overview_vF.xlsx XLSX spreadsheet
Solicitation - PPB2_vF_05082020.pdf PDF
Show all 17

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Cover

ATTACHMENT 6:

Projected 2021 DOC Enterprise Services PAR, Payroll, and Benefits (PP&B) Volumes and Historical HRIT/Contact Center Volumes

Description: The information provided in the PPB Volumes tabs consist of the expected volumes for PAR, Payroll, and Benefits for calendar year 2021, which is based on historical volumes in 2018 and 2019 and other assumptions regarding volume changes (e.g., expected hiring surges). The PP&B volume breakdowns provided are by Quarter, Pay Period, Bureau, and Request Type. The "Contact Center & HRIT Volumes" tab provides historical HRIT service volumes and contact center data from 2019. ES expects HRIT and contact center volumes to remain steady for 2021.
Data Sources:

• Data for the expected PP&B volumes are based on historical data pulled from NFC and ServiceNow systems

• Data for all Contact Center and HRIT volumes are from ServiceNow

Notes:

• Please note that DOC often experiences hiring fluctuations which can affect both PP&B and HRIT/Contact Center volumes.

• Volumes are based on current in-scope bureaus only.

PPB Volumes by Quarter Projected 2021 Volumes by Quarter

PARQ 1 - 2Q 3 - 4Total
Projected Volume208632047541338
PayrollQ 1 - 2Q 3 - 4Total
Projected Volume7186650013686
BenefitsQ 1 - 2Q 3 - 4Total
Projected Volume218723774564

PPB Volumes by Pay Period Projected 2021 Volumes by Pay Period

PARPay PeriodTotalPP26PP01PP02PP03PP04PP05PP06PP07PP08PP09PP10PP11PP12PP13PP14PP15PP16PP17PP18PP19PP20PP21PP22PP23PP24PP25
Projected Volume41338164011248561224148917521323122018782691262815741466153716491699141119852596117310641000162723961547792
PayrollPay PeriodTotalPP26PP01PP02PP03PP04PP05PP06PP07PP08PP09PP10PP11PP12PP13PP14PP15PP16PP17PP18PP19PP20PP21PP22PP23PP24PP25
Projected Volume1368613920022425751156623321051410405404400333413415390524410451527482467340748642691
BenefitsPay PeriodTotalPP26PP01PP02PP03PP04PP05PP06PP07PP08PP09PP10PP11PP12PP13PP14PP15PP16PP17PP18PP19PP20PP21PP22PP23PP24PP25
Projected Volume456414824180117150161179162199200185192175168174165198210174148197219175164211176

PPB Volumes by Bureau Projected 2021 Volumes by Bureau

PARBy BureauTotalBEABISCENSUSEDAFNITAMBDANOAANTIAOS
Projected Volume41338429687101232833312449135248915471463
PayrollBy BureauTotalBEABISCENSUSEDAFNITAMBDANOAANTIAOS
Projected Volume13686212174346712455496198217124799
BenefitsBy BureauTotalBEABISCENSUSEDAFNITAMBDANOAANTIAOS
Projected Volume4564106651294635224711213356537

PPB Volumes by Request Type Projected 2021 Volumes by Request Type

PARRequest TypeProjected VolumePayrollRequest TypeProjected VolumeBenefitsRequest TypeProjected Volume
PAR100 - CAREER APPT62Bank Account Allotments16Change in Beneficiary521
101 - CAREER-COND APPT883Cancellation of Union Dues15Change in Service Computation Date585
108 - TERM APPT NTE615Change in Address57Change in Veterans Preference3
115 - APPT NTE124Change in Veterans Preference1FEGLI: Open Season4
130 - TRANSFER443Changing Direct Deposit Information40FEHB - Open Season209
140 - REINS CAREER41Compensatory Time Payout483FEHB: Enroll/Change in Coverage due to a Qualifying Life Event1255
141 - REINS CAREER COND9Credit Hours Payout21HR Reference Library1
142 - SES CAREER APPT10Debt Collections59Mandatory Benefits Enrollment62
145 - TRANSFER SES CAREER8Earnings and Leave Statement Information137Military Service Deposits, Civilian Service Deposits and Redeposits303
146 - SES NONCAREER11Employee Garnishments & Court Orders485New Hires: Benefits and Pay Enrollment153
147 - TRANSFER SES NONCAREER2Enrollment in Union Dues49Other - HR1082
170 - EXC APPT529Federal Tax Withholding35Requesting a Name Change109
171 - EXCEPTED APPT NTE304Fitness Center Deduction375Setting Up HSA Allotment1
292 - RETURN TO DUTY218Garnishments42Submit Employee Settlement1
300 - RETIREMENT MANDATORY3HR Reference Library1Transfers: Benefits and Pay Enrollment44
301 - RETIREMENT DISABILITY19Initiate a Compensatory Time Payout478TSP Catch Up9
302 - RETIREMENT VOLUNTARY599Initiate a Credit Hours Payout12TSP Contribution Change204
303 - RETIREMENT SPECIAL OPTION1Leave Audit1141TSP Make Up17
307 - FULLRETIREMENT STATUS VOLUNTARY14Lump Sum Payout1256Total4564
312 - RESIGNATION-ILIA3Making a Combined Federal Campaign Contribution1
317 - RESIGNATION630Managing NFC Debt Collections due to Salary Overpayments471
330 - REMOVAL51Other - HR3446
350 - DEATH34Process SF-1150158
352 - TERMINATION APPT IN565Professional Liability Insurance Reimbursement382
355 - TERMINATION EXP OF APPT59Resolving Instance of Salary Non-Payment or Underpayment374
357 - TERMINATION64Restored Annual Leave850
385 - TERM DURING PROB/TRIAL PERIOD27Setting Up HCHB Parking2
450 - SUSPENSION NTE94Settlements1
460 - LWOP NTE90State Tax Withholding364
473 - ABSENT-UNIFORMED SERVICE75Student Loan Forgiveness104
500 - CONV TO CAREER APPT204Submit Earnings & Leave Statement376
501 - CONV TO CAREER COND APPT373Submit Employee Cancellation of Union Dues77
508 - CONV TO TERM APPT NTE234Submit Employee Enrollment in Union Dues559
515 - CONV TO APPT NTE54Submit Employee Pay Advance Request For New Appointments1
540 - CONV TO REINS-CAREER5Submit Employee Restored Annual Leave Request213
541 - CONV TO REINS-CAREER COND1Submit Employee Settlement9
542 - CONV TO SES CAREER APPT23Submit or Cancel Employee Fitness Center Deduction257
546 - CONV TO SES NONCAREER APPT8Submit or Cancel Employee Fitness Center Subsidy - NOAA Only1335
570 - CONV TO EXC APPT137Total13686
571 - CONV TO EXC APPT NTE50
615 - PHASED EMPLOYMENT/PHASED RETIREMENT17
702 - PROMOTION2866
703 - PROMOTION NTE1665
713 - CHG TO LOWER GRADE, LEVEL OR BAND1408
721 - REASSIGNMENT2491
760 - EXT OF APPT NTE376
765 - EXT OF TERM APPT NTE386
769 - EXT OF PROMOTION NTE397
773 - EXT OF LWOP NTE31
780 - NAME CHANGE (SEE REMARK)201
781 - CHG IN WORK SCHEDULE610
782 - CHG IN HOURS32
790 - REALIGNMENT1458
792 - CHG IN DUTY STATION97
800 - CHANGE IN DATA ELEMENT50
815 - RECRUITMENT INCENTIVE14
816 - RELOCATION INCENTIVE19
817 - STUDENT LOAN REPAYMENT34
818 - ADMIN UNCONTROLLED OVERTIME69
819 - AVAILABILITY PAY66
825 - SEPARATION INCENTIVE1
827 - RETENTION INCENTIVE22
840 - INDIVIDUAL CASH AWARD3045
841 - GROUP AWARD-CH45390
845 - TRAVEL SAVINGS INCENTIVE AWARD4
846 - INDIVIDUAL TIME-OFF AWARD3112
847 - GROUP TIME-OFF AWARD530
849 - INDIV CASH AWARD NRB8349
880 - CHG IN TENURE GROUP382
881 - FEGLI CHG1005
882 - CHG IN SCD632
883 - CHG IN VET PREF-RIF134
886 - LUMP SUM PERF PYMT RB-NILPA12
888 - DENIAL OF WITHIN CLASS INC2
889 - GROUP AWARD-OTHER132
890 - MISC PAY ADJ33
891 - PERFORMANCE BASED PAY INCREASE686
892 - IRREG PERF PAY349
893 - REG WRI885
894 - GEN ADJ1140
903 - CHG IN NON-CPDF DATA ELEMENT721
915 - HEALTH BENEFITS COVERAGE483
916 - COURT ORDERED FEHB CHANGE37
917 - ANNUITANT ADJUSTMENT8
919 - PD NUMBER CHANGE1
930 - DETAIL NTE88
931 - EXT OF DETAIL NTE31
932 - TERM OF DETAIL51
939 - CHG QTRS DEDUCTIONS8
976 - PRELIMINARY DISABILITY RETIREMENT28
984 - SHARE OF EQUIVALENT INCREASE75
Total41338

Contact Center & HRIT Volumes 2019 Historical HRIT and Contact Center Volumes

Historical HRIT Service Volumes (2019 PP01 - 2019 PP26 (01/04/2020))
Request TypesVolume January 6 - July 06Volume July 07 - January 04Total Volume
eOPF153513272862
HRC335027156065
webTA48821972685
Access Requests232206438
Historical HR Contact Volumes (2019 PP01 - 2019 PP26 (01/04/2020))
VolumesVolume January 6 - July 06Volume July 07 - January 04Total VolumeNumber of Contacts to Incidents
Calls to Service Center18657191843784124319
Emails to Service Center1312074112053120531
Portal to Service Center800264911449314493

File details come from the government source that posted it. Updated .