Exhibit_C-Total_Evaluated_Price_(TEP)Calculation_Spreadsheet,_10_May_19.xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- W9124J-19-R-0023
About this file
This document contains an exhibit detailing the total evaluated price calculation spreadsheet for the Department of Defense Environment, Safety, and Occupational Health Network and Information Exchange (DENIX) platform support services contract. The five-year contract involves support for DENIX operations and maintenance, research and development, software licenses and fees, program support for other agencies, and contractor manpower reporting. Pricing is provided for each of the five contract years using firm fixed prices for most contract line items and not-to-exceed amounts set by the government for program support for other agencies and travel. Labor categories, hours, and fully burdened rates are also included for the research and development contract line item. The total evaluated price for the base five-year contract period is $15,050,000 with an additional $1,505,000 for a potential six-month extension of services, resulting in a total evaluated price of $16,555,000.
Exhibit C, W9124J-19-R-0023, Total Evaluated Price (TEP) Calculation Spreadsheet, 10 May 19
View the file
Other files
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
| Exhibit C - Total Evaluated Price Calculation Spreadsheet for the Five Year Ordering Period |
| Ordering Year 1 |
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 0001 | FOP | DENIX Operations and Maintenance (based on 12 Months of Performance) | 1 | Job | $0.00 | $0.00 |
| 0002 | FOP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 |
| 0003 | FOP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 |
| 0004 | FOP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 |
| 0005 | FOP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| 0006 | CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 |
| 0007 | FOP | Phase-in (30 days) | 1 | Each | $0.00 | $0.00 |
| Total for ordering Year 1 | $3,010,000.00 | |||||
| * NOT to Exceed |
Ordering Year 2
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| Ordering Year 2 | FOP | DENIX Operations and Maintenance (based on 12 Months of Performance) | 1 | Job | $0.00 | $0.00 |
| FOP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 | |
| FOP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | |
| FOP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | |
| FOP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |
| CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |
| Total for ordering Year 2 | $3,010,000.00 | |||||
| * NOT to Exceed |
Ordering Year 3
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| Ordering Year 3 | FOP | DENIX Operations and Maintenance (based on 12 Months of Performance) | 1 | Job | $0.00 | $0.00 |
| FOP | DENIX RATE | 1 | Job | $0.00 | $0.00 | |
| FOP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | |
| FOP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | |
| FOP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |
| CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |
| Total for ordering Year 3 | $3,010,000.00 | |||||
| * NOT to Exceed |
Ordering Year 4
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| Ordering Year 4 | FOP | DENIX Operations and Maintenance (based on 12 Months of Performance) | 1 | Job | $0.00 | $0.00 |
| FOP | DENIX RATE | 1 | Job | $0.00 | $0.00 | |
| FOP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | |
| FOP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | |
| FOP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |
| CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |
| Total for ordering Year 4 | $3,010,000.00 | |||||
| * NOT to Exceed |
Ordering Year 5
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| Ordering Year 4 | FOP | DENIX Operations and Maintenance (based on 12 Months of Performance) | 1 | Job | $0.00 | $0.00 |
| FFP | DENIX RATE | 1 | Job | $0.00 | $0.00 | |
| FOP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | |
| FOP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | |
| FOP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |
| CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |
| FOP | Phase-out | 1 | Each | $0.00 | $0.00 | |
| Total for ordering Year 5 | $3,010,000.00 | |||||
| * NOT to Exceed |
SUMMARY TOTALS FOR THE FIVE YEAR ORDERING PERIOD
(Shall Match the proposed totals on Blocks 19-24 of the SF-1449)
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 0001 | FOP | DENIX Operations and Maintenance | 1 | Job | $0.00 | $0.00 |
| 0002 | FOP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 |
| 0003 | FOP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 |
| 0004 | FOP | Program Support For Other Agencies | 1 | Job* | $15,000,000.00 | $15,000,000.00 |
| 0005 | FOP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| 0006 | CR | Travel | 1 | Job* | $50,000.00 | $50,000.00 |
| 0007 | FOP | Phase-in | Each | Each | $0.00 | $0.00 |
| 0008 | FOP | Phase-out | Each | Each | $0.00 | $0.00 |
| Total - Year 5 | $15,050,000.00 |
| Subtotal | $15,050,000.00 |
| 6 Month Extension of Services | $1,505,000.00 |
| Total Evaluated Price | $16,555,000.00 |
| Notes |
| For evaluation purposes only, the following will apply: |
| This requirement has one five year ordering period. For evaluation purposes, the price for each ordering year will be broken out for each CLIN. |
Firm Fixed Prices (FFPs) proposed for the Contract Line Item Numbers (CLINs) 0001,0002, 0003, 0005, and 0007 in ordering year one, will be utilized to award FFP Task Orders (TOs) within ordering year 1, should any be awarded.
The FFPs proposed for ordering years two (2) through five (5) for CLINs 0001, 0005, and 0008 will be utilized to award future FFP TOs, should any be awarded.
Historical hours are provided for CLINs 0002 (for Ordering Years 2,3,4, and 5); the proposed FFP fully burdened rates will be applied to the Government provided historical hours to calculate the evaluated price for this CLIN.
A Not To Exceed (NTE) Amount is provided by the Government for CLINS 0004 and 0006. Do not adjust these amounts; these amounts will be the evaluated prices for these CLINs
The sum of all the CLINs evaluated price represents the Total Evaluated Price (TEP) as indicated in Addendum to FAR Provision 52.212-2
Fully Burdened Rates
| Five Year Order Period | |||||
| Labor Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Note: Include in this spreadsheet the proposed fully burdened rates for all CLINs |
| The proposed fully burdened labor rates for each ordering year shall be fixed and become part of the Indefinite Delivery/Indefinite Quantity (IDIQ) contract |
| Provide the cost breakdown of the fully burdened rates |
Ordering Year 1
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE |
| 0001 | FFP | DENIX Operations and Maintenance | 1 | Job | $0.00 | $0.00 |
| 0002 | FFP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 |
| 0003 | FFP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 |
| 0004 | FFP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 |
| 0005 | FFP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 |
| 0006 | CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 |
| 0007 | FFP | Phase-in | 1 | Each | $0.00 | $0.00 |
| Total - Year 1 | $3,010,000.00 | |||||
| NOTE: This is year one of a five year order period | ||||||
| * NOT to Exceed |
Ordering Year 2
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE | CLIN | LABOR CATEGORY | HOURS | FULLY BURDENED RATE | TOTAL |
| 0001 | FFP | DENIX Operations and Maintenance | 1 | Job | $0.00 | $0.00 | 0002 | IT Engineer | 3600 | $0.00 | |
| 0002 | FFP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 | Senior Developer | 4800 | $0.00 | ||
| 0003 | FFP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | Program Manager | 600 | $0.00 | ||
| 0004 | FFP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | 9000 | $0.00 | |||
| 0005 | FFP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |||||
| 0006 | CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |||||
| Total - Year 2 | $3,010,000.00 | ||||||||||
| NOTE: This is year two of a five year order period |
Ordering Year 3
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE | CLIN | LABOR CATEGORY | HOURS | FULLY BURDENED RATE | TOTAL |
| 0001 | FFP | DENIX Operations and Maintenance | 1 | Job | $0.00 | $0.00 | 0002 | IT Engineer | 1200 | $0.00 | |
| 0002 | FFP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 | Senior Developer | 1600 | $0.00 | ||
| 0003 | FFP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | Program Manager | 200 | $0.00 | ||
| 0004 | FFP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | 3000 | $0.00 | |||
| 0005 | FFP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |||||
| 0006 | CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |||||
| Total - Year 3 | $0.00 | $3,010,000.00 | |||||||||
| NOTE: This is year three of a five year order period |
Ordering Year 4
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE | CLIN | LABOR CATEGORY | HOURS | FULLY BURDENED RATE | TOTAL |
| 0001 | FFP | DENIX Operations and Maintenance | 1 | Job | $0.00 | $0.00 | 0002 | IT Engineer | 1200 | $0.00 | |
| 0002 | FFP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 | Senior Developer | 1600 | $0.00 | ||
| 0003 | FFP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | Program Manager | 200 | $0.00 | ||
| 0004 | FFP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | 3000 | $0.00 | |||
| 0005 | FFP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |||||
| 0006 | CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |||||
| Total - Year 4 | $3,010,000.00 | ||||||||||
| NOTE: This is year four of a five year order period |
Ordering Year 5
| CLIN | Type | DESCRIPTION | QTY | UNIT OF ISSUE | MONTHLY PRICE | TOTAL PRICE | CLIN | LABOR CATEGORY | HOURS | FULLY BURDENED RATE | TOTAL |
| 0001 | FFP | DENIX Operations and Maintenance | 1 | Job | $0.00 | $0.00 | 0002 | IT Engineer | 3600 | $0.00 | |
| 0002 | FFP | DENIX RDT&E | 1 | Job | $0.00 | $0.00 | Senior Developer | 4800 | $0.00 | ||
| 0003 | FFP | Software Licenses and Fees | 1 | Job | $0.00 | $0.00 | Program Manager | 600 | $0.00 | ||
| 0004 | FFP | Program Support For Other Agencies | 1 | Job* | $3,000,000.00 | $3,000,000.00 | 9000 | $0.00 | |||
| 0005 | FFP | Contractor Manpower Reporting | 1 | Job | $0.00 | $0.00 | |||||
| 0006 | CR | Travel | 1 | Job* | $10,000.00 | $10,000.00 | |||||
| 0008 | FFP | Phase-out | 1 | Each | $0.00 | $0.00 | |||||
| Total - Year 5 | $3,010,000.00 | ||||||||||
| NOTE: This is year five of a five year ordering period |
File details come from the government source that posted it. Updated .