Attachment 6_Draft Staffing Model Template_vF.xlsx

XLSX spreadsheet 23 KB Posted Dec 1, 2025

Attached to: RFI-Human Resources PAR, Pay and Benefits Processing Service
Solicitation number: 1331L5-26-S-13OS-0002
Issued by: Department of Commerce Office of the Secretary

About this file

Written by GovTribe AI · Dec 1, 2025

This file is a Draft Staffing Model Template for the Department of Commerce's Personnel Action Requests (PAR), Payroll, and Benefits (PP&B) Services. The Excel template provides detailed instructions for bidders to complete a staffing model across two primary tabs: Transition Services and Transactional Services. Bidders are required to use predefined Labor Categories (LCATs) from a Rate Card, identify Key Personnel, and populate hours for various functional areas including Payroll Operations, Personnel Operations, Benefits Operations, and HRIT Operations.

The template specifies that bidders should not add a row for every resource, but instead use one row per labor category and indicate hours across different transition and operational periods. The template covers a potential five-year contract period, with specific instructions for populating monthly hours during the transition phase and subsequent years. Notably, this template is part of a Request for Information (RFI) issued by the Department of Commerce to conduct market research for PP&B services, with the understanding that this document does not guarantee a future contract and is purely for information gathering purposes.

View the file

Other files

File	Type	Posted
Attachment 4_Draft Projected PPB and Call Center Workload Volumes_vF.xlsx	XLSX spreadsheet	Dec 1, 2025
Attachment 3_Draft Role Descriptions_vF.pdf	PDF	Dec 1, 2025
Attachment 2_Draft Service Level Agreements_vF.pdf	PDF	Dec 1, 2025
Attachment 1_Draft Program Requirements and Evaluation Approach_vF.pdf	PDF	Dec 1, 2025
Attachment 5_Draft Pricing Template_vF.xlsx	XLSX spreadsheet	Dec 1, 2025
DOC_SSPO_HR RFI_F.pdf	PDF	Dec 1, 2025

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.

Instructions

Attachment 6: DRAFT DOC OHRM PAR, Payroll, and Benefits (PP&B) Staffing Model Template

Overall Instructions: Bidders should complete all cells that are highlighted in yellow for all tabs. Bidders can add rows for additional labor categories as needed. Bidders should not change any formulas in cells that are not highlighted in yellow for bidders to complete.

Transition Services Tab Instructions:

• Bidders should utilize the LCATs provided by DOC, from the Rate Card Tab in the Pricing Template, to complete column A

• Bidders should utilize the Key Personnel from the Terms and Conditions to identify which rows are aligned to Key Personnel, utilizing column B. If there is not a Key Personnel aligned to the row please type "NA".

• Bidders should utilize the transition timeframe provided in the draft Terms and Conditions to determine the hours associated with the transition for each month

• Bidders do not need to add a row for every resource (FTE). Only 1 row is needed for each labor category (e.g., if the bidder needs 2 Senior Process Consultants for the first 5 months of transition then add Senior Business Consultants in a row and put 320 hours for the first 5 months of the transition - columns E through S)

• Columns R and S will auto populate once the bidders complete the necessary cells Transactional Services Tab Instructions:

• Bidders should utilize the LCATs provided by DOC, from the Rate Card Tab from the Rate Card Tab in the Pricing Template, to complete column A

• Bidders should align the LCAT to the corresponding section of the SOW in column C using the SOW mapping table below

• Bidders do not need to add a row for every resource (FTE), only 1 row is needed for each labor category (e.g., if the bidder needs 5 Junior Benefits Specialists the bidder should 1 row for the labor category and include 10,000 hours in columns I through M)

• Bidders should be sure to complete all four sections of this tab including Payroll, Personnel, Benefits and Technology

Functional Area	SOW Mapping
Payroll Operations	3.2.1.1 Payroll Processing; ALL 3.2.2 Operations Management Services elements (3.2.2.1 through 3.2.2.5) associated with Payroll processing
Personnel Operations	3.2.1.2 Payroll Processing; ALL 3.2.2 Operations Management Services elements (3.2.2.1 through 3.2.2.5) associated with PAR processing
Benefits Operations	3.2.1.3 Payroll Processing; ALL 3.2.2 Operations Management Services elements (3.2.2.1 through 3.2.2.5) associated with Benefits processing
HRIT Operations	3.2.3.1 HRIT Systems Administration

Transition Services

Rate Card Labor Category	Key Personnel Category	Transition Period Monthly Hours															Year 1 Total Hours	Year 2 Total Hours
		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
EXAMPLE 1 - Transition Lead	Transition Lead	160	160	160	160	160	160	160	160	160	160	160	160	160	160	160	1920	480
EXAMPLE 2 - Senior Process Consultant	NA					160	160	160	320	320	320	320	320	320	320	160	2080	800
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
																	0	0
													Totals:				$ 4,000.00	$ 1,280.00

Transactional Services

Payroll Operations
Rate Card Labor Category	Key Personnel Category	Related SOW Element	Year 1 Total Hours	Year 2 Total Hours	Year 3 Total Hours	Year 4 Total Hours	Year 5 Total Hours

EXAMPLE 1 - Senior Payroll Specialist	Payroll Lead	3.2.1.2	1880	1880	1880	1880	1880
EXAMPLE 2 - Junior Payroll Specialist	NA	3.2.1.2	1880	1880	1880	1880	1880
EXAMPLE 3 - Program Manager	Operations Director/ Center Lead	3.2.2.1	400	400	400	400	400
EXAMPLE 4 - Senior Call Center Service Rep.	Call Center Lead	3.2.2.5	1880	1880	1880	1880	1880

Personnel Operations
Rate Card Labor Category	Key Personnel Category	Related SOW Element	Year 1 Total Hours	Year 2 Total Hours	Year 3 Total Hours	Year 4 Total Hours	Year 5 Total Hours

Benefits Operations
Rate Card Labor Category	Key Personnel Category	Related SOW Element	Year 1 Total Hours	Year 2 Total Hours	Year 3 Total Hours	Year 4 Total Hours	Year 5 Total Hours

HRIT Operations
Rate Card Labor Category	Key Personnel Category	Related SOW Element	Year 1 Total Hours	Year 2 Total Hours	Year 3 Total Hours	Year 4 Total Hours	Year 5 Total Hours

File details come from the government source that posted it. Updated Jul 7, 2026.