Amendment 0001 Atch B_Pricing Matrix (Total Evaluated Price )_W9124J25C0010 REVISED 12.31.24.xlsx
XLSX spreadsheet 27 KB Posted
- Solicitation number
- W9124J-25-R-0010
About this file
This is a pricing matrix spreadsheet (Amendment 0001 Attachment B) for solicitation W9124J-25-R-0010 for Communication and Planning Support Services at the Pentagon. The spreadsheet outlines the Total Evaluated Price (TEP) structure for a base year plus four option years, with each year containing FFP CLINs for OCPA Communication Services Support and Contract Manpower Reporting, plus a Cost CLIN for Other Direct Costs fixed at $200,000 per year.
The total contract value includes $1,000,000 in predetermined ODCs ($200,000 per year) plus FAR 52.212-8 amount of $100,000, for a TEP of $1,100,000. The spreadsheet requires offerors to input labor categories, hours, and fully burdened rates, with breakdowns showing fringe, overhead, G&A, and profit components. The contract includes a 50% limitation on subcontracting requirement for the services portion. The base year is structured as 11 months of full performance plus a 30-day phase-in period, while option years are 12 months each.
View the file
Other files
Show all 14
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
Total Evaluated Price
| REVISED 23 DECEMBER 2024 - Amendment 1 |
| Attachment B- Total Evaluated Price Calculation Spreadsheet |
| W9124J25R0010 Communication and Planning Support Services |
| Base Year |
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE | Notes |
| 0001 | FFP | Phase-in (30 days) | 1 | month | $0.00 | $0.00 | For evaluation purposes only, the following will apply: |
| 0002 | FFP | OCPA Communication Services Support | 11 | month | $0.00 | $0.00 | This requirement has a Base plus four (4) Option years. For evaluation purposes, the price for each year will be broken out for each CLIN. |
| 0003 | COST | Other Director Cost | 1 | Job | $200,000.00 | $200,000.00 | The sum of all the CLINs evaluated price represents the Total Evaluated Price (TEP) as indicated in Addendum to FAR Provision 52.212-2 |
| 0004 | FFP | Contract Manpower Reporting | 1 | Job | $0.00 | $0.00 | |
| Total for Base Year | $200,000.00 | CLIN 0003, 1002, 2002, 3002 and 4002 for ODC are a NTE Plug Value. You do not need to propose under those CLINS. |
| Add CMR cost if any, if NSP, indicate, NSP. | |
| Option Year 1 |
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 1001 | FFP | OCPA Communication Services Support | 12 | month | $0.00 | $0.00 |
| 1002 | COST | Other Director Cost | 1 | Job | $200,000.00 | $200,000.00 |
| 1003 | FFP | Contract Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| Total for Option Year 1 | $200,000.00 |
Option Year 2
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 2001 | FFP | OCPA Communication Services Support | 12 | month | $0.00 | $0.00 |
| 2002 | COST | Other Director Cost | 1 | Job | $200,000.00 | $200,000.00 |
| 2003 | FFP | Contract Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| Total for Option Year 2 | $200,000.00 |
Option Year 3
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 3001 | FFP | OCPA Communication Services Support | 12 | month | $0.00 | $0.00 |
| 3002 | COST | Other Director Cost | 1 | Job | $200,000.00 | $200,000.00 |
| 3003 | FFP | Contract Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| Total for Option Year 3 | $200,000.00 |
Option Year 4
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 4001 | FFP | OCPA Communication Services Support | 12 | month | $0.00 | $0.00 |
| 4002 | COST | Other Director Cost | 1 | Job | $200,000.00 | $200,000.00 |
| 4003 | FFP | Contract Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| Total for Option Year 4 | $200,000.00 |
Total $1,000,000.00
FAR 52.212-8 $100,000.00
| TEP | $1,100,000.00 | |
| IAW 52.219-14(e)(1) Limitations on Subcontracting (Oct 2022) (DEVIATION 2021-O0008), the contractor, by submission of an offer and execution of a contract, agrees that in performance of a contract, it will not pay more than 50 percent of the amount paid by the Government for contract performance, excluding certain other direct costs and certain work performed outside the United States (see paragraph (e)(1)(i)), to subcontractors that are not similarly situated entities. Any work that a similarly situated entity further subcontracts will count towards the prime contractor’s 50 percent subcontract amount that cannot be exceeded. When a contract includes both services and supplies, the 50 percent limitation shall apply only to the service portion of the contract. |
Offeror shall provide total break out cost per Sub per period to demonstrate compliance with this clause
Base Year
| Base Year | |||||
| Labor Category | Labor Hours | Full Burdened rate | Total | Tools title | Cost per Base Year |
| $0 |
Total for CLIN 0001 $0 Total for CLIN 0003 ODC $0.00
| Base Year | |||
| Labor Category | Labor Hours | Full Burdened rate | Total |
| $0 |
| Total for CLIN 0002 | $0 |
| Monthly | $0 |
Option Year 1
| Option Year 1 | |||||
| Labor Category | Labor Hours | Full Burdened rate | Total | Tools title | Cost per Option Year One |
| $0.00 |
| Total for CLIN 1001 | $0.00 | Total for CLIN 1002 ODC |
| Monthly | $0.00 |
Option Year 2
| Option Year 2 | |||||
| Labor Category | Labor Hours | Full Burdened rate | Total | Tools title | Cost per Option Year Two |
| $0.00 |
| Total for CLIN 2001 | $0.00 | Total for CLIN 2002 ODC |
| Monthly | $0.00 |
Option Year 3
| Option Year 3 | |||||
| Labor Category | Labor Hours | Full Burdened rate | Total | Tools title | Cost per Option Year Three |
| $0.00 |
| Total for CLIN 3001 | $0.00 | Total for CLIN 3002 ODC |
| Monthly | $0.00 |
Option Year 4
| Option Year 4 | |||||
| Labor Category | Labor Hours | Full Burdened rate | Total | Tools title | Cost per Option Year Four |
| $0.00 |
| Total for CLIN 4001 | $0.00 | Total for CLIN 4002 ODC |
| Monthly | $0.00 |
Rates Breakdown
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||||||||||||||
| Labor Category | Rates | Fringe | OH | G&A | Profit | Full Burdened Rate | Labor Category | Rates | Fringe | OH | G&A | Profit | Full Burdened Rate | Labor Category | Rates | Fringe | OH | G&A | Profit | Full Burdened Rate | Labor Category | Rates | Fringe | OH | G&A | Profit | Full Burdened Rate | Labor Category | Rates | Fringe | OH | G&A | Profit | Full Burdened Rate |
Note: Include in this spreadsheet the proposed labor categories and appropriate rates
This table can be edited and adjusted as needed, as long as cost breakdown is provided.
File details come from the government source that posted it. Updated .