J8__Revised_Cost_Model_J4_TO_0001.xlsx

Inputs and Instructions

Section B

and ODC - Cost Detail Worksheet

&F, &A

PAGE &P OF &N

Cost Summary

Total $ 24,563.00 $ 122,815.00 $ 147,378.00

Labor Detail

Enter a P if performed by the prime

Rate Less Profit

Enter a P if performed by the prime

Rate Less Profit

ODC Detail

Microsoft_Word_Document1.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 criteria in FAR 15.404-1. In accordance with the solicitation, the total evaluated price will NOT include the transition in period.

Overall Instructions

The Offeror is to complete any light green shaded cells. Please note that dark green cells may populate in the Section B worksheet.

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

Inputs and Instructions Worksheet

Type the appropriate name of the Prime Contractor/Subcontractor/Division in cell B7. It will carry through the remaining worksheets.

Section B Worksheet

The Section B worksheet imports data from the Cost Summary, Labor Detail, and ODC Detail worksheets and is used as a basis for the proposed formal Section B. Please note there are green shaded cells on this worksheet. It is a different shade of green. Data is NOT to be entered into these cells. They are conditionally formatted to provide a check that the total proposed price is calculated properly in all cells. If the math checks out, the cells will turn green. If not, the cells will be red. There are no inputs on this worksheet.

Cost Summary Worksheet

This worksheet is for Government analysis purposes. It is populated from the Labor Detail, ODC Detail. There are no inputs on this worksheet.

Labor Detail Worksheet

Prime Or Sub

The offeror is to enter a P in column E if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in column F. If the particular individual category is to be performed jointly by more than one entity (i.e. the prime and a sub or subs), the offeror will be required to insert additional row(s) under the labor category and to allocate the column D hours for the individual category to be performed among the prime and subs. After this allocation, the total of the original and inserted rows under the individual category in column A shall total to the number of hours provided by or to the Government for the respective labor category.

Direct Labor Rate

Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer for proprietary reasons.

Fringe

Apply fringe to the direct labor rates inclusive of statutory (i.e. FICA, FUTA, SUTA, Workman's Comp) and non-statutory (i.e. health insurance, 401K, etc, vacations, holidays, etc). Subcontractors may submit this information directly to the Contracting Officer for proprietary reasons.

Billing Rate

This field will automatically calculate the prime hourly burdened rate before the application of G&A and fee. If the prime is proposing the use of a subcontractor, please enter the subcontractor billing rate (if performed by a subcontractor).

The rate calculated for prime contractor performed rate categories is: Rate Less Profit = Prime Direct Labor Rate + Prime Fringe.

If the labor category is performed by a subcontractor, the rate entered in column I is: Subcontractor Billing Rate Less Prime Profit = Sub Direct Labor Rate + Any Applicable Sub Indirect Rates.

Other Direct Costs

Please enter the requested data in the light green shaded areas on the ODC 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. Since these are estimated amounts that may or may not occur, no fixed fee or profit will be allowed on the ODCs.

image1.emf