AMENDED ATTACHMENT 1-COMPENSATION PLAN (0002).xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- W81K0426RA011
- Issued by
-
Department of the Army Medical Command
About this file
This file is a compensation plan template for offerors responding to solicitation W81K0426RA011 for Psychological Health Program Support Services with the United States Army Reserve Command (USARC). The template is used to propose and evaluate labor costs across a base period and four option years, with pricing calculated through auto-populated fields based on hourly rates rather than annual figures.
Offerors must complete yellow-highlighted cells for four labor categories: Regional Director Psychological Health - Team Lead (RDPH-TL), Regional Director Psychological Health (RDPH), Nurse Case Manager (NCM), and Administrative Assistant. For each category, offerors provide Base Salary (hourly), Total Fringe Benefits, Overhead, and Profit, which automatically calculate into a Total Billable Hourly Rate. The base period includes standard hours and surge hours for each category, with surge hours billed at the standard rate. The compensation plan extends across a base period and Compensation Periods 1-4 (option years), with the template calculating total costs for each period and producing a Total Evaluated Price in an orange cell. The base period allocates 3,520 hours for RDPH-TL and Administrative Assistant, 26,400 hours for RDPH, and 14,080 hours for NCM, while option periods increase RDPH-TL and Administrative Assistant to 3,840 hours, RDPH to 28,800 hours, and NCM to 15,360 hours. The Administrative Assistant position is subject to Department of Labor Wage Determination requirements.
View the file
Other files
Show all 23
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
Offeror Instructions
1. Complete ONLY cells marked as "yellow". Ensure all tabs are complete and the total evaluated price in the total price tab is correct.
2. All rates, including benefits, must be based on hourly rates and not annual figures.
General Purpose and Instructions
1. This workbook provides a tool to propose and evaluate compensation plans and total price.
2. Most fields will auto-populate once information in the "compensation base period" tab is complete. Total prices will calculate once the yellow fields are complete.
3. Surge hours will be made at the standard rate and gray cells should not be adjusted.
4. The orange cell in the price sheet is the total evaluated price.
Compensation Base Period Offeror Name Insert Your Company Name Below
| 1. The Offeror shall fill in all yellow cells indicated on the compensation plan. |
| 2. Information provided in the yellow cells auto populate corresponding cells on the total price sheet. |
| 3. Surge pricing will auto populate to match corresponding CLIN; surge hours to be billed at standard rate. |
| 4. The bill rate for each labor category is automatically calculated from the Base Salary , Total Fringe, Overhead and Profit. |
| CLIN | LABOR CATEGORY | ||||||
| Hours | Base Salary (Hourly) | Total Fringe Benefits | Overhead | Profit | Total Billable Hourly Rate | ||
| 0001 | Regional Director Psychological Health - Team Lead RDPH-TL | 3,520 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0002 | Surge Hours: RDPH-TL | 40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0003 | Regional Director Psychological Health | 26,400 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0004 | Surge Hours: RDPH | 300 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0005 | Nurse Case Manager | 14,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0006 | Surge Hours: NCM | 160 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0007 | *Administrative Assistant | 3,520 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
*Note: Labor Category is applicable to the Department of Labor's Wage Determination
Compensation Period 1 Offeror Name Insert Your Company Name Below
| 1. The Offeror shall fill in all yellow cells indicated on the compensation plan. |
| 2. Information provided in the yellow cells auto populate corresponding cells on the total price sheet. |
| 3. Surge pricing will auto populate to match corresponding CLIN; surge hours to be billed at standard rate. |
| 4. The bill rate for each labor category is automatically calculated from the Base Salary , Total Fringe, Overhead and Profit. |
| CLIN | LABOR CATEGORY | ||||||
| Hours | Base Salary (Hourly) | Total Fringe Benefits | Overhead | Profit | Total Billable Hourly Rate | ||
| 1001 | Regional Director Psychological Health - Team Lead RDPH-TL | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1002 | Surge Hours: RDPH-TL | 40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1003 | Regional Director Psychological Health | 28,800 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1004 | Surge Hours: RDPH | 300 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1005 | Nurse Case Manager | 15,360 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1006 | Surge Hours: NCM | 160 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1007 | *Administrative Assistant | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
*Note: Labor Category is applicable to the Department of Labor's Wage Determination
Compensation Period 2 Offeror Name Insert Your Company Name Below
| 1. The Offeror shall fill in all yellow cells indicated on the compensation plan. |
| 2. Information provided in the yellow cells auto populate corresponding cells on the total price sheet. |
| 3. Surge pricing will auto populate to match corresponding CLIN; surge hours to be billed at standard rate. |
| 4. The bill rate for each labor category is automatically calculated from the Base Salary , Total Fringe, Overhead and Profit. |
| CLIN | LABOR CATEGORY | ||||||
| Hours | Base Salary (Hourly) | Total Fringe Benefits | Overhead | Profit | Total Billable Hourly Rate | ||
| 2001 | Regional Director Psychological Health - Team Lead RDPH-TL | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2002 | Surge Hours: RDPH-TL | 40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2003 | Regional Director Psychological Health | 28,800 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2004 | Surge Hours: RDPH | 300 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2005 | Nurse Case Manager | 15,360 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2006 | Surge Hours: NCM | 160 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2007 | *Administrative Assistant | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
*Note: Labor Category is applicable to the Department of Labor's Wage Determination
Compensation Period 3 Offeror Name Insert Your Company Name Below
| 1. The Offeror shall fill in all yellow cells indicated on the compensation plan. |
| 2. Information provided in the yellow cells auto populate corresponding cells on the total price sheet. |
| 3. Surge pricing will auto populate to match corresponding CLIN; surge hours to be billed at standard rate. |
| 4. The bill rate for each labor category is automatically calculated from the Base Salary , Total Fringe, Overhead and Profit. |
| CLIN | LABOR CATEGORY | ||||||
| Hours | Base Salary (Hourly) | Total Fringe Benefits | Overhead | Profit | Total Billable Hourly Rate | ||
| 3001 | Regional Director Psychological Health - Team Lead RDPH-TL | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3002 | Surge Hours: RDPH-TL | 40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3003 | Regional Director Psychological Health | 28,800 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3004 | Surge Hours: RDPH | 300 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3005 | Nurse Case Manager | 15,360 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3006 | Surge Hours: NCM | 160 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3007 | *Administrative Assistant | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
*Note: Labor Category is applicable to the Department of Labor's Wage Determination
Compensation Period 4 Offeror Name Insert Your Company Name Below
| 1. The Offeror shall fill in all yellow cells indicated on the compensation plan. |
| 2. Information provided in the yellow cells auto populate corresponding cells on the total price sheet. |
| 3. Surge pricing will auto populate to match corresponding CLIN; surge hours to be billed at standard rate. |
| 4. The bill rate for each labor category is automatically calculated from the Base Salary , Total Fringe, Overhead and Profit. |
| CLIN | LABOR CATEGORY | ||||||
| Hours | Base Salary (Hourly) | Total Fringe Benefits | Overhead | Profit | Total Billable Hourly Rate | ||
| 4001 | Regional Director Psychological Health - Team Lead RDPH-TL | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4002 | Surge Hours: RDPH-TL | 40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4003 | Regional Director Psychological Health | 28,800 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4004 | Surge Hours: RDPH | 300 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4005 | Nurse Case Manager | 15,360 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4006 | Surge Hours: NCM | 160 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4007 | *Administrative Assistant | 3,840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
*Note: Labor Category is applicable to the Department of Labor's Wage Determination
Total Price Offeror Name
| TOTAL EVALUATED PRICE | $ - 0 | |||||||||||||||||
| CLIN | Labor Category | # of Hours | ||||||||||||||||
| (Base Period) | Total Billable Hourly Rate (Base Period) | Total Cost (Base Period) | # of Hours, (Option Year 1) | Total Billable Hourly Rate (Option Period 1) | Total Cost (Option Year 1) | # of Hours, (Option Year 2) | Total Billable Hourly Rate (Option Year 2) | Total Cost (Option Year 2) | # of Hours, (Option Year 3) | Total Billable Hourly Rate (Option Year 3) | Total Cost (Option Year 3) | # of Hours, (Option Year 4) | Total Billable Hourly Rate (Option Year 4) | Total Cost (Option Year 4) | ||||
| 1 | Regional Director Psychological Health - Team Lead RDPH-TL | 3,520 | $ - 0 | $ - 0 | 3,840 | $0.00 | $ - 0 | 3,840 | $ - 0 | $ - 0 | 3,840 | $ - 0 | $ - 0 | 3,840 | $ - 0 | $ - 0 | ||
| 2 | Surge Hours: RDPH-TL | 40 | $ - 0 | $ - 0 | 40 | $0.00 | $ - 0 | 40 | $ - 0 | $ - 0 | 40 | $ - 0 | $ - 0 | 40 | $ - 0 | $ - 0 | ||
| 3 | Regional Director Psychological Health | 26,400 | $ - 0 | $ - 0 | 28,800 | $0.00 | $ - 0 | 28,800 | $ - 0 | $ - 0 | 28,800 | $ - 0 | $ - 0 | 28,800 | $ - 0 | $ - 0 | ||
| 4 | Surge Hours: RDPH | 300 | $ - 0 | $ - 0 | 300 | $0.00 | $ - 0 | 300 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | ||
| 5 | Nurse Case Manager | 14,080 | $ - 0 | $ - 0 | 15,360 | $0.00 | $ - 0 | 15,360 | $ - 0 | $ - 0 | 15,360 | $ - 0 | $ - 0 | 15,360 | $ - 0 | $ - 0 | ||
| 6 | Surge Hours: NCM | 160 | $ - 0 | $ - 0 | 160 | $0.00 | $ - 0 | 160 | $ - 0 | $ - 0 | 160 | $ - 0 | $ - 0 | 160 | $ - 0 | $ - 0 | ||
| 7 | *Administrative Assistant | 3,520 | $ - 0 | $ - 0 | 3,840 | $0.00 | $ - 0 | 3,840 | $ - 0 | $ - 0 | 3,840 | $ - 0 | $ - 0 | 3,840 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE | |||||||||||||
| $ - 0 |
File details come from the government source that posted it. Updated .