Attachment L-3 Cost Model 4-09-2025 8 pgs.xlsx
XLSX spreadsheet 60 KB Posted
- Attached to
- DOE/NNSA Clearance Action Tracking System (CATS) Development & Maintenance Support Services.
- Solicitation number
- 89233125RNA000262
About this file
This document is a detailed Cost Model Excel spreadsheet for the DOE/NNSA Clearance Action Tracking System (CATS) Development & Maintenance Support Services contract (Solicitation Number 89233125RNA000262). The cost proposal covers a base period and four option periods, with a total proposed cost of $125,000 over five years. The pricing structure includes a Firm Fixed Price (FFP) transition period and Time & Materials (T&M) pricing for labor and Other Direct Costs (ODCs), with a consistent annual ODC budget of $25,000 per year.
The spreadsheet provides a comprehensive cost breakdown template requiring contractors to detail labor categories, rates, indirect costs, and profit calculations. It includes instructions for proposing fully burdened labor rates, with placeholders for labor categories, base rates, escalation, fringe benefits, overhead, G&A, and profit. The contract anticipates a start date of September 15, 2025, and instructs offerors to propose costs according to each contract fiscal year, with flexibility to adapt to the contractor's established accounting and estimating practices.
View the file
Other files
Show all 24
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
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 0001 - Transition (FFP) | $ - 0 | ||||
| CLIN 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 |
| SUBCONTRACTS/CONSULTANTS/IOTs | ||||||
| SUBCONTRACT 1 (See Sub CFY Cost Summaries) | 0 | 0 | 0 | 0 | 0 | 0 |
| SUBCONTRACT 2 (See Sub CFY Cost Summaries) | 0 | 0 | 0 | 0 | 0 | 0 |
| CONSULTANT 1 (See Consultant Agreement) | 0 | 0 | 0 | 0 | 0 | 0 |
| CONSULTANT 2 (See Consultant Agreement) | 0 | 0 | 0 | 0 | 0 | 0 |
| TOTAL SUBCONTRACTS/CONSULTANTS | $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 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.
| 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 price 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.
T&M Rates
| 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 |
&"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 |
File details come from the government source that posted it. Updated .