Attachment L-3 Cost Model Rev 2 08.11.2025 10 pages.xlsx

About this file

View the file

Other files

Work with this file

Text version

XLSX spreadsheet 69 KB Posted Aug 12, 2025

Attached to: DOE/NNSA Clearance Action Tracking System (CATS) Development & Maintenance Support Services.
Solicitation number: 89233125RNA000262
Issued by: Department of Energy National Nuclear Security Administration

Written by GovTribe AI · Aug 12, 2025

This document is an Excel-based cost model attachment (Attachment L-3) for the DOE/NNSA Clearance Action Tracking System (CATS) Development & Maintenance Support Services contract (Solicitation Number 89233125RNA000262). The cost model details a five-year contract structure with a base period and four option periods, featuring Time & Materials (T&M) labor rates and Other Direct Costs (ODCs). The total proposed costs are $125,000, with $25,000 allocated annually for ODCs/Materials, and labor rates structured across eight labor categories with fully burdened hourly rates to be determined by the offeror.

The document provides comprehensive instructions for contractors to complete the cost proposal, including requirements for breaking down labor rates by cost elements, identifying base labor rates, applying indirect rates, calculating profit, and accounting for potential New Mexico Gross Receipts Tax. The cost model emphasizes that offerors are solely responsible for the accuracy of formulas, links, and amounts, and should propose costs in accordance with their established accounting and estimating practices. The contract period of performance appears to start between September 15, 2025, and March 9, 2026, with the most recent amendment extending the proposal due date to August 28, 2025.

File	Type	Posted
Attachment L-1 Solicitation Instructions to Offerors and Evaluation Rev 2 7 pgs.pdf	PDF	Aug 12, 2025
89233125RNA000262 Amend 0004.pdf	PDF	Aug 12, 2025
Attachment L-11- Questions and Answers Rev 1 08.11.2025 42 Pages (2).pdf	PDF	Aug 12, 2025
Solicitation Cover Letter Amend 4 08.12.2025 3 pages.pdf	PDF	Aug 12, 2025
Attachment L-7 -Past Performance Questionnaire 08.07.25 Rev 2 4 pages.docx	DOCX document	Aug 12, 2025
Attachment L-8 -Past Performance Questionnaires Contract List 08-07-2025 Rev 1 1 pg.xlsx	XLSX spreadsheet	Aug 12, 2025

On GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

SUBCONTRACTS/CONSULTANTS/IOTs

SUBCONTRACT 1 (See Sub CFY Cost Summaries)

SUBCONTRACT 2 (See Sub CFY Cost Summaries)

CONSULTANT 1 (See Consultant Agreement)

CONSULTANT 2 (See Consultant Agreement)

TOTAL SUBCONTRACTS/CONSULTANTS

The file's text, extracted by GovTribe without its formatting.

Rev 2 Changes

SUMMARY TAB

1. CLIN 0001 was changed to CLIN 0003 - Transition (FFP)

2. CLIN 0002 was changed to 0001 - Labor (T&M)

Rev 1 Changes July 30, 2025 Revision 1 Changes:

1. Labor Rate Pricing Sheet: Added the following: 8. The Offeror is solely responsible for the accuracy of all formulas, links and amounts. Also, highlighted the following statement: ***Categories marked with (Sub) are subcontractor labor categories, Base Rate is the subcontractor’s fully burdened rate. Corrected the following: 1. All offered hourly prices should be fully burdened.

2. Rate Summary Sheet: Added the following: *Subcontractor Fully Burdened Labor Rates should be included in the above table.

3. Subs – Tbl 2: Added the following statements: This table should reflect the total subcontractor price. This table does not link to other tables, however proposed subcontractor prices should agree with subcontractor prices detailed elsewhere in the proposal. The Offeror is solely responsible for the accuracy of all formulas, links and amounts within this workbook.

SUMMARY

RFP: 89233125RNA000262

SUMMARY OF PROPOSED COSTS

COST ELEMENT SUMMARY OF ALL COSTS

CLIN Base Year Option 1 Option 2 Option 3 Option 4

