J.11 - Cost Model Excel Workbook (Updated 1 Dec 2025).xlsx

Instructions

Section B

Cost Summary

Indirect Rate Summary

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Direct Labor Rate Schedule

Regular Labor Detail

Surge Labor Detail

Phase-in & OES 52.217-8 Labor

ODC Cost Detail

Fringe Benefit Worksheet

Paid Leave/Vacation (PTO, Sick, Military, etc.) Years of Experience Hours Alloted Per Year

Fringe Worksheet

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead Worksheet

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Worksheet

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Microsoft_Word_Document.docx General

Each offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed workbook shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the cost/price analysis, and cost realism analysis (on cost CLINS) criteria in FAR 15.404-1.

Overall Instructions

· The worksheets are designed to automatically compute and populate other cells in the Excel workbook.

· The worksheet tabs shaded green have inputs required on that worksheet.

· Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H15, the street address in Cell H16, and the city, state, and zip code in Cell H17, and the date of proposal in Cell H18 on the Instructions worksheet of the Cost Model Workbook. These inputs will carry through to display in the headers of the remaining worksheets.

· Please enter the requested data in the green shaded areas on the Indirect Rate Summary worksheet. This data pulls over to the labor detail worksheet.

· Please enter the requested data in the green shaded areas on the Direct Labor Rate Schedule, which includes the proposed labor rates, the cost basis for the rate proposed and the escalation rate used. The direct rate information feeds into the Labor Detail worksheets.

· Please enter the requested data in the green shaded areas on the Labor Detail worksheets, which includes which entity will be performing the work (columns D and E). Column L will only need inputs if the prime offeror is inputting a subcontractor’s fully burdened labor rate into that column.

· Please enter the requested data in the green shaded areas on the ODC Cost Detail worksheet. For the purposes of proposal, the Government has input normalized values for the ODCs. These numbers are to be used. The offerors may add any burden and/or G&A as appropriate in accordance with their disclosed accounting practices. Since these are estimated amounts that may or may not occur, no fixed fee will be allowed on the ODCs.

Section B Worksheet

The Section B worksheet imports data from the Cost Summary, Labor Cost Detail, and ODC Cost Detail worksheets and is used as a basis for the proposed formal Section B. No offeror inputs are required on this worksheet.

Cost Summary Worksheet

This worksheet is for Government analysis purposes. It is populated from the Labor Detail and ODC Cost Detail worksheets.

Indirect Rate Summary Worksheet

Please provide the indirect rates by year directly into this sheet within the green cells as applicable. The rates will automatically populate to the Labor Detail Worksheets.

Direct Labor Rate Schedule Worksheet

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems or different pay rates. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.

Labor Detail Worksheets

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes. For specific instructions, see the Notes that follow.

NOTE 1: Column A is the location where the Labor Category will perform, and will automatically populate from the “Direct Labor Rate Schedule” tab.

NOTE 2: Column B is the type of labor, such as Professional, SCA, CBA, etc. and will automatically populate from the “Direct Labor Rate Schedule” tab.

NOTE 3: Column C identifies the labor categories for this action, and will automatically populate from the “Direct Labor Rate Schedule” tab.

NOTE 4: During contract performance these categories may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a ‘P’ in column D if the effort is to be performed by the prime contractor and a ‘S’ if performed by another division or…