Attachment 5_Draft Pricing Template_vF.xlsx

XLSX spreadsheet 28 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

The document is a Draft Pricing Template for a Department of Commerce (DOC) Human Resources Personnel Action Requests (PAR), Payroll, and Benefits (PP&B) Processing Services contract. The template provides detailed pricing guidance across three primary tabs: Rate Card, Transition Pricing, and Transactional Pricing, with specific instructions for bidders to complete yellow-highlighted cells while preserving existing formulas. The pricing template covers 15 labor categories ranging from Senior Program Manager to Technology Support Analyst, with requirements to utilize 738X schedule labor categories and provide discounted rates across a five-year contract period.

The template instructs bidders to provide fully loaded transaction costs for key services including Payroll, Personnel Actions, Benefits Processing, and HRIT System Administration, mapped to specific sections of the Statement of Work (SOW). Labor categories require bidders to complete rate information, with no yearly increase specified (0% factor), and include detailed descriptions of experience levels for each role. The template allows for some flexibility in transition pricing, permitting bidders to add labor category rows but limiting additions to distinct categories rather than individual resources, with specific guidance on populating hourly rates, transition timeframes, and associated costs.

View the file

Other files

File	Type	Posted
DOC_SSPO_HR RFI_F.pdf	PDF	Dec 1, 2025
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 6_Draft Staffing Model Template_vF.xlsx	XLSX spreadsheet	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 5: DRAFT DOC OHRM PAR, Payroll, and Benefits (PP&B) Pricing Template

Overall Instructions: Bidders should complete all cells that are highlighted in yellow for all tabs. Bidders should not change any formulas in cells that are not highlighted in yellow for bidders to complete.

Rate Card Tab Instructions:

• Include yearly increase in cell A2 - the yearly increase should be the same each year

• Bidders should complete columns C and D utilizing their 738X schedule

• Bidders should provide any discount for each Labor Category utilizing column E

• Bidders should not add rows to this tab, as the government believes these are the necessary labor categories to deliver the PP&B program

• Columns F through J will auto populate once the bidders complete the necessary cells Transition Pricing Tab Instructions:

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

• Bidders should utilize the Key Personnel from the draft RFP 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 use the discounted Year 1 and 2 rates from the Rate Card tab to complete columns C and D

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

• Bidders can add rows for additional labor categories but 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 T through W will auto populate once the bidders complete the necessary cells Transactional Pricing Tab Instructions:

• Bidders should provide a fully loaded cost per transaction for each of the transactional services identified in column A

• Costs per transaction should be reflective of the staffing model provided in volume 1 and inclusive of all costs associated with each service transaction as defined in 3.2 of the SOW (see table below for references)

Services	SOW Mapping
Payroll	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	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	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 System Administration (service requests)	3.2.3.1 HRIT Systems Administration

Rate Card

Yearly Increase Factor
0%
DOC Labor Category Name	DOC Labor Category Description	Bidder 738X Schedule LCAT Name	Schedule Rate	Discount Rate	Year 1	Year 2	Year 3	Year 4	Year 5
Senior Program Manager	Has over 10 years of program management experience. Provides overall program success through oversight of all task orders.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Program Manager	Has over 7 years of program management experience. Manages PMBOK processes to oversee large complex programs.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
HR Subject Matter Expert	Has over 10 years of experience in providing end-to-end HR transactional services. Provides deep HR expertise in federal HR GPPA rules.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Senior Process Consultant	Has over 8 years of reengineering business processes. Analyzes processes for most effective method of delivery and efficiencies.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Junior Process Consultant	Has over 3 years of reengineering business processes. Analyzes processes for most effective method of delivery and efficiencies.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Senior Payroll Specialist	Over 10 years of federal payroll experience. Provides senior level payroll processing services and may oversee a team.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Junior Payroll Specialist	Over 3 years of payroll experience. Provides payroll analysis and processes payroll transactions.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Senior Benefits Specialist	Over 10 years of federal benefits experience. Provides senior level benefits processing services and may oversee a team.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Junior Benefits Specialist	Over 3 years of benefits experience. Provides benefits analysis and processes benefits transactions.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Senior Personnel Specialist	Over 10 years of federal personnel processing experience. Provides senior level personnel processing services and may oversee a team.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Junior Personnel Specialist	Over 3 years of personnel processing experience. Provides personnel processing transactional services.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
HR Assistant	Has knowledge of federal HR processes for providing Payroll, PAR, and Benefits processing .		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Document Management Specialist	Has over 5 years in providing document management services. Provides operational support to maintain and manage HR records.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Senior Call Center Service Representative	Has over 8 years of call center experience. Provides deep analysis of customer issues based on HR knowledge.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Junior Call Center Service Representative	Has over 1 year of call center experience. Provides answer to scripted customer inquiries and excellent customer service.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Quality Assurance Specialist	Has over 8 years of quality management experience. Provides audits of transactional services and quality reviews to ensure accuracy of transactions.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Technology Support Analyst	Has over 3 years of technology support services. Provides data integrity services and answer end-user functional technology inquiries.		$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Transition Pricing

Labor Category (DOC Provided)	Key Personnel Category (if applicable)	Year 1 Rate	Year 2 Rate	Transition Period Monthly Hours															Year 1 Total Hours	Year 2 Total Hours	Year 1 Total Costs	Year 2 Total Costs
				1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
EXAMPLE 1 - Transition Lead	Transition Lead	$ 100.00	$ 103.00	160	160	160	160	160	160	160	160	160	160	160	160	160	160	160	1920	480	$ 192,000.00	$ 49,440.00
EXAMPLE 2 - Senior Process Consultant	NA	$ 120.00	$ 127.00					160	160	160	320	320	320	320	320	320	320	160	2080	800	$ 249,600.00	$ 101,600.00
																			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
																			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	$ 441,600.00	$ 151,040.00

Transactional Pricing

Services	Cost per Transaction
Payroll
Personnel - Mass Actions
Personnel - Individual Actions
Benefits
HRIT Administration

Sheet5

	$10,805,300.00	$432,212	4%
	$6,435,966.67	$193,079	3%
	$5,248,050.00	$104,961	2%
	$2,608,200.00	$78,246	3%
	$3,916,692.31	$509,170	13%
	$6,791,800.00	$203,754	3%
	$9,575,885.00	$1,915,177	20%
	$10,247,268.18	$2,254,399	22%
	$5,355,512.50	$428,441	8%
	$15,197,400.00	$151,974	1%
	$5,760,250.00	$460,820	8%
	$4,484,017.78	$2,017,808	45%
	$5,877,023.53	$999,094	17%
	$6,332,509.09	$1,393,152	22%
$103,383,537.78	$32,307,355.56	$2,907,662	9%
	$5,916,635.00	$1,183,327	20%
	$11,384,960.00	$569,248	5%
	$2,698,580.33	$1,646,134	61%
	$8,179,766.67	$490,786	6%
	$6,809,070.00	$680,907	10%

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