CLIN 0003 0001 - Transition (FFP)	$ - 0
CLIN 0001 0002 - Labor (T&M)	$ -	$ -	$ -	$ -	$ -
CLIN 0002 - ODCs/Materials (T&M)	$ 25,000	$ 25,000	$ 25,000	$ 25,000	$ 25,000

TOTAL PROPOSED COSTS $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000

5 YR TOTAL $ 125,000

Attachment L-3 April 9, 2025

Transition Period

WARNING: LABOR CATEGORIES, SUBCONTRACTS, TYPES OF COSTS, BASES AND RATES IN TABLE 1 ARE FOR ILLUSTRATION PURPOSES ONLY.

PROPOSE ALL COSTS IN ACCORDANCE WITH YOUR ESTABLISHED ACCOUNTING AND ESTIMATING PRACTICES.

TABLE 1: COST ELEMENT SUMMARY	CONTRACTOR FISCAL YEAR (CFY) 1			CFY 2			CFY 3			CFY 4			CFY 5			TOTAL
	BASE PERIOD			OPTION PERIOD 1			OPTION PERIOD 2			OPTION PERIOD 3			OPTION PERIOD 4			ALL PERIODS
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
DIRECT LABOR	Lbr Hrs			Lbr Hrs			Lbr Hrs			Lbr Hrs			Lbr Hrs
LABOR CATEGORY 1	0	$ - 0	$0	0	$ - 0	$0	0	$ - 0	$0	0	$ - 0	$0	0	$ - 0	$0	0	$0
LABOR CATEGORY 2	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	0
LABOR CATEGORY 3	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	0
LABOR CATEGORY 4	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	0
ETC.	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	$ - 0	0	0	0
TOTAL DIRECT LABOR	0		$0	0		$0	0		$0	0		$0	0		$0	0	$0

FRINGE BENEFITS	$ - 0	0.0%	0	$ - 0	0.0%	0	$ - 0	0.0%	0	$ - 0	0.0%	0	$ - 0	0.0%	0	0
LABOR OVERHEAD (if applicable)	$ - 0	0.0%	0	$ - 0	0.0%	0	$ - 0	0.0%	0	$ - 0	0.0%	0	$ - 0	0.0%	0	0
TOTAL INDIRECT LABOR EXPENSE			$0			$0			$0			$0			$0	$0

MATERIALS 0 0 0 0 0 0

SUBTOTAL $0 $0 $0 $0 $0 $0

G&A	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	0
TOTAL COSTS			$0			$0			$0			$0			$0	$0
PROFIT	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	0

SUBTOTAL PRICE			$0			$0			$0			$0			$0	$0
NMGRT (if applicable)	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	$ - 0	0.00%	0	0
TOTAL PRICE			$0			$0			$0			$0			$0	$0

check number: $ - 0

April 9, 2025

Notes:

1. This is for the Transition Period only and is Firm Fixed Price. The "BASE" column should include direct productive labor hours, indirect base amounts, or fee base amounts as applicable.

2. Keep all formulas and links intact and do not protect any of the cells.

3. The Offeror is solely responsible for the accuracy of all formulas, links and amounts within this workbook.

Labor Rate Pricing

National Nuclear Security Administration CATS

Contract # - TBD

Company Name

T&M Labor Rate

The following tables are examples of the required cost proposal format, but may be revised as necessary to be consistent with your established accounting and estimating systems.

For pricing purposes, assume a contract start date of March 9, 2026 September 15, 2025. The period of performance contains a base period with four options. Propose all costs in accordance with each

contract fiscal year (CFY) as shown below. If composite direct and/or indirect rates are used due to differences in fiscal periods, then revise the templates to show how the

composite CFY rates are developed. Keep all spreadsheet formulas and cell references intact. Additional supporting cost information may be requested if necessary to

determine cost/price reasonableness.

INSTRUCTIONS - LABOR RATES

1. Provide a complete breakdown by cost element for each proposed labor rate (i.e., direct labor, O/H, G&A, profit and taxes). Show how the indirect rates and profit are applied to the base

