Attachment 9_Staffing Model Template_vF.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- 1331L520R13ES0008
About this file
This document contains a staffing model template and instructions for a federal contract solicitation seeking personnel action request, payroll, and benefits processing services. The Department of Commerce intends to award an indefinite delivery, indefinite quantity contract to provide PAR, payroll, and benefits transaction processing support across the agency. Responses are due by June 8, 2020, with the contract period covering transition services in year one followed by operational services for years two through six. Bidders must complete the staffing model template identifying labor categories, key personnel, and hours by task order and year to support the design, build, and operations of the required services.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Q_A Supplement.pdf | ||
| SF1449-PPB2.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 6_Transaction Volumes_vF.xlsx | XLSX spreadsheet | |
| 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 | ||
| Attachment 2_Operational Services_PWS_vF.pdf | ||
| Attachment 4_Process Map Overview_vF.xlsx | XLSX spreadsheet | |
| Solicitation - PPB2_vF_05082020.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
Text version
Instructions
ATTACHMENT 9
DOC Enterprise Services 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 data as needed. Bidders should not change any formulas in cells that are not highlighted in yellow for bidders to complete. Bidders may remove the examples given in red text. |
| Transition Services Tab Instructions: |
• Bidders shall utilize this tab to provide their staffing model for Task Order 1: Transition Services (see Attachment 1), which accounts for Year 1 of the IDIQ.
• Bidders should assume a 12-month transition time period that would include multiple go-lives according to the timeline indicated in Attachment 1.
• Bidders should utilize the drop-down provided by DOC in column A to align each resource to the Task Order component (i.e., Design & Build or Operations) that the resource will be supporting. Bidders should display any resources supporting both Task Order components as separate rows and align hours to the appropriate component.
• Bidders should utilize the LCATs provided by DOC in the Labor Category Descriptions tab to complete column B; these LCATs are included in a dropdown menu for column B.
• Bidders should reference the Key Personnel detailed in the IDIQ Request for Proposal (RFP) in order to identify which rows are aligned to Key Personnel, utilizing column C. If there is not a Key Personnel aligned to the row, please type "NA".
• Bidders should have one row for each key personnel but then for all other personnel, bidders do not need to add a row for every resource (FTE). Only one row is needed for each labor category for the additional personnel (e.g., if the bidder needs 2 Senior Process Consultants for Design & Build only then add Senior Process Consultant in a row and put 320 hours for the first 6 months).
• Column P will auto populate once the bidders complete the necessary cells.
Operational Services Tab Instructions:
• Bidders shall utilize this tab to provide their staffing model for Task Order 2: Operational Services (see Attachment 2), which accounts for Years 2 - 6 of the IDIQ
• Bidders should utilize the LCATs provided by DOC in the Labor Category Descriptions Tab to complete column A; these LCATs are included in a dropdown menu for column A.
• Bidders should utilize the Key Personnel from the 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 have one row for each key personnel but then for all other personnel, bidders do not need to add a row for every resource (FTE). Only one row is needed for each labor category for the additional personnel (e.g., if the bidder needs 5 Junior Benefits Specialists for all 5 years of Task Order 2, the bidder should add 1 row for the labor category and include 9,600 hours in columns C through G).
• Bidders should be sure to complete all four sections of this tab including Payroll, Personnel, Benefits and HRIT System Administration.
• If certain resources (e.g., the Program Manager) will be involved in all four services, please split their hours across all four services as appropriate. See the examples in red for an illustration.
Transition Services (TO 1)
| Task Order 1: Transition Services Staffing Model | ||||
| Component | Rate Card Labor Category (DOC provided) | Key Personnel Category | ||
| (if applicable) | Year 1 Monthly Hours | Transition Services |
Total Hours
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |||||
| 1. Design & Build | Program Manager | Transition Lead | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 1920 | |
| 2. Operations | Senior Process Consultant | NA | 160 | 160 | 320 | 320 | 320 | 320 | 320 | 320 | 320 | 320 | 2880 | |||
| 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 | ||||||||||||||||
| 1. Design & Build Total Hours | 1,920.00 | |||||||||||||||
| 2. Operations Total Hours | 2,880.00 | |||||||||||||||
| Grand Total Hours | ||||||||||||||||
| Sum of Design & Build and Operations Total Hours | 4,800.00 |
Operational Services (TO 2)
| Task Order 2: Operational Services Staffing Model | |||||
| PAR Processing Operations | |||||
| Rate Card Labor Category | |||||
| (DOC provided) | Key Personnel Category | ||||
| (if applicable) | Year 2 Total Hours | Year 3 Total Hours | Year 4 Total Hours | Year 5 Total Hours | Year 6 Total Hours |
| Senior Personnel Specialist | PAR Lead | 1920 | 1920 | 1920 | 1920 | 1920 |
| Junior Personnel Specialist | NA | 5760 | 5760 | 5760 | 5760 | 5760 |
| Senior Program Manager | Operations Director/ Center Lead | 480 | 480 | 480 | 480 | 480 |
| Senior Call Center Service Representative | Call Center Lead | 480 | 480 | 480 | 480 | 480 |
| Payroll Processing Operations | ||||||
| Rate Card Labor Category | Key Personnel Category | Year 2 Total Hours | Year 3 Total Hours | Year 4 Total Hours | Year 5 Total Hours | Year 6 Total Hours |
| Senior Payroll Specialist | Payroll Lead | 1920 | 1920 | 1920 | 1920 | 1920 |
| Junior Payroll Specialist | NA | 5760 | 5760 | 5760 | 5760 | 5760 |
| Senior Program Manager | Operations Director/ Center Lead | 480 | 480 | 480 | 480 | 480 |
| Senior Call Center Service Representative | Call Center Lead | 480 | 480 | 480 | 480 | 480 |
| Benefits Processing Operations | ||||||
| Rate Card Labor Category | Key Personnel Category | Year 2 Total Hours | Year 3 Total Hours | Year 4 Total Hours | Year 5 Total Hours | Year 6 Total Hours |
| Senior Benefits Specialist | Benefits Lead | 1920 | 1920 | 1920 | 1920 | 1920 |
| Junior Benefits Specialist | NA | 5760 | 5760 | 5760 | 5760 | 5760 |
| Senior Program Manager | Operations Director/ Center Lead | 480 | 480 | 480 | 480 | 480 |
| Senior Call Center Service Representative | Call Center Lead | 480 | 480 | 480 | 480 | 480 |
| HRIT System Administration Operations | ||||||
| Rate Card Labor Category | Key Personnel Category | Year 2 Total Hours | Year 3 Total Hours | Year 4 Total Hours | Year 5 Total Hours | Year 6 Total Hours |
| HRIT System Administration Senior Specialist | HRIT Administration Lead | 1920 | 1920 | 1920 | 1920 | 1920 |
| HRIT System Administration Junior Specialist | NA | 5760 | 5760 | 5760 | 5760 | 5760 |
| Senior Program Manager | Operations Director/ Center Lead | 480 | 480 | 480 | 480 | 480 |
| Senior Call Center Service Representative | Call Center Lead | 480 | 480 | 480 | 480 | 480 |
Labor Category Descriptions Labor Category Descriptions
DOC Labor Category Name DOC Labor Category Description Years of Experience
| Senior Program Manager | Has over 15 years of program management experience. Provides overall program success through oversight of all task orders. | 15 |
| HR Subject Matter Expert | Has over 12 years of experience in providing end-to-end HR transactional services. Provides deep HR expertise in federal HR GPPA rules. | 12 |
| Senior Payroll Specialist | Over 10 years of federal payroll experience. Provides senior level payroll processing services and may oversee a team. | 10 |
| Senior Benefits Specialist | Over 10 years of federal benefits experience. Provides senior level benefits processing services and may oversee a team. | 10 |
| Senior Personnel Specialist | Over 10 years of federal personnel processing experience. Provides senior level personnel processing services and may oversee a team. | 10 |
| Senior Process Consultant | Has over 8 years of reengineering business processes. Analyzes processes for most effective method of delivery and efficiencies. | 8 |
| Program Manager | Has over 8 years of program management experience. Manages PMBOK processes to oversee large complex programs. | 8 |
| Quality Assurance Specialist | Has over 8 years of quality management experience. Provides audits of transactional services and quality reviews to ensure accuracy of transactions. | 8 |
| Senior Call Center Service Representative | Has over 8 years of call center experience. Provides deep analysis of customer issues based on HR knowledge. | 8 |
| Document Management Specialist | Has over 5 years in providing document management services. Provides operational support to maintain and manage HR records. | 5 |
| Junior Process Consultant | Has over 3 years of reengineering business processes. Analyzes processes for most effective method of delivery and efficiencies. | 3 |
| Junior Payroll Specialist | Over 3 years of payroll experience. Provides payroll analysis and processes payroll transactions. | 3 |
| Junior Benefits Specialist | Over 3 years of benefits experience. Provides benefits analysis and processes benefits transactions. | 3 |
| Junior Personnel Specialist | Over 3 years of personnel processing experience. Provides personnel processing transactional services. | 3 |
| Junior Call Center Service Representative | Has over 1 year of call center experience. Provides answer to scripted customer inquiries and excellent customer service. | 1 |
| Document Management Junior Specialist | Has over 3 years in providing document management services. Provides operational support to maintain and manage HR records. | 3 |
| HRIT System Administration Senior Specialist | Has over 5 years of system administration experience. Answers and resolves end-user functional technology inquiries. | 5 |
| HRIT System Administration Junior Specialist | Has over 3 years of system administration experience. Answers and resolves end-user functional technology inquiries. | 3 |
| Technology Support Senior Specialist | Has over 5 years of technology support services. Provides data integrity services and supports technology-related process improvement efforts (e.g., automation where appropriate). | 5 |
| Technology Support Junior Specialist | Has over 3 years of technology support services. Provides data integrity services and supports technology-related process improvement efforts (e.g., automation where appropriate). | 3 |
| HR Assistant | Has knowledge of federal HR processes for providing Payroll, PAR, and Benefits processing. | 0 |
File details come from the government source that posted it. Updated .