Attachment 7 - Pricing Worksheet - Fully Burden Rates_Professional Employees Compensation Plan.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- OpenStack Engineer and Architect Support
- Solicitation number
- W91249-20-R-0017
About this file
This document contains a pricing worksheet and compensation plan for providing OpenStack engineer and architect support services. The contractor shall provide all necessary management, supervision, equipment and personnel to perform non-personal services including an OpenStack program manager, engineers, and engineers with a TS/SCI clearance. The base period of performance is one year with four optional one-year periods that may be exercised at the discretion of the Army Material Command Mission and Installation Contracting Command located at Fort Eustis. Pricing is established for the base and option periods with a not-to-exceed limit of $1,500 per period for travel and $500 per period for other direct costs. The compensation plan includes fully burdened hourly rates for employees incorporating base wage, fringe benefits, overhead, G&A, and profit factors.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| W9124920R001700002 Amendment.pdf | ||
| W9124920R0017-0001 AMENDMENT 01.pdf | ||
| W9124920R0017 Solicitation Openstack.pdf | ||
| Attachment 4 - Sample Questionnaire Cover Letter and Past Performance Questionnaire.docx | DOCX document | |
| Attachment 2_CDRLs.docx | DOCX document | |
| Copy of Attachment 7 - Pricing Worksheet - Fully Burden Rates_.xlsx | XLSX spreadsheet | |
| Attachment 5 - Specific Relevant Contracts Sheet.docx | DOCX document | |
| Attachment 3 - DD254.pdf | ||
| Attachment 6 - Sample Subcontractor Teaming Partner Consent Letter.docx | DOCX document |
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
| BASE PERIOD | TOTAL COST | OPTION PERIOD 1 | TOTAL COST | OPTION PERIOD 2 | TOTAL COST | OPTION PERIOD 3 | TOTAL COST | OPTION PERIOD 4 | TOTAL COST |
| CLIN 0001 (Labor) | $ - 0 | CLIN 1001 (Labor) | $ - 0 | CLIN 2001 (Labor) | $ - 0 | CLIN 3001 (Labor) | $ - 0 | CLIN 4001 (Labor) | $ - 0 |
| *CLIN 0002 (Travel NTE) | $ 1,000.00 | *CLIN 1002 (Travel NTE) | $ 1,000.00 | *CLIN 2002 (Travel NTE) | $ 1,000.00 | *CLIN 3002 (Travel NTE) | $ 1,000.00 | *CLIN 4002 (Travel NTE) | $ 1,000.00 |
| *CLIN 0003 (Other Direct Costs NTE) | $ 500.00 | *CLIN 1003 (Other Direct Costs NTE) | $ 500.00 | *CLIN 2003 (Other Direct Costs NTE) | $ 500.00 | *CLIN 3003 (Other Direct Costs NTE) | $ 500.00 | *CLIN 4003 (Other Direct Costs NTE) | $ 500.00 |
| CLIN 0004 (CMR) | $ - 0 | CLIN 1004 (CMR) | $ - 0 | CLIN 2004 (CMR) | $ - 0 | CLIN 3004 (CMR) | $ - 0 | CLIN 4004 (CMR) | $ - 0 |
Base Period Total $1,500.00 Option Period 1 Total $1,500.00 Option Period 2 Total $1,500.00 Option Period 3 Total $1,500.00 Option Period 4 Total $1,500.00
GRAND TOTAL $7,500.00
| Note: Cells with Red Astericks * represent the NTE amounts provided by the Government in section B, and do not require an entry by the offeror. |
| Please show $0 for CMR CLINS when it will not be separately priced |
Pricing - Fully Burden Base Period
| 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 1920 hours | |
| 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 | ||||||
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Openstack Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Openstack Engineer (TS/SCI) | $ - 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 | |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Openstack Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Openstack Engineer (TS/SCI) | $ - 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 | |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Openstack Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Openstack Engineer (TS/SCI) | $ - 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 | |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Openstack Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Openstack Engineer (TS/SCI) | $ - 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 4
| 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 | |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Openstack Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Openstack Engineer (TS/SCI) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| *****************************************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. |
Compensation Plan NOTE: The items listed as fringe benefits above should not be considered as either mandatory or all inclusive. They are only examples of fringe benefits that might be included in your compensation package paid directly to the employees.
Base Period
| Base Wage Rate | FICA | FUTA | SUTA | Worker's Compensation | Health/Life Insurance | Retirement Plan | Other (Specify) | Total Employee Fringe Benefits (hourly) | Total Employee Hourly Compensation (Base + Fringe) | Overhead | G&A | Profit | Total Billable Rate (Hourly) | |
| Labor Category / Classification | Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Rate | |
| Program Manager | ||||||||||||||
| Openstack Engineer | ||||||||||||||
| Openstack Engineer (TS/SCI) | ||||||||||||||
| Option 1 |
| Base Wage Rate | FICA | FUTA | SUTA | Worker's Compensation | Health/Life Insurance | Retirement Plan | Other (Specify | Total Employee Fringe Benefits (hourly) | Total Employee Hourly Compensation (Base + Fringe) | Overhead | G&A | Profit | Total Billable Rate (Hourly) | |
| Labor Category / Classification | Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Rate | |
| Program Manager | ||||||||||||||
| Openstack Engineer | ||||||||||||||
| Openstack Engineer (TS/SCI) | ||||||||||||||
| Option 2 |
| Base Wage Rate | FICA | FUTA | SUTA | Worker's Compensation | Health/Life Insurance | Retirement Plan | Other (Specify | Total Employee Fringe Benefits (hourly) | Total Employee Hourly Compensation (Base + Fringe) | Overhead | G&A | Profit | Total Billable Rate (Hourly) | |
| Labor Category / Classification | Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Rate | |
| Program Manager | ||||||||||||||
| Openstack Engineer | ||||||||||||||
| Openstack Engineer (TS/SCI) | ||||||||||||||
| Option 3 |
| Base Wage Rate | FICA | FUTA | SUTA | Worker's Compensation | Health/Life Insurance | Retirement Plan | Other (Specify | Total Employee Fringe Benefits (hourly) | Total Employee Hourly Compensation (Base + Fringe) | Overhead | G&A | Profit | Total Billable Rate (Hourly) | |
| Labor Category / Classification | Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Rate | |
| Program Manager | ||||||||||||||
| Openstack Engineer | ||||||||||||||
| Openstack Engineer (TS/SCI) | ||||||||||||||
| Option 4 |
| Base Wage Rate | FICA | FUTA | SUTA | Worker's Compensation | Health/Life Insurance | Retirement Plan | Other (Specify | Total Employee Fringe Benefits (hourly) | Total Employee Hourly Compensation (Base + Fringe) | Overhead | G&A | Profit | Total Billable Rate (Hourly) | |
| Labor Category / Classification | Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Rate | |
| Program Manager | ||||||||||||||
| Openstack Engineer | ||||||||||||||
| Openstack Engineer (TS/SCI) |
File details come from the government source that posted it. Updated .