Attachment 2 - UNITE BPA Price Quote.xlsx
XLSX spreadsheet 82 KB Posted
- Solicitation number
- 49100425Q0005
- Issued by
-
National Science Foundation
About this file
This is a price quote template spreadsheet for the National Science Foundation's UNITE BPA solicitation #49100425Q0005, designed to capture labor category pricing across five years plus an option to extend services period (1/1/2025 - 12/31/2029). The template includes detailed pricing worksheets for 29 labor categories across five NAICS codes: 541611 (Administrative Management), 541330 (Engineering Services), 541990 (Professional/Scientific Services), 611430 (Professional Training), and 561920 (Convention/Trade Show Organizers).
The template requires vendors to map their GSA Schedule labor categories to the government's specified categories, apply a minimum 5% BPA discount, and provide pricing based on government-site rates. It includes estimated baseline FTEs totaling 29 per year (54,520 annual hours) distributed across various roles including program managers, engineers, analysts, trainers, and event planners. The spreadsheet contains detailed labor category descriptions specifying required experience and education levels for each position. Vendors must maintain all formulas and links while completing the pricing template, which will be used to evaluate total price across the full period of performance.
View the file
Other files
Show all 20
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
Summary Price
| SUMMARY PRICE QUOTE | |
| CONTRACTOR NAME: | |
| CONTRACT/TASK ORDER NUMBER: 49100425Q0005 | |
| PERIOD OF PERFORMANCE: 01/1/2025 - 12/31/2029 | |
| Task Order Period | Totals |
| Year 1 | $ - |
| Year 2 | $ - |
| Year 3 | $ - |
| Year 4 | $ - |
| Year 5 | $ - |
| Option to Extend Services | $ - |
| Total Evaluated Price | $ - |
| Complete the attached price quote worksheets as instructed. Individual worksheet prices should be linked to this Summary Price Quote. |
| Quoters are solely responsible for verifying the accuracy of the formulas, links and amounts contained in this worksheet. |
Page &P
Sample Price Quote
| PRICE QUOTE INSTRUCTIONS |
| Enter all information as required in the green highlighted cells for each task order period. |
| Keep formulas and links intact and DO NOT protect cells. You may add supporting information or insert rows or columns if required. |
| Column (1): This column identifies the task areas as set forth in the SOW |
| Column (2): This column identifies the Estimated Government Labor Categories. |
| Column (3): Identify your proposed GSA labor categories exactly as shown in your current GSA Federal Supply Schedule. Do not combine different GSA labor categories. |
| If proposing two labor categories under one Government estimated labor category, add a row to the spreadsheet to show both GSA FSS labor categories. |
| Column (4): Identify Vendor/Team Member name |
| Column (5): Identify the applicable GSA contract number(s) for which the quoted labor rates are based. |
| Column (6): Specify the quoted rate as either Government (G) Site or Contractor (C) Site. For purposes of this RFQ, vendors should assume performance at Government Site. |
| Column (7): Enter the applicable labor rate from your GSA FSS Schedule. If the Quoter’s schedule expires prior to the end of the period of performance (but includes unexercised options), |
| annotate the rate and separately describe the assumptions supporting all quoted rates that fall into this situation. Do not use composite or averaged rates. |
| Column (8): Enter your quoted BPA discount rate in Cell B24 which will be applied to each labor category. The quoted discount rate shall be equivalent to the BPA holder's minimum discount for work performed under this sample task. |
| Discounts above the minimum proposed BPA discount will not be evaluated as part of this sample task. |
| Column (9): This is your quoted discounted labor rate. The quoted rates shall include all applicable indirects, fees, and taxes. |
| Column (10): For each proposed labor category, enter the total labor hours estimated for this performance period. If applicable, explain your basis for full-time equivalent (FTE) hours and show how you developed your Direct Production Labor Hours (DPLH) estimate. |
| DPLH are defined as an employee's annual direct labor hours exclusive of vacation, holiday, sick leave and other absences. |
| Column (11): This column shows the extended price quoted for each labor category (discounted labor rate x hours). |
| Continued Columns - These columns repeat columns 7 through 9 for performance Years 2 through 5 and the Option to Extend Services |
| Proposed Discount | |
| Overall Rate | |
| 5.00% |
| SAMPLE PRICE QUOTE - FIRM-FIXED-PRICE LABOR | |||||||||||||||||||||||||||||||
| PERIOD OF PERFORMANCE: 01/1/20xx - 01/01/20xx | |||||||||||||||||||||||||||||||
| (1) Task Areas | (2) Government Labor Category | (3) GSA Labor Category | (4) Contractor/ | ||||||||||||||||||||||||||||
| Team Member Name | (5) GSA Contract No. | (6) Site | (7) GSA Schedule Labor Rate Year 1 | (8) Discount % Year 1 | (9) Discounted Labor Rate Year 1 | (10) Estimated Hours | (11) Price Year 1 | GSA Schedule Labor Rate Year 2 | Discount % Year 2 | Discounted Labor Rate Year 2 | Price Year 2 | GSA Schedule Labor Rate Year 3 | Discount % Year 3 | Discounted Labor Rate Year 3 | Price Year 3 | GSA Schedule Labor Rate Year 4 | Discount % Year 4 | Discounted Labor Rate Year 4 | Price Year 4 | GSA Schedule Labor Rate Year 5 | Discount % Year 5 | Discounted Labor Rate Year 5 | Price Year 5 | GSA Schedule Labor Rate Opt to Extend Services | Discount % Option to Extend | Discounted Labor Rate Option to Extend | Price Option to Extend | ||||
| NAICS 541611 - Administrative Management and General Management Consulting Services | Program Manager | 5.0% | $ - 0 | 55.00 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||
| Management Consultant | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Financial Analyst | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Business Process Analyst | |||||||||||||||||||||||||||||||
| Technical Writer | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||||
| NAICS 541330 - Engineering Services | Program Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||
| Project Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Quality Assurance Specialist | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Technical Analyst & Consultant: | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Senior Engineer | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Project Coordinator | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Research Scientist | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||||
| NAICS 541990 - All Other Professional, Scientific, and Technical Services | Program Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||
| Technical Consultant: | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Administrative Support: | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| subject matter expert | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Data Analyst: | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||||
| NAICS 611430 - Professional and Management Development Training | Program Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||
| Subject Matter Expert (SME) | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Instructional Designer | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| E-Learning Specialist | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Training Coordinator | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Evaluation Specialist | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Training Facilitator/Instructor | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||||
| NAICS 561920 - Convention and Trade Show Organizers | Program Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | ||||||
| Event Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Logistics Coordinator | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Marketing Specialist | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Registration Manager | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| Lead Event Planner | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | $ - 0 | 5.0% | $ - 0 | $ - | |||||||
| TOTAL PRICE- Labor CLIN | 55.0 | $ - | $ - | $ - | $ - | $ - | $ - |
| Grand Total | $0.00 |
| Price |
| NOTES: |
| 1. SOW = Statement of Work |
| 2. DPLH = Direct Productive Labor Hours. Direct Productive Labor Hours are defined as actual direct labor hours exclusive of vacation, holiday, sick leave and other absences. |
| A DPLH Calculator is included if needed to determine hours per FTE |
| 3. FTE = Full-Time Equivalent. The Government estimates 1 FTE = 1880 per year under this quotation as it relates to PWS Labor |
| The Government will not dictate requirements in hours under Labor, and BPA Holders should propose labor consistent with their standard business and estimating practices as it relates to DPLH. |
| 4. Schedule Labor Rate = Federal Supply Schedule Rate |
| 5. Discount % = Quoted discount %. The quoted discount % must be discounted by the BPA Holder's minimum discount % for every quoted labor category. |
| Additional discounts above the minimum will not be evaluated under this sample task. Additional discounts above the BPA minimum shall be encouraged on all future actual task orders under this BPA. |
| 6. Keep all of your Formulas and Links Intact and DO NOT Protect Cells |
| 7. Offerors are solely responsible for verifying the accuracy of the formulas and amounts contained in this spreadsheet |
Page &P
Labor Crosswalk
| INSTRUCTIONS: Enter equivalent GSA FSS Labor Category Titles in the green highlighted cells for each of the listed Government Labor Categories. | |
| List additional (non cross-walked) FSS Labor Categories (if applicable). | |
| If more than one FSS labor category maps to the Govt. Labor Category, disclose each category weight as a percentage.* Do not combine FSS labor categories or use averaged rates! | |
| GOVERNMENT LABOR CATEGORIES | FSS LABOR CATEGORIES |
| NAICS 541611 - Administrative Management and General Management Consulting Services | |
| Program Manager | FSS Labor Category #1 |
| Management Consultant | FSS Labor Category #2 |
| Financial Analyst | FSS Labor Category #3 |
| Business Process Analyst | FSS Labor Category #4 |
| Technical Writer | FSS Labor Category #5 |
| NAICS 541330 - Engineering Services | |
| Program Manager | FSS Labor Category #6 |
| Project Manager | FSS Labor Category #7 |
| Quality Assurance Specialist | FSS Labor Category #8 |
| Technical Analyst & Consultant: | FSS Labor Category #9 |
| Senior Engineer | FSS Labor Category #10 |
| Project Coordinator | FSS Labor Category #11 |
| Research Scientist | FSS Labor Category #12 |
| NAICS 541990 - All Other Professional, Scientific, and Technical Services | |
| Program Manager | FSS Labor Category #13 |
| Technical Consultant | FSS Labor Category #14 |
| Administrative Support | FSS Labor Category #15 |
| Subject Matter Expert (SME) | FSS Labor Category #16 |
| Data Analyst | FSS Labor Category #17 |
| NAICS 611430 - Professional and Management Development Training | |
| Program Manager | FSS Labor Category #22 |
| Subject Matter Expert (SME) | FSS Labor Category #23 |
| Instructional Designer | FSS Labor Category #24 |
| E-Learning Specialist | FSS Labor Category #25 |
| Training Coordinator | FSS Labor Category #26 |
| Evaluation Specialist | FSS Labor Category #27 |
| Training Facilitator/Instructor | FSS Labor Category #28 |
| NAICS 561920 - Convention and Trade Show Organizers | |
| Program Manager | FSS Labor Category #29 |
| Event Manager | FSS Labor Category #30 |
| Logistics Coordinator | FSS Labor Category #31 |
| Marketing Specialist | FSS Labor Category #32 |
| Registration Manager | FSS Labor Category #33 |
| Lead Event Planner | FSS Labor Category #34 |
| EXAMPLE: SENIOR ENGINEER = 50% FSS CATEGORY EXPERIENCED ENGINEER III AND 50% SENIOR ANALYST | |
| *KEY PERSONNEL - CAN ONLY BE FILLED BY ONE INDIVIDUAL. |
| The Government estimates the following baseline full-time equivalents for UNITE BPA Labor for each year of the period of performance, distributed among PWS tasks as follows: | ||
| PWS Labor Categories | GOVT. ESTIMATED FTEs Per Year | GOVT. ESTIMATED ANNUAL EQUIVALENT HOURS |
| NAICS 541611 - Administrative Management and General Management Consulting Services | ||
| Program Manager | 0.25 | 470 |
| Management Consultant | 1.00 | 1,880 |
| Financial Analyst | 1.00 | 1,880 |
| Business Process Analyst | 1.00 | 1,880 |
| Technical Writer | 1.00 | 1,880 |
| NAICS 541330 - Engineering Services | ||
| Program Manager | 1.00 | 1,880 |
| Project Manager | 1.00 | 1,880 |
| Quality Assurance Specialist | 1.00 | 1,880 |
| Technical Analyst & Consultant: | 1.00 | 1,880 |
| Senior Engineer | 1.00 | 1,880 |
| Project Coordinator | 1.00 | 1,880 |
| Research Scientist | 1.00 | 1,880 |
| NAICS 541990 - All Other Professional, Scientific, and Technical Services | ||
| Program Manager | 0.75 | 1,410 |
| Technical Consultant | 1.00 | 1,880 |
| Administrative Support | 1.00 | 1,880 |
| Subject Matter Expert (SME) | 1.00 | 1,880 |
| Data Analyst | 1.00 | 1,880 |
| NAICS 611430 - Professional and Management Development Training | ||
| Program Manager | 1.00 | 1,880 |
| Subject Matter Expert (SME) | 1.00 | 1,880 |
| Instructional Designer | 1.00 | 1,880 |
| E-Learning Specialist | 1.00 | 1,880 |
| Training Coordinator | 1.00 | 1,880 |
| Evaluation Specialist | 1.00 | 1,880 |
| Training Facilitator/Instructor | 1.00 | 1,880 |
| NAICS 561920 - Convention and Trade Show Organizers | ||
| Program Manager | 1.00 | 1,880 |
| Event Manager | 1.00 | 1,880 |
| Logistics Coordinator | 1.00 | 1,880 |
| Marketing Specialist | 1.00 | 1,880 |
| Registration Manager | 1.00 | 1,880 |
| Lead Event Planner | 1.00 | 1,880 |
| Totals Per Year | 29.00 | 54,520 |
| NOTES: |
| 1. Vendors may propose any labor mix and hours they determine necessary to complete the work in accordance with their technical approach. |
| 2. Descriptions and Qualifications of Government Labor Categories can be found in the sheet titled "Government Labor Descriptions" |
| 3. FTE = Full-Time Equivalent. The Government estimates 1 FTE = 1880 per year under this quotation as it relates to PWS Labor |
| The Government will not dictate requirements in hours under SOW Labor, and BPA Holders should propose labor consistent with their standard business and estimating practices as it relates to DPLH. |
| Please refer to the DPLH tab to calculate your company's DPLH if necessary |
| 4. The Government baseline estimate is for evaluation purposes only and may not be representative of the actual level of effort required under resultant task orders. |
Government Labor Descriptions
| The Government specified labor categories relating to the FFP CLINs are described below: | ||||
| Labor Category | Labor Category Description | Experience | Education | |
| Administrative Support: | Administrative Support professionals handle essential tasks, such as maintaining documentation, scheduling, supporting communications, managing data entry, and assisting with reporting. They play a pivotal role in organizing resources, tracking deliverables, and ensuring compliance with procedural requirements. These professionals may also support project teams by coordinating logistics, preparing reports, and managing internal communication channels. | Over 3-5 years in the relevant field. | Associates Degree | |
| Business Process Analyst | Business Process Analysts are responsible for evaluating and analyzing existing business processes, identifying inefficiencies, and recommending improvements. They facilitate process mapping, data collection, and statistical analysis to assess performance. Additionally, they may support project teams by developing streamlined workflows, implementing new business strategies, and conducting cost-benefit analyses. Their role often includes creating documentation, developing training materials, and coordinating with stakeholders to ensure a seamless integration of process changes. | Generally 5-7 years in business analysis, process improvement, or related fields. | Bachelor’s degree in Business Administration, Management, or a related field, with advanced certifications in process improvement methodologies (e.g., Lean, Six Sigma) often preferred. | |
| Data Analyst: | Data Analysts are responsible for gathering and interpreting complex data to provide actionable insights. They utilize tools for data collection, cleansing, and visualization, performing trend analysis, forecasting, and statistical evaluations. Additionally, Data Analysts develop reports, dashboards, and visualizations to convey findings to stakeholders. They may work with cross-functional teams to define metrics, monitor performance indicators, and recommend data-driven strategies for improvement. DA focuses on analyzing data to provide actionable insights. | Typically requires 3-5 years of experience in data analysis, data management, and reporting, with proficiency in analytical tools and statistical methods. | A Bachelor’s degree in Data Science, Statistics, Computer Science, or a related field is generally required, with advanced certifications in data analysis or analytics software considered beneficial. | |
| E-Learning Specialist | E-Learning Specialists create and manage online training programs, design engaging digital course content, and develop e-learning modules that align with organizational goals. Their role includes assessing training needs, implementing interactive and multimedia content, and evaluating program effectiveness to enhance learning outcomes. | 5-7 years in instructional design or e-learning development, with expertise in educational technology platforms and methodologies. | Bachelor’s degree in Education, Instructional Design, or a related field is generally required, with advanced certifications in e-learning or instructional technology seen as beneficial. | |
| Evaluation Specialist | Serve as analysts and advisors on the evaluation of the effectiveness of government programs and operations or the productivity and efficiency of government programs. | 5-8 years in program evaluation, research, or data analysis, with a strong background in quantitative and qualitative evaluation methods. | A Master’s degree in Evaluation, Social Sciences, Public Policy, or a related field is generally preferred. | |
| Event Manager | Provides strategic, objective advisory services related to strategic planning, budget analysis, project performance, and program analysis. | 3-5 years in event planning and management, including experience with logistics coordination, vendor management, and budget oversight. | Bachelor’s degree in Hospitality, Communications, event management, marketing or a related field is typically required, with experience, strong organisational skills, communication skills, creativity, attention to detail, budgeting, financial management skills, and adaptability. event management certifications considered advantageous. | .. |
| Financial Analyst | Financial Analysts are responsible for preparing financial reports, analyzing budgetary trends, conducting cost-benefit analyses, and advising on financial decisions. They monitor spending, develop forecasts, and perform data-driven analysis to support strategic planning and financial optimization. | 5-7 years in financial analysis, with expertise in budgeting, forecasting, and data interpretation. | A Bachelor’s degree in Finance, Accounting, Economics, or a related field is commonly required, with certifications such as CPA or CFA seen as advantageous. | |
| Instructional Designer | Instructional Designers are responsible for developing training programs, designing course content, and implementing interactive learning tools. Their role includes conducting needs assessments, creating multimedia and interactive content, and evaluating the effectiveness of instructional materials to ensure high-quality learning experiences. | 3-5 years in instructional design, with proficiency in curriculum development and e-learning tools. | A Bachelor’s degree in Education, Instructional Design, or a related field, with advanced certifications in instructional technology or adult learning methodologies often preferred. | |
| Lead Event Planner | Lead Event Planners oversee all aspects of event planning, from concept development to execution. They coordinate logistics, manage vendor relationships, and handle budgeting to ensure successful event delivery. Additionally, they are responsible for post-event analysis to assess performance and capture feedback for future planning. | Typically requires 5-8 years in event planning, with experience coordinating large-scale events, vendor management, and budget oversight. | Bachelor’s degree in Event Management, Communications, Hospitality, or a related field is usually required, with event planning certifications considered advantageous. | |
| Logistics Coordinator | Logistics Coordinators ensure that resources are efficiently and accurately distributed, tracking inventory, coordinating with vendors, and managing transportation schedules. Their role may also include managing supply chain logistics, overseeing delivery timelines, and implementing quality control measures to optimize operational efficiency. | 3-5 years in logistics or supply chain management, with experience in inventory control, distribution planning, and logistics support. | Bachelor’s degree in Logistics, Supply Chain Management, or a related field is commonly preferred, though some roles may require only a high school diploma with relevant experience. | |
| Management Consultant | Management Consultants analyze organizational practices, identify areas for improvement, and develop strategies for enhanced performance. Their role includes conducting assessments, advising on resource allocation, implementing best practices, and supporting change management initiatives. | Bachelor’s degree in Business Administration, Management, or a related field, with advanced degrees or certifications in consulting or project management (such as PMP) considered beneficial. | 8-10 years of experience in consulting, with a focus on strategic planning, process optimization, and organizational assessments. | |
| Marketing Specialist | Marketing Specialists are responsible for designing and executing marketing campaigns, managing social media and digital content, conducting market research, and tracking campaign performance. They focus on creating targeted communications and managing public relations to support outreach and branding efforts. | 3-5 years in marketing, with expertise in digital marketing, content creation, and campaign management. | Bachelor’s degree in Marketing, Communications, Business, or a related field is commonly required, with certifications in digital marketing seen as advantageous. | |
| Program Manager | The Program Manager is responsible for managing overall program performance, ensuring that all project objectives are met. This includes planning, resource allocation, budgeting, and stakeholder communication. The Program Manager also leads cross-functional teams, oversees progress on deliverables, manages risks, and ensures that program activities are in compliance with regulatory and performance standards. | 10 years in project or program management, with a proven track record of leading multi-faceted, mission-critical programs. | Master’s degree in a relevant field, such as Business Administration, Project Management, or Engineering | |
| Project Coordinator | Project Coordinators assist with project planning, monitor task progress, organize project documentation, and coordinate meetings. They act as a liaison between team members and project managers, helping to streamline communication and maintain project schedules. | 3-5 years in project support or coordination, with experience in scheduling, resource allocation, and tracking project deliverables. | Bachelor’s degree in Business, Project Management, or a related field is generally preferred, though relevant experience may suffice. | |
| Project Manager | Project Managers lead cross-functional teams, define project goals, manage schedules and resources, and oversee risk management. They are responsible for ensuring project deliverables align with scope and quality standards, coordinating with stakeholders, and tracking project progress through regular reporting. | 5-10 years of experience in project management, with a record of successfully managing complex projects from inception to completion. | Bachelor’s degree in Business, Engineering, or a related field, with certifications such as PMP or PRINCE2 often preferred. | |
| Quality Assurance Specialist | Research Analysts are responsible for gathering, analyzing, and interpreting data to support policy, strategic planning, or operational decisions. Their role includes conducting literature reviews, performing statistical analysis, compiling reports, and presenting findings to stakeholders. QAS focueses on ensuring quality through process monitoring and compliance. | 3-5 years of experience in research, data analysis, or a similar analytical field. | Bachelor’s degree in Social Sciences, Statistics, Economics, or a related field, with advanced training in statistical analysis and data management tools often beneficial. | |
| Registration Manager | Registration Managers are responsible for managing event registration systems, handling attendee inquiries, tracking participation data, and coordinating with event planners. They ensure the registration process runs smoothly, maintain accurate records, and provide reports on attendance metrics. | 3-5 years in event registration or administrative roles, with expertise in registration systems, data management, and customer service. | Bachelor’s degree in Event Management, Business, or a related field is often required, though some roles may only require a high school diploma with relevant experience. | |
| Research Scientist | Research Scientists conduct experiments, analyze results, and develop new theories or applications based on findings. They may publish research, present findings to stakeholders, and work within teams to solve complex scientific problems. | Master’s degree or Ph.D. in a relevant scientific field, such as Biology, Chemistry, or Engineering, is generally required. | 5-10 years in research, with demonstrated expertise in data collection, analysis, and scientific methodologies. | |
| Senior Engineer | Senior Engineers independently perform functional duties, oversee mission-critical engineering tasks, provide technical recommendations, and may supervise junior staff. They ensure technical accuracy, compliance with regulations, and manage project risk for engineering projects. | 10 years in the relevant engineering field, with expertise in design, analysis, and project management. | Master’s degree in Engineering or a related field is commonly required. | |
| Subject Matter Expert (SME) | SMEs offer in-depth knowledge and recommendations, supporting strategic decisions, developing specialized solutions, and advising on best practices. They may conduct evaluations, provide expert testimony, and work closely with cross-functional teams to address complex challenges. | 10 years in the relevant field, demonstrating expert-level knowledge and industry-specific expertise. | Master’s degree or higher in a specialized field, though substantial experience may supplement formal education requirements. | |
| Technical Analyst & Consultant: | Technical Analysts & Consultants are responsible for assessing technical needs, analyzing data, recommending solutions, and supporting the implementation of technical strategies. They may conduct feasibility studies, risk assessments, and provide recommendations to optimize project performance. | 5-7 years in technical analysis and consulting, with skills in data analysis, problem-solving, and strategic consulting. | Bachelor’s degree in a technical field, such as Engineering, Computer Science, or Information Technology, with certifications in relevant technical areas considered advantageous. | |
| Technical Consultant: | Technical Consultants work closely with clients to identify technical requirements, develop solutions, and advise on best practices. They support implementation efforts, offer troubleshooting expertise, and help optimize technical operations to achieve project objectives. | 5-8 years in a technical consulting role, with experience providing expert guidance and solution development. | Bachelor’s degree in a technical or related field, with certifications or advanced training in specialized technologies considered beneficial. | |
| Technical Writer | Technical Writers are responsible for drafting, editing, and maintaining technical manuals, reports, proposals, and user guides. They ensure documents meet organizational standards and are tailored for the intended audience, often collaborating with engineers, developers, and subject matter experts. | 3-5 years in technical writing, with experience producing clear, concise, and accurate documentation for technical audiences. | Bachelor’s degree in English, Communications, or a technical field, with advanced training or certification in technical writing often preferred. | |
| Training Coordinator | Training Coordinators manage the scheduling, logistics, and administrative support for training programs. They coordinate with instructors, arrange facilities, monitor enrollment, and ensure that training materials are prepared. They may also assist with evaluating program effectiveness. | 3-5 years in training coordination or a related field, with skills in program management and logistics. | Bachelor’s degree in Human Resources, Education, or a related field is commonly preferred. | |
| Training Facilitator/Instructor | Training Facilitators/Instructors conduct training sessions, deliver curriculum-based content, and engage participants through interactive learning techniques. They assess participants’ understanding, provide feedback, and adjust instruction as needed to enhance learning outcomes. | 5 years of experience in training delivery or instruction, with expertise in curriculum delivery and audience engagement. | Bachelor’s degree in Education, Training, or a related field, with certifications in instructional design or adult learning often beneficial. |
| Note: |
| Additional descriptions may be provided in Task Order solicitations |
Page &P
DPLH Calculator
| INSTRUCTIONS: | |
| 1. Fill out in accordance with your company's practice to determine DPLH | |
| 2. The leave types listed above outline typical leave provided by companies, but is not all inclusive. Change as needed to reflect your company's practices. | |
| 3. Additional tables may be added. If multiple DPLHs are used specify which team member or labor category the DPLH applies to. | |
| Team Member 1: | |
| DPLH CALCULATION for ONE FTE | |
| Available Hours (52 wks x 40 hrs/wk) | 2,080 |
| Less Vacation Leave | |
| Less Sick Leave | |
| Less Admin/Holiday/All Other Leave | |
| Team Member DPLH | 2,080 |
| Team Member 2: | |
| DPLH CALCULATION for ONE FTE | |
| Available Hours (52 wks x 40 hrs/wk) | 2,080 |
| Less Vacation Leave | |
| Less Sick Leave | |
| Less Admin/Holiday/All Other Leave | |
| Team Member DPLH | 2,080 |
| Team Member etc.: | |
| DPLH CALCULATION for ONE FTE | |
| Available Hours (52 wks x 40 hrs/wk) | 2,080 |
| Less Vacation Leave | |
| Less Sick Leave | |
| Less Admin/Holiday/All Other Leave | |
| Team Member DPLH | 2,080 |
image5.png image6.png image7.png image8.png image9.png image1.png image10.png image11.png image12.png image13.png image14.png image15.png image16.png image17.png image18.png image19.png image2.png image20.png image21.png image22.png image23.png image24.png image25.png image26.png image27.png image28.png image29.png image3.png image30.png image31.png image4.png image32.png image33.png image34.png image35.png
File details come from the government source that posted it. Updated .