DLI_Atch 2 Pricing Matrix 3.25.26.xlsx
XLSX spreadsheet 117 KB Posted
- Attached to
- Defense Language Institute Foreign Language Center (DLIFLC) Oral Proficiency Testing and Reporting Services
- Solicitation number
- W911S026RA004
About this file
This is a pricing matrix template for the Defense Language Institute Foreign Language Center (DLIFLC) Oral Proficiency Testing and Reporting Services contract (W911S026RA004). The template is designed for Base Year FY 2026 and includes optional years (OY1-OY4), with fully burdened cost calculations using a 58% total conversion factor, 30% fringe benefit percentage, and 10% overhead of labor as default rates.
The pricing matrix requires offerors to populate labor categories across three primary service areas: Non-IT Labor (On-Site Program Manager, Test Examiners, Test Schedulers for both OPI and Web-Based functions), IT Labor, and Bureau of Labor Statistics (BLS) labor. Each labor category requires offerors to specify wage options with documented sources (such as Department of Labor BLS or GSA), apply appropriate inflation factors using the Army's Joint Inflation Calculator, and calculate unburdened hourly rates, estimated costs by year, fringe and overhead costs, and fully burdened annual rates. The template includes columns for phase-in hours, full performance hours, and cost projections across all contract years, with automatic calculations for Contract Full-Time Equivalents (CFTE) based on direct hours divided by 2087. The instructions direct offerors to use the Army's Cost Tools Joint Inflation Calculator to derive inflation factors starting from the labor rate source year and applying them to the appropriate contract year, with emphasis that inflation factors are preset for FY 2020 base year using 2018 DoL BLS dollars but can be modified as needed.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| OPI_W911S026RA004_QA 04012026.xlsx | XLSX spreadsheet | |
| DLI OPI_W911S026RA004 3.13.26.pdf | ||
| DLI_Atch 2 Pricing Matrix 11.25.25 KO.xlsx | XLSX spreadsheet | |
| DLI_Atch 1 PWS Test Scheduling and Adminstration Services (FY26-31).pdf |
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
Labor Rate Build Up
| Base FY of Contract | 2026 |
| Fully Burdened Cost Conversion | 58% |
tc={D258157F-CBDD-43F8-B22B-9202B847D378}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Update these for Offeror’s numbers
| Fringe Benefit Percentage | 30% | |||||||||||||
| Overhead of Labor | 10% | |||||||||||||
| DIRECT LABOR BY CATEGORY | RequirementSpecific Tasks PWS Paragraphs | WAGE OPTION | ||||||||||||
| (Detail source of Labor Rate, such as DOL BLS, GSA Calc, Prior Yr Contract) | Base Year Inflation Factor | Labor Rate | BASE YEAR PHASE-IN HOURS | BASE YEAR FULL PERFORMANCE HOURS | BASE YEAR TOTAL HOURS | OY1 TOTAL HOURS | OY2 TOTAL HOURS | OY3 TOTAL HOURS | OY4 TOTAL HOURS | X | costs converted to FY hourly UNBURDENED labor rate | = | BASE YEAR ESTIMATED COST | BASE YEAR ESTIMATED COST |
(Fringe) The default rate of 30% will be used BASE YEAR ESTIMATED COST (Overhead) The default rate of 10% will be used BASE YEAR ESTIMATED COST
DIRECT LABOR TOTAL
| (Fully Burdened Annual Rate) | costs converted to FY hourly BURDENED labor rate | OPT YEAR 1 ESTIMATED COST | OPT YEAR 2 ESTIMATED COST | OPT YEAR 3 ESTIMATED COST | OPT YEAR 4 ESTIMATED COST |
| NON-IT LABOR | |||||
| On-Site Program Manager |
tc={66D7795B-B0FD-4C16-AC75-7915178FAB2C}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Update for offerors proposed labor categories | 1.3.1 | Hourly Unburdened Rate | 1.031 | ERROR:#VALUE! | X | = | ||||||||||||||||
| Test Examiners (Six Examiners) | 1.3.2 | Hourly Unburdened Rate | 1.031 | ERROR:#VALUE! | X | $0.00 | = | |||||||||||||||
| Test Scheduler (OPI) | 1.3.3 | Hourly Unburdened Rate | 1.031 | ERROR:#VALUE! | X | $0.00 | = | |||||||||||||||
| Test Scheduler (Web-Based) | 1.3.3 | Hourly Unburdened Rate | 1.031 | ERROR:#VALUE! | X | $0.00 | = | |||||||||||||||
| NON-IT LABOR SUBTOTAL | 0 | 0 | ERROR:#VALUE! | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
IT LABOR
| IT LABOR SUBTOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| BLS | BLS | ||||||||||||||||
| TOTAL DIRECT LABOR | ERROR:#VALUE! | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| CFTE (Direct Hours/2087) | ERROR:#VALUE! | 0.00 | 0.00 | 0.00 | 0.00 | ||||
| BLS | BLS | BLS | BLS | BLS |
Update these for Offeror’s numbers
Update for offerors proposed labor categories
&D
InflationFactor
| Instructions for deriving the inflation factors: | ||
| Step 1 | Go to the following link: | https://www.asafm.army.mil/Cost-Materials/Cost-Tools/ |
Step 2 Click on "Joint Inflation Calculator" and select "Save Target as" in order to save the Joint Inflation Calculator (JIC) to your desktop, not an Army shared or network drive. If you save the file to an Army network or shared drive and then attempt to use the JIC file, the macros used to run the JIC file may not work.
Step 3 Open the calculator file and click on the "Enable Content" button
Step 4 Click on the"Query" worksheet at the bottom of the JIC spreadsheet
Step 5 Item 1 - Select "ARMY" at the top of the Inflation Query Sheet
Step 6 Item 2 - Select the correct appropriation
Step 7 Item 3 - Enter the starting point year for the labor rate source, e.g. 2018 if using Bureau of Labor Statistics (DoL BLS)
Step 8 Item A - Select "Constant $ to Constant $" Inflation Type
Step 9 Item B - Enter the year that you wish to derive the inflation factor for
Step 10 Copy the Inflation factor from the Inflation Factor column into the applicable year in the summary worksheet
Step 11 If you have questions or need assistance, please contact your HQ TRADOC AMOD POC
Note: The inflation factors are currently set on the Summary Worksheet to be as if you are using DoL BLS (2018 dollars) and the Base Year is FY 20. These can be overwritten to represent the appropriate factors for your requirement.
https://www.asafm.army.mil/Cost-Materials/Cost-Tools/
File details come from the government source that posted it. Updated .