labor rates to arrive at the fixed fully burdened hourly rates. For each cost element, provide a narrative explanation describing your estimating methodology and basis for the proposed costs.

2. Labor Rates: Identify base labor rates (unburdened) for each labor category and the source of the rates (e.g., actual rates for named individuals, FPRA, average category rates, etc.).

If the labor rates are escalated, separately identify the escalation rate and show how escalation is applied to the base rates in order to arrive at the proposed rates.

3. Indirect Rates: Show the proposed indirect rates by CFY for all applicable burdens. Identify the application bases and the major cost elements included in each indirect rate pool. Provide

a narrative explanation regarding the basis of estimate for the proposed rates (i.e., FPRA, billing rates, historical rates, budget estimates, DCAA audited rates, etc.).

Change formulas below as necessary to adhere to your established accounting and estimating practices.

4. Profit: Show the proposed profit applied to each labor category. Although not required, the contractor is encouraged to provide substantiation for the proposed profit.

5. New Mexico Gross Receipts Tax (NMGRT)(If Applicable): This represents the applicable NMGRT for the NM location in which services are rendered.

6. Fixed Rate: This represents the offered fixed price for each fully burdened hourly labor rate. Agreed-upon rates will be incorporated into the contract.

7. Fiscal Years: Please provide fully burdened labor rates for each year of the period of performance.

8. The Offeror is solely responsible for the accuracy of all formulas, links and amounts.

Please add another Excel tab(s) to fully narrate basis and methodology as necessary.
*Enter all information as required in the yellow highlighted cells for each contract period.
**The below proposed fully burdened labor rates will link directly into the "Rate Summary" sheet.
*** Categories marked with (Sub) are subcontractor labor categories, Base Rate is the subcontractor's fully burdened rate.
	Base Labor (Unburdened)	Year 1 - Indirect Rates	Year 2 - Indirect Rates	Year 3 - Indirect Rates	Year 4 - Indirect Rates	Year 5 - Indirect Rates
	Escalation	0.00%	0.00%	0.00%	0.00%	0.00%
	Fringe	0.00%	0.00%	0.00%	0.00%	0.00%
	OH	0.00%	0.00%	0.00%	0.00%	0.00%
	G&A	0.00%	0.00%	0.00%	0.00%	0.00%
	Profit	0.00%	0.00%	0.00%	0.00%	0.00%
	NMGRT	0.00%	0.00%	0.00%	0.00%	0.00%
Labor Categories	Base Rate - Year 1	Year 1 - Fully Burdened Rate	Year 2 - Fully Burdened Rate	Year 3 - Fully Burdened Rate	Year 4 - Fully Burdened Rate	Year 5 - Fully Burdened Rate
Labor Category 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 4	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 5	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 6	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 7	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 8	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
1. All offered hourly prices should be fully burdened.

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

Rate Summary

RFP: 89233125RNA000262

National Nuclear Security Administration CATS

Contract # - TBD

Company Name

T&M Labor Rate

The following tables are the proposed labor rates for the Base Period and Four Options, applicable to this contract.

CLIN 000X - Labor T&M rates
T&M Rates (Fully Burdened)	Base Period - T&M Rates	Option 1- T&M Rates	Option 2 - T&M Rates	Option 3 - T&M Rates	Option 4- T&M Rates
Labor Categories*
Labor Category 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 4	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 5	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 6	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 7	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor Category 8	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
*Subcontractor Fully Burdened Labor Rates should be included in the above table.

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

Labor Hours and Summary Dollars

PRICE QUOTE INSTRUCTIONS- LABOR HOUR

Enter all information as required in the yellow highlighted cells for each contract order period.

Keep formulas and links intact and DO NOT protect cells. You may add supporting information or insert rows or columns if required.

Column (1): This column identifies the task areas as set forth in the PWS for this contract.

Column (2): Identify your proposed labor categories exactly as filled out under Labor Rate Pricing. Do not combine different labor categories!

Column (3): Utilize Labor Rate as established under T&M Rates Proposed.

