Attachment 6 - Pricing Worksheet_v2_26Oct2020.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Human Factors Support Federal contract opportunity
- Solicitation number
- W9124921R0025
About this file
This document contains a pricing worksheet template and details for a federal contract solicitation. The pricing worksheet template includes columns for labor rates, fringe benefits, overhead costs, general and administrative expenses, and profit margins for prime contractors to apply across base and option periods. It also notes the requirement to use consistent net productive hours across all proposals for evaluation.
The related federal contract solicitation is to provide Human Factors Specialists to the U.S. Army Cyber School. The specialists will assist with recruitment and commissioning efforts for Cyber officers and enlisted personnel across various cohorts at Fort Gordon. Contractors must develop and implement a comprehensive recruiting plan to generate monthly leads and perform duties according to the Performance Work Statement and terms of the solicitation. The solicitation was issued by the Department of the Army Materiel Command Mission and Installation Contracting Command at Fort Eustis.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| W9124921R0025P0005.pdf | ||
| Attachment 2 - Past Performance Cover Letter and Assessment Questionnaire (Update)....docx | DOCX document | |
| W9124921R0025P0004.pdf | ||
| Attachment 7 - Questions and Answers.pdf | ||
| W9124921R0025P0003.pdf | ||
| W9124921R0025P0002.pdf | ||
| W9124921R0025P00001.pdf | ||
| Attachment 1 - Contract Data Requirement List .docx | DOCX document | |
| Attachment 5 - Sample Client Authorization Letter.docx | DOCX document | |
| W91249-21-R-0025.pdf | ||
| Attachment 2 - Past Performance Cover Letter and Assessment Ques....docx | DOCX document | |
| Attachment 3 - Specific Relevant Contracts Sheet.docx | DOCX document | |
| Attachment 4 - Consent Form for the Release of Past Performance.docx | DOCX document |
Show all 13
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Summary
| BASE PERIOD | TOTAL COST | OPTION PERIOD 1 | TOTAL COST | OPTION PERIOD 2 | TOTAL COST | OPTION PERIOD 3 | TOTAL COST |
| CLIN 0001 | $ - 0 | CLIN 1001 | $ - 0 | CLIN 2001 | $ - 0 | CLIN 3001 | $ - 0 |
| CLIN 0002 | $ - 0 | CLIN 1002 | $ - 0 | CLIN 2002 | $ - 0 | CLIN 3002 | $ - 0 |
Base Period Total $0.00 Option Period 1 Total $0.00 Option Period 2 Total $0.00 Option Period 3 Total $0.00
GRAND TOTAL $0.00
Note: Please show $0 for CMR CLINS when it will not be separately priced
Internal Note: Make sure you add/delete CLINS and period of performance on here as well.
Pricing - Fully Burden Base Period IMPORTANT COMMENT Symone Collins: Symone Collins:
Make sure do the following prior to using as an Attachment to the solicitation:
- Change the Period of Performance based on your requirements. This only show s a Base and three (3) one-year option periods. However, you may need to add or delete based on your requirement needs.
- Delete all comments as these are internal and not meant for vendors to see.
Exempt/ Non-Exempt Full Time Equivalent Labor Hours Base Wage Rate Fringe Overhead Subtotal G&A Subtotal Profit Total Total Paid to Vendor based on ____ hours Symone Collins: Symone Collins:
Usually, the net productive hours fall around 1871 or 1872. However, you will need to confirm with the requiring activity and make sure that number is entered here so all Offerors will propose pricing based on the same net productive hours
For Example: Cyber COE determines there net productive hours from taking 2087 (available hours) - 216 (80 - holidays, 80-Leave, 56-Sick) = 1871
Labor Category/Classification Rate Symone Collins: Symone Collins:
This is what will be paid to Employee 0.00% 0.00% Cost 0.00% Cost 0.00% Rate
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | ||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Option 1 |
| Escalation | Fringe | Overhead | Subtotal | G&A | Subtotal | Profit/Fee | Total | |
| Labor Category / Classification | 0.00% | 0.00% | 0.00% | Cost | 0.00% | Cost | 0.00% | Rate |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Option 2
| Escalation | Fringe | Overhead | Subtotal | G&A | Subtotal | Profit/Fee | Total | |
| Labor Category / Classification | 0.00% | 0.00% | 0.00% | Cost | 0.00% | Cost | 0.00% | Rate |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Option 3
| Escalation | Fringe | Overhead | Subtotal | G&A | Subtotal | Profit/Fee | Total | |
| Labor Category / Classification | 0.00% | 0.00% | 0.00% | Cost | 0.00% | Cost | 0.00% | Rate |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
The net productive hours are based on an estimated overall average. The available hours of ______ were reduced by an estimated ____ indirect hours. The ____ indirect hours are holiday, vacation, sick, training, etc..
Symone Collins: Symone Collins:
Update
Symone Collins: Symone Collins:
This is what will be paid to Employee Symone Collins: Symone Collins:
Make sure do the following prior to using as an Attachment to the solicitation:
- Change the Period of Performance based on your requirements. This only show s a Base and three (3) one-year option periods. However, you may need to add or delete based on your requirement needs.
- Delete all comments as these are internal and not meant for vendors to see.
Symone Collins: Symone Collins:
Usually, the net productive hours fall around 1871 or 1872. However, you will need to confirm with the requiring activity and make sure that number is entered here so all Offerors will propose pricing based on the same net productive hours
For Example: Cyber COE determines there net productive hours from taking 2087 (available hours) - 216 (80 - holidays, 80-Leave, 56-Sick) = 1871
| *****************************************Fringe , Overhead, G&A, Profit varies depending on the company.********************************************************* |
| **************************************** Government allows for no more than a 3% escalation between option years.************************************************* |
| The Base rate is what the employee will receive. |
| Fringe is the employee package like insurance, tsp etc. |
| Overhead is the cost of operating a business ie rent, utilities etc. |
| G&A General and Administrative Expense is for any management, finanacil and other epense which is incurred by or allocted to a business unit and which is for management and administration of the business unit as a whole. |
| Profit/Fee is the amout after the costs of doing business. |
File details come from the government source that posted it. Updated .