AMENDED ATTACHMENT 1-COMPENSATION PLAN.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 for the Psychological Health Program (PHP) FY26 solicitation issued by the Department of the Army Medical Command (MEDCOM) for the United States Army Reserve Command (USARC). The document is an Excel-based compensation structure designed to outline pricing and staffing requirements for contractor proposals responding to solicitation W81K0426RA011.
The compensation plan serves as a pricing template that contractors must complete to detail labor costs, staffing levels, and associated expenses for delivering psychological health support services. As an amended attachment, this document establishes the framework for evaluating contractor pricing proposals and ensuring consistent cost comparison across all submissions. The solicitation is a 100% small business set-aside, and contractors are required to use this template when submitting their pricing proposals to ensure alignment with government evaluation criteria and budget requirements for the psychological health program support services.
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 .