Column (4): Enter the total labor hours proposed for the effort to be performed by this labor category during the performance period.

Column (5): This column shows the extended price quoted for each labor category.

A separate tab for determining the offeror's Direct Productive Labor Hour (DPLH) per each Full Time Equivalent (FTE) has been provided.

Continued Columns - These columns repeat columns 3 through 5 for performance Years 2 through 5

Company Name
Contract # - TBD
CLIN NUMBER:
PERIOD OF PERFORMANCE (POP): 12/01/2020 - 11/30/2025
(1) Contract Areas - CLIN 0001	(2) Contract Labor Categories	(3) Labor Rate Year 1	(4) Hours Year 1	(5) Price Year 1	Labor Rate Year 2	Hours - Year 2	Price Year 2	Labor Rate Year 3	Hours - Year 3	Price Year 3	Labor Rate Year 4	Hours - Year 4	Price Year 4	Labor Rate Year 5	Hours - Year 5	Price Year 5
Labor Categories
	Labor Category 1	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 2	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 3	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 4	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 5	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 6	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 7	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
	Labor Category 8	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -	$ - 0	0	$ -
Labor Categories	sub Totals		0	$ -		0	$ -		0	$ -		0	$ -		0	$ -

TOTAL LABOR HOURS and PRICE- CLIN 0001 0 $ - 0 $ - 0 $ - 0 $ - 0 $ -

Materials/ODCs CLIN 0002 - (Baselined) $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000

NOTES:

1. PWS = Performance Work Statement

2. DPLH = Direct Productive Labor Hours. Direct Productive Labor Hours are defined as actual direct labor hours exclusive of vacation, holiday, sick leave and other absences.

DPLH Calculator Tab is included if needed to determine hours per FTE

3. FTE = Full-Time Equivalent. The Government estimates 1 FTE = 1864 per year under this quotation as it relates to PWS Labor

The Government will not dictate requirements in hours under Labor, the contractor should propose labor consistent with their standard business and estimating practices as it relates to DPLH.

4. ODC CLIN ceiling amounts are established as Not To Exceed (NTE) amounts and shall be included as part of the total price under this contract.

5. Keep all of your Formulas and Links Intact and DO NOT Protect Cells

6. Offerors are solely responsible for verifying the accuracy of the formulas and amounts contained in this spreadsheet

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

DPLH Calculator

Team Member 1:
DPLH CALCULATION for ONE FTE
Available Hours (52 wks x 40 hrs/wk)	2,080
Less Vacation Leave	0
Less Sick Leave	0
Less Admin/Holiday/All Other Leave	0
Team Member DPLH	2,080

NOTES:

1. Fill out in accordance with your company's practice to determine DPLH

2. The leave types listed above outline typical leave provided by companies, but is not all inclusive. Change as needed to reflect your company's practices.

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

ODCs Baselined Other Direct Costs (Baselined)

	Total Yearly Costs
Year 1	$ 25,000
Year 2	$ 25,000
Year 3	$ 25,000
Year 4	$ 25,000
Year 5	$ 25,000

	$ 125,000
Amounts determined determined above are baselined costs.
ODCs, which may include travel shall be reimbursed at actual costs only.

Subs- Tbl 2

TABLE 2

SUBCONTRACTS

PRICE SUMMARY

(Develop a table for each CFY)

SUBCONTRACTOR NAME	SUBCONTRACT TASKS*	SUBCONTRACT CONTRACT TYPE	SUBCONTRACTOR QUOTED PRICE	SUBCONTRACT PRICE PROPOSED BY PRIME
			$ - 0	$ - 0
			$ - 0	$ - 0
			$ - 0	$ - 0
TOTAL AMOUNTS			$ - 0	$ - 0
This table should reflect the total subcontractor price. This table does not link to other tables, however proposed subonctactor costs should agree with subcontractor prices detailed elsewhere in the proposal.
The Offeror is solely responsible for the accuracy of all formulas, links and amounts within this workbook

File details come from the government source that posted it. Updated Aug 14, 2025.