AMENDED ATTACHMENT 1-COMPENSATION PLAN (0003).xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- W81K0426RA011
- Issued by
-
Department of the Army Medical Command
About this file
This is a compensation plan template and pricing tool for submitting proposals in response to solicitation W81K0426RA011 for Psychological Health Program Support Services with the United States Army Reserve Command (USARC). The template is designed to calculate total evaluated pricing based on labor category rates across a base period and four option years, with all pricing derived from hourly rates rather than annual figures.
The compensation plan requires offerors to 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 (subject to Department of Labor Wage Determination requirements). For each labor category, offerors must input base salary hourly rates, total fringe benefits, overhead, and profit percentages. The template includes designated hours for standard work and surge hours across a base period and four one-year compensation periods (Years 1-4), with surge hours automatically billed at the standard rate. All other fields auto-populate based on the yellow cell entries to calculate total billable hourly rates and period costs. The total evaluated price displays in an orange cell and represents the sum of all labor category costs across all periods. This amended version (0003) replaces the previous compensation plan and is associated with a small business set-aside solicitation with an extended due date of 23 June 2026.
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 and Total Fringe, Overhead. |
| 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 .