Attachment_0007_Sample_Task_Matrix_PWS_CAC_PKI.xlsx
XLSX spreadsheet 61 KB Posted
- Solicitation number
- Not on record
About this file
This is a staffing matrix template for offerors responding to Solicitation No. W15QKN-26-R-A016 for DEERS/RAPIDS Military ID Card, Common Access Card (CAC), and Public Key Infrastructure (PKI) Support Services. The template is designed for contractors to propose their staffing solutions across multiple performance periods: an entrance transition phase (up to 60 calendar days), a full performance period (10 months), and four optional 12-month periods. Offerors must complete separate staffing matrices for each period, identifying labor categories by level (SME, Senior, Mid-Level, or Junior-Level), place of performance, prime or subcontractor status, associated PWS tasks, performance site location, and full-time equivalent (FTE) counts with proposed hours.
The matrix requires offerors to identify any labor categories subject to Service Contract Labor Standards (SCLS) by marking an "X" in the designated column, with a corresponding SCLS Break-Out worksheet to be completed for all SCLS-covered positions using current wage determinations, occupation titles, occupation codes, and productive hours calculations. The template includes formulas for automatic calculations and allows offerors to add rows as needed while maintaining formula integrity. An Assumptions tab must be used to provide explanations and pricing assumptions in accordance with the Task Order Evaluation Plan. This is a blank template document with example entries provided as guidance for offeror completion.
View the file
Other files
Show all 37
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
Instruction for Offerors
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES |
| Solicitation No. W15QKN-26-R-A016 |
| Staffing Matrix |
Instructions for Offerors
1. Offerors shall submit their proposed staffing breakout by completing this Matrix for all proposed LCATS / Hours
2. Explanations should be provided in the Assumptions Tab of this Worksheet in accordance with the Task Order Evaluation Plan.
| OFFEROR NAME: |
| {Offeror Insert Name Here} |
&40&K02-024DRAFT
&20&K02-024DRAFT&11&K01+000
CUI-Source Selection Sensitive--See FAR 2.101 and 3.104
Labor Base Entrance Transition
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Labor Base - Entrance Transition (Up to 60 Calendar Days) | = Cell Includes Formulas; Do Not Change |
Offeror Name: {Offeror Insert Name Here}
Offerors are to propose their own staffing solution to accomplish the effort needed for the Statement of Work/Performance Work Statement for this acquisition.
Offerors are to identify any labor categories subject to the Service Contract Labor Standards (SCLS) by inputting an "X" in Column L.
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category ID # | Labor Category (specify whether SME, Senior, Mid-Level, or Junior-Level) | Place of Performance | Prime or Subcontractor Name | PWS Task or Subtask | Gov't or Contractor Site | SCLS Covered (input "X" if covered) | FTEs | Proposed Hours |
| ABC123 | Administrative Assistant | Fort Example | ABC Company | Government | X | 520 |
Labor Sub-Total 0.00
FOUO--Source Selection Sensitive--See FAR 2.101 and 3.104
Example
Labor Base Full Performance
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Labor Base - Full Performance (10 Months) | = Cell Includes Formulas; Do Not Change |
Offeror Name: {Offeror Insert Name Here}
Offerors are to propose their own staffing solution to accomplish the effort needed for the Performance Work Statement for this acquisition.
Offerors are to identify any labor categories subject to the Service Contract Labor Standards (SCLS) by inputting an "X" in Column L.
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category ID # | Labor Category (specify whether SME, Senior, Mid-Level, or Junior-Level) | Place of Performance | Prime or Subcontractor Name | PWS Task or Subtask | Gov't or Contractor Site | SCLS Covered (input "X" if covered) | FTEs | Proposed Hours |
| ABC123 | Administrative Assistant | Fort Example | ABC Company | Government | X | 520 |
Labor Sub-Total 0.00
FOUO--Source Selection Sensitive--See FAR 2.101 and 3.104
Labor Option Period 1
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Option Period 1 (12 Months) | = Cell Includes Formulas; Do Not Change |
Offeror Name: {Offeror Insert Name Here}
Offerors are to propose their own staffing solution to accomplish the effort needed for the Performance Work Statement for this acquisition.
Offerors are to identify any labor categories subject to the Service Contract Labor Standards (SCLS) by inputting an "X" in Column L.
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category ID # | Labor Category (specify whether SME, Senior, Mid-Level, or Junior-Level) | Place of Performance | Prime or Subcontractor Name | PWS Task or Subtask | Gov't or Contractor Site | SCLS Covered (input "X" if covered) | FTEs | Proposed Hours |
| ABC123 | Administrative Assistant | Fort Example | ABC Company | Government | X | 520 |
Labor Sub-Total 0.00
FOUO--Source Selection Sensitive--See FAR 2.101 and 3.104
Labor Option Period 2
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Option Period 2 (12 Months) | = Cell Includes Formulas; Do Not Change |
Offeror Name: {Offeror Insert Name Here}
Offerors are to propose their own staffing solution to accomplish the effort needed for the Performance Work Statement for this acquisition.
Offerors are to identify any labor categories subject to the Service Contract Labor Standards (SCLS) by inputting an "X" in Column L.
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category ID # | Labor Category (specify whether SME, Senior, Mid-Level, or Junior-Level) | Place of Performance | Prime or Subcontractor Name | PWS Task or Subtask | Gov't or Contractor Site | SCLS Covered (input "X" if covered) | FTEs | Proposed Hours |
| ABC123 | Administrative Assistant | Fort Example | ABC Company | Government | X | 520 |
Labor Sub-Total 0.00
FOUO--Source Selection Sensitive--See FAR 2.101 and 3.104
Labor Option Period 3
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Option Period 3 (12 Months) | = Cell Includes Formulas; Do Not Change |
Offeror Name: {Offeror Insert Name Here}
Offerors are to propose their own staffing solution to accomplish the effort needed for the Performance Work Statement for this acquisition.
Offerors are to identify any labor categories subject to the Service Contract Labor Standards (SCLS) by inputting an "X" in Column L.
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category ID # | Labor Category (specify whether SME, Senior, Mid-Level, or Junior-Level) | Place of Performance | Prime or Subcontractor Name | PWS Task or Subtask | Gov't or Contractor Site | SCLS Covered (input "X" if covered) | FTEs | Proposed Hours |
| ABC123 | Administrative Assistant | Fort Example | ABC Company | Government | X | 520 |
Labor Sub-Total 0.00
FOUO--Source Selection Sensitive--See FAR 2.101 and 3.104
Labor Option Period 4
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Option Period 4 (12 Months) | = Cell Includes Formulas; Do Not Change |
Offeror Name: {Offeror Insert Name Here}
Offerors are to propose their own staffing solution to accomplish the effort needed for the Performance Work Statement for this acquisition.
Offerors are to identify any labor categories subject to the Service Contract Labor Standards (SCLS) by inputting an "X" in Column L.
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category ID # | Labor Category (specify whether SME, Senior, Mid-Level, or Junior-Level) | Place of Performance | Prime or Subcontractor Name | PWS Task or Subtask | Gov't or Contractor Site | SCLS Covered (input "X" if covered) | FTEs | Proposed Hours |
| ABC123 | Administrative Assistant | Fort Example | ABC Company | Government | X | 520 |
Labor Sub-Total 0.00
FOUO--Source Selection Sensitive--See FAR 2.101 and 3.104
SCLS Breakout
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES |
| SCLS Break-Out |
| This worksheet shall be completed for all labor categories proposed subject to the SCLS. Information provided should be in accordance with current Wage Determinations. |
| Separate SCLS Breakout worksheets shall be provided for subcontractor(s). It is the offeror's responsibility to ensure subcontractors comply with the SCLS requirements. |
Offerors can add rows to this worksheet as needed, ensuring any formulas and totals are updated.
| Labor Category | Place of Performance | Site | Wage Determination | |
| Number | WD Revision | SCLS Occupation | ||
| Title | SCLS |
Occupation
| Code | Hours Per Period | |||||||||||
| Total | Vacation | Sick | Holiday | Productive Hours | ||||||||
| Administrative Assistant | Fort Example | Government | 2015-4211 | 27 | General Clerk III | 01113 | 2,080 | 80 | 56 | 96 | 1,848 | |
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 |
Example
Assumptions
| Attachment 0007 - Staffing Matrix, Sample Task, DEFENSE ENROLLMENT ELIGIBILITY REPORTING SYSTEM (DEERS) / REAL-TIME AUTOMATED PERSONNEL IDENTIFICATION SYSTEM (RAPIDS) MILITARY IDENTIFICATION (ID) CARD, COMMON ACCESS CARD (CAC) AND PUBLIC KEY INFRASTRUCTURE (PKI) SUPPORT SERVICES | = Offeror Fill-In Cells Required |
| Pricing Assumptions | = Cell Includes Formulas; Do Not Change |
| Offerors should provide any assumptions or explanations as neccesary IAW the instructions included in Section L in the box below as applicable |
| Offerors can add rows to this worksheet as needed. |
| No. | Explanations |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 |
File details come from the government source that posted it. Updated .