W56JSR-18-R-0016_Attachment_0004_Cost_Data_Worksheet_&_Instructions.xlsx

Instructions

Total Price Summary

Total Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total Fee/Profit on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total Proposed Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Prime Offeror

Prime Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Prime Fee on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Prime Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S_IE 1

S/IE 1 Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 1 Fee/Profit on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 1 Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S_IE 2

S/IE 2 Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 2 Fee/Profit on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 2 Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S_IE 3

S/IE 3 Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 3 Fee/Profit on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 3 Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S_IE 4

S/IE 4 Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 4 Fee/Profit on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 4 Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S_IE 5

S/IE 5 Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 5 Fee/Profit on Labor Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

S/IE 5 Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Microsoft_Word_Document1.docx

1. Table 3: Prime Offeror’s Base Year Indirect Rates – The Prime Offeror shall enter its proposed base year indirect rates’ name and corresponding rate into the Description (cells K5:K14) and Rate (cells L5:L14) columns of Table 3.

2. Table 4: Prime Offeror’s Fixed Fee Rate(s) – The Prime Offeror shall enter its proposed fixed fee rates into Table 4 (cells O5:S5).

“S_IE” Tabs:

Per Section-L-16.3-1.4 of the Solicitation, “S/IE participants may submit proprietary information directly to the Government.

1. Table 5: S/IE’s Direct Labor Rates – For all LCATs that will be staffed by an S/IE, the Prime Offeror or S/IE shall enter the S/IE’s proposed direct labor rates into Table 5 (cells B4:I75) of the applicable “S_IE” Tab of the Cost Data Worksheet.

a. For each LCAT that a S/IE staffs, five (5) direct labor rates shall be entered into the appropriate cells of the applicable Table 5 (columns “D” though “H”) for that S/IE, one (1) direct labor rate for each year of the five (5) year POP.

b. If proposed direct labor rates are entered into Table 5 on any of the “S_IE” tabs, then proposed direct labor rates for the same LCAT may not be entered into Table 2 on the “Prime Offeror” tab or any other “S_IE” tabs of this Cost Data Worksheet

i. Example: The Prime Offeror proposes two (2) S/IEs that will staff multiple LCATs. The Prime Offeror intends to subcontract the staffing of the Test Engineer (Senior/Lead) LCAT to S/IE 1. The Prime Offeror enters S/IE 1’s proposed direct labor rates for the Test Engineer (Senior/Lead) LCAT into cells D60:H60, on the “S_IE 1” tab. The Prime Offeror and its S/IE 2 may not enter proposed direct labor rates for the Test Engineer (Senior/Lead) LCAT into cells D60:H60 on the “Prime Offeror” tab or the “S_IE 2” tab. S/IE 2 may not submit a cost proposal directly to the Government in which it has proposed direct labor rates for the Test Engineer (Senior/Lead) LCAT.

2. Table 6: S/IE’s Base Year Indirect Rates – The Prime Offeror or S/IE shall enter the S/IE’s proposed base year indirect rates’ name and corresponding rate into the Description (K5:K14) and Rate (L5:L14) columns of Table 6 on each applicable “S_IE” tab.

3. Table 7: S/IE’s Fixed Fee/Profit Rate – The Prime Offeror or S/IE shall enter the S/IE’s proposed fixed fee/profit rates into Table 7 on each applicable “S_IE” tab.

image1.emf

Microsoft_Word_Document2.docx Cost Data Worksheet Instructions:

If awarded this contract, barring negotiations, the direct labor rates and fixed fee rates provided by Prime Offeror and its S/IEs and entered into the Cost Data Worksheet, shall become a part of the base IDIQ contract.

Per Section L-16.3-1.2 of the Solicitation, the proposed direct labor rates for each LCAT are bid as if staffed either by the Prime Offeror or one (1) of its S/IEs. No LCATs may be staffed or bid to by the Prime and an S/IE or multiple S/IEs. In other words, “only one (1) labor rate may be proposed for each of the Support Service CLINs detailed in Section B of the solicitation. In other words, only one (1) direct labor rate may be proposed per labor category (LCAT), per year. In other words. The Prime Offeror and its subcontractor / interdivisional entity (S/IE’s) may not propose direct labor rates for the same LCAT. If the Prime Offeror chooses to propose its own direct labor rates for a particular LCAT, then it must do so for the entire 5-year POP, and it may not propose any S/IE rates for that particular LCAT. However, if the Prime Offeror chooses to propose an S/IE’s rates for a particular LCAT, then it must do so for the entire 5-year POP, and it may not propose its own rates or any other S/IE’s rates for that particular LCAT.”

Offers are to enter the appropriate values and information into those cells highlighted Light Blue.

“Total Price Summary” Tab:

1. This tab pulls the proposed direct labor rates and Fee/Profit values from the subsequent “Prime Offeror” and “S_IE” tabs and calculates the Total Proposed Price, see Section M-1-3.1 of the solicitation.

2. In the “Contractor” column of Table 1 (cells A3:I74), offeror’s shall enter the name of the Prime Offeror or S/IE that will be staffing the adjacent LCAT. Offerors may not enter information or dollar values into any other cells on this tab.

“Prime Offeror” Tab:

1. Table 2: Prime Offeror’s Direct Labor Rates - For all LCATs that it staffs, the Prime Offeror shall enter its proposed direct labor rates into Table 2 (cells B3:I75) on the “Prime Offeror” tab of this Cost Data Worksheet.

a. For each LCAT that the Prime Offeror staffs, five (5) direct labor rates shall be entered into the appropriate cells of Table 2 (columns “D” through “H”), one (1) for each year of the five (5) year POP.

b. If proposed direct labor rates are entered into Table 2 on the “Prime Offeror” tab, then proposed direct labor rates for the same LCAT may not be entered into the “S/IE Direct Labor Rates” tables on the subsequent “S_IE” tabs of this Cost Data Worksheet.

i. Example: The Prime Offeror intends to Staff the Program Manager (Low) LCAT. The Prime Offeror enters its proposed labor rates for the Program Manager LCAT into cells D6:H6, on the “Prime Offeror” tab. The Prime Offeror does not enter proposed S/IE direct labor rates for the Program Manager LCAT into cells D6:H6 of the subsequent “S_IE” tabs. The Prime Offeror’s S/IEs may not submit cost proposals directly to the Government in which they have proposed direct labor rates for the Program Manager (Low) LCAT.

image2.emf