CSEA_Cost_Table_(Section_L,_Appendix_5)_-_Amend_2.xlsx

150 KB Posted

Attached to
Request for Proposal: Ship Self Defense System Combat System Engineering Agent (CSEA) / Software Design Agent (SDA)
Solicitation number
N00024-17-R-5152
Issued by

About this file

From the source

CSEA Cost Table (Section L, Appendix 5)

View the file

Other files

File Type Posted
N00024-17-R-5152-0004_Conformed.pdf PDF
Proposal_Delivery_Information.pdf PDF
Track_Changes_-_Amendment_003.pdf PDF
Amendment_003_Final.pdf PDF
N00024-17-R-5152_-_CSEA_Offeror_Questions_11-21-17.pdf PDF
N00024-17-R-5152_-CSEA_Responses_to_Industry_Questions__06OCT.pdf PDF
N00024-17-R-5152_Conformed_per_Amendment_0002.pdf PDF
N00024-17-R-5152_Mod_Summary_of_Change_Document_Per_Amendment_0002.pdf PDF
J-24_-_SLOC_Table_Amend_2.xlsx XLSX spreadsheet
J-01_CSDR_Plan_(Software_Development)_SIGNED_Amend_2.pdf PDF
J-08_-_GFI_-_Amend_2.xlsx XLSX spreadsheet
J-24_-_SLOC_Table_Amend_1.xlsx XLSX spreadsheet
N00024-17-R-5152_-_CSEA_Offeror_Questions_8_30_17.pdf PDF
N00024-17-R-5152-0001_Mod_Summary_of_Changes.pdf PDF
J-08_-_GFI_-_2017_-_Amend_1.xlsx XLSX spreadsheet
CSEA_Cost_Table_(Section_L,_Appendix_5)_-_Amend_1.xlsx XLSX spreadsheet
N00024-17-R-5152-0001.pdf PDF
Exhibit_A-_DD-143_-_Amend_1.pdf PDF
N00024-17-P-5152_Section_J__zip_.zip ZIP file
N00024-17-R-5152_Section_L_Attachments_.zip ZIP file
N00024-17-R-5152-_SSDS_CSEA.pdf PDF
N00024-17-R-5152-Question_and_Comment.xlsx XLSX spreadsheet
Show all 22

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

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

Instructions

Section L-Appendix 5: 4.6.3: Cost Table - Instructions to Offeror

The Offeror shall populate the all tabs with this spreadsheet, L-G through L-M, in accordance with instructions stated under Section L of solicitation N00024-17-R-5152. A brief description of each tab is described below. Additional instructions pertinent to each worksheet are provided in the respective tab.

Worksheet L-G:
The Offeror shall summarize the entirety of the proposed costs in this worksheet. All cells shall be linked across the other worksheets. CLINs 1000-1003 shall be linked to worksheet L-H. CLINs 0010-0059 and CLINs 1010-1090 shall be linked to worksheets from the template provided in L-J. CLINs 0060-0079 can be a direct entry into this worksheet in accordance with Section B of the contract.
Worksheet L-H
The cost summaries shall show the proposed direct labor hours and costs (by labor category), all indirect costs, unburdened direct material (i.e., subcontractor or material costs), the Offeror’s subcontractor pass through costs, and fee by CLIN, and further delineated by Calendar Year. All cells shall be linked to input provided in worksheet L-I.
Worksheet L-I
The offeror shall segregate its proposed hours and costs to a minimum third digit WBS element (e.g., WBS 1.2.3, Detailed Design) in accordance with the WBS structure provided under Section J, Attachment 01 "CSDR Plan." Where additional levels of WBS are required to distinguish direct costs, the Contractor shall implement additional lower levels and provide detailed titles of the lower level work packages.
Worksheet L-J
The purpose of this worksheet is for the Offeror to map the proposed hours to the Government labor mix and Government labor categories for both Engineering Service LOE CLINs 0010-0059, as well as the labor mix proposed for completion CLINs 1000, 1001, 1002, 1003, and 1003.

- CLINs 0010-0059: this worksheet will be used as verification that the Offeror proposed in accordance with the Government recommended labor mix provided in Section L.

- CLINs 1000-1003: this worksheet will provide the Offerors proposed labor mix for completion CLINs mapped to the Government labor matrix by calendar year.

- CLINs 1000 and 1001: this worksheet will be used accordance with Section L and furthers detailed explanation in Tab L-J to calculate the labor mix for CLINs 1010-1090.

Worksheet L-K:
The purpose of this worksheet is to matrix the Offeror's unique labor categories to the Government's estimated labor categories. The Offeror shall populate this spreadsheet for each CLIN as required by worksheet L-N "Matrix Instructions." The Offeror shall only utilize the Government Labor Categories as provided in Section L - Appendix 2 of the solicitation. The Offeror may expand the lines within the workbook as required, but shall not add new labor categories or amend the structure of the labor mix. For CLINs 0010-0059, the total proposed hours shall align with each CLIN as prescribed in Section B of the contract and shall include all prime and subcontractor hours.
Worksheet L-L
The Offeror shall populate the rates table with their unique cost element codes and rates for all years, CY2019 through CY2028. This table shall be used for all direct and indirect rates, and be linked to all calculations throughout the workbook. Indirect factors must be in the billionths and direct labor rates must be to the hundredths. The Offeror shall also populate Government to Contractor Labor Matrix, providing a clear mapping of Offeror's Labor Categories to the Government Labor Categories. Additionally, the Offeror shall populate the Contract Fee table which shall be linked to all calculations of fee throughout the workbook, aligning with Offerors Section B pricing.
Worksheet L-M
The purpose of this worksheet is to provide a composite view of all costs by CLIN through FCCM for the ten year period of the contract.
Worksheet L-N
The purpose of this worksheet is to identify to the Offeror which worksheets are required to be filled out for each CLIN.
WBS
The Below WBS shall be utilized across all spreadsheets that require WBS input. The Offeror shall utilize only the elements with proposed hours or costs against it. Per the instructions provided in Section L of the solicitation, lower level WBS elements shall be utilized as required to identify additional lower levels of work scope to be managed by the Offeror. The Offeror shall insert into the chart below all lower level WBS elements to include a detailed WBS description.
WBS NumberWBS Description
1.01.0SSDS CSEA
1.11.1SSDS SW Capability Builds
1.1.11.1.1PMP Subsystem Hardware
1.1.21.1.2Capability Build Software Release
1.1.21.1.2.1Software Product Engineering
1.1.21.1.2.2Computer Software Configuration Item (CSCI) Subsystem Software
1.1.21.1.2.2.1Enterprise Air Surveillance Radar (EASR)
1.1.21.1.2.2.1.1SW Development Testing Validation
1.1.21.1.2.2.1.2Training Software Development
1.1.21.1.2.2.2Evolved Sea Sparrow Missile (ESSM) Block 2
1.1.21.1.2.2.2.1SW Development Testing Validation
1.1.21.1.2.2.2.2Training Software Development
1.1.21.1.2.2.3Surface Electronic Warfare Improvement Program (SEWIP) Block 3
1.1.21.1.2.2.3.1SW Development Testing Validation
1.1.21.1.2.2.3.2Training Software Development
1.1.21.1.2.2.4Cybersecurity
1.1.21.1.2.2.5Reserved- Future ECP Capabilities
1.1.21.1.2.2.5.1SW Development Testing Validation
1.1.21.1.2.2.5.2Training Software Development
1.1.21.1.2.3Capability Build Subsystem Hardware
1.1.21.1.2.4Subsystem Integration, Assembly, Test and Checkout
1.1.31.1.3PMP Integration, Assembly, Test and Checkout
1.21.2SSDS - Platform Integration, Assembly, Test and Checkout
1.2.11.2.1Hardware Technical Integration
1.2.11.2.1.1HTI 12
1.2.11.2.1.2HTI 12H
1.2.11.2.1.3HTI 16
1.2.11.2.1.4HTI 16TR
1.2.11.2.1.5Reserved- HTI-Next
1.2.21.2.2Software Migration
1.2.21.2.2.1HTI 12
1.2.21.2.2.2HTI 12H
1.2.21.2.2.3HTI 16
1.2.21.2.2.4HTI 16TR
1.2.21.2.2.5Reserved- HTI-Next
1.31.3System Engineering
1.31.3.1Software Systems Engineering
1.31.3.1.1Non-Integrated Product Support (IPS) SE
1.31.3.1.1.1Hardware
1.31.3.1.1.2Software
1.31.3.1.1.3Common
1.31.3.1.2IPS SE
1.31.3.1.3Configuration Management
1.31.3.1.4Software Development
1.31.3.1.5Preliminary Systems Engineering
1.31.3.1.6Critical Experiments/ Studies
1.41.4Program Management
1.41.4.1Non-IPS PM
1.41.4.1.1Hardware
1.41.4.1.2Software
1.41.4.1.3Common
1.41.4.2IPS PM
1.41.4.3Configuration Management
1.41.4.4Software Program Management
1.41.4.5Other Program Management
1.51.5System Test and Evaluation
1.61.6Training
1.61.6.1Equipment
1.61.6.2Services
1.61.6.3Training Materials
1.61.6.4Facilities
1.71.7Data
1.71.7.1Data Rights
1.71.7.2Technical Publications
1.71.7.3Engineering Data
1.71.7.4Management Data
1.71.7.5Support Data
1.71.7.6Data Depository
1.81.8Peculiar Support Equipment
1.91.9Common Support Equipment
1.101.10Site Activation (Contract Start-up/ Transition)
1.111.11Industrial Facilities
1.121.12Initial Spares and Repair Parts

L-G

SSDS SECTION L COST TABLE ATTACHMENT G

Cost Summary Table By CLIN/SLIN
TypeCompletionLOE Place Holder (Intent to Convert to Completion)Level of Effort
Major Cost ElementCLIN 1000CLIN 1001CLIN 1002CLIN 1003CLIN 1010CLIN 1020CLIN 1030CLIN 1040CLIN 1050CLIN 1060CLIN 1070CLIN 1080CLIN 1090CLIN 0010CLIN 0011CLIN 0012CLIN 0013CLIN 0014CLIN 0015CLIN 0016CLIN 0016CLIN 0017CLIN 0018CLIN 0019CLIN 0020CLIN 0021CLIN 0022CLIN 0023CLIN 0024CLIN 0025CLIN 0026CLIN 0027CLIN 0028CLIN 0029CLIN 0030CLIN 0031CLIN 0032CLIN 0033CLIN 0034CLIN 0035CLIN 0036CLIN 0037CLIN 0038CLIN 0039CLIN 0040CLIN 0041CLIN 0042CLIN 0043CLIN 0044
Purchase Parts ($)
Material Overhead ($)
Major Subcontracts ($)
Other Subcontracts ($)
Interorganizational Transfer ($) (NO FEE)
Total Material ($)
Direct Program Management Labor (Hours)
Direct Program Management Labor ($)
Program Management Overhead ($)
Total Program Management ($)
Direct Engineering Labor (Hours)
Direct Engineering Labor ($)
Engineering Overhead ($)
Total Engineering ($)
Direct Manufacturing Labor (Hours)
Direct Manufacturing Labor ($)
Manufacturing Overhead ($)
Total Manufacturing ($)

Subtotal Labor ($)

Other Direct Costs ($)

Subtotal Material, Labor, and ODC ($)

G&A Expense ($)
Subtotal Costs ($)
Facilities Capital Cost of Money (FCCM) ($)
Total Estimated Cost ($)
Fee/Profit ($)
Max Fee (CPIF CLINs Only)
Min Fee (CPIF CLINs Only)
Share Ratios (CPIF CLINs Only)
Overrun (Government / Contractor)
Underrun (Government/Contractor)
Fee/Profit (%)
CLIN Type
TOTAL ($)
Ceiling Price
- Provide all inputs for each CLIN, specified on Form L-N "Matrix Instructions."
- All cost values shall be rounded to whole dollars.
* Offeror shall provide/insert for each SLIN. Under CLIN 0002, Offeror shall include a SLIN Column for each Enhanced Data Rights Item priced option offered in Section B.

SSDS SECTION L COST TABLE ATTACHMENT G

L-H

SSDS CSEA SECTION L COST TABLE ATTACHMENT H

Cost Summary Detail for CLIN/SLIN **** entitled *****

Major Cost ElementWBSBOE IDCY 19CY 20CY 21CY 22CY 23
Hours / CostRateSubtotal $Hours/CostRateSubtotal $Hours/CostRateSubtotal $Hours/CostRateSubtotal $Hours/CostRateSubtotal $
(See Tab "Instructions" For WBS Structure Applicability)
Material Non-Recurring
Purchase Parts
Material Overhead ($)
Major Subs
*
*
Other Subs
Cross Organizational Transfer
Total Material Non-Recurring
Material Recurring
Purchase Parts
Material Overhead ($)
Major Subs
*
*
Other Subs
Cross Organizational Transfer
Total Material Recurring
Labor Non-Recurring
Program Management
Category/Personnel
*
*
*
Program Management Indirect Rates
*
*
*
Engineering
Category/Personnel
*
*
*
Engineering Indirect Rates
*
*
*
Manufacturing
Category/Personnel
*
*
*
Manufacturing Indirect Rates
*
*
*
Total Labor Non-Recurring
Labor Recurring
Program Management
Category/Personnel
*
*
*
Program Management Indirect Rates
*
*
*
Engineering
Category/Personnel
*
*
*
Engineering Indirect Rates
*
*
*
Manufacturing
Category/Personnel
*
*
*
Manufacturing Indirect Rates
*
*
*
Total Labor Recurring
Other Direct Costs Non-Recurring
Type
*
*
Total Other Direct Costs Non-Recurring
Other Direct Costs Recurring
Type
*
*
Total Other Direct Costs Recurring

SUBTOTAL COSTS ($)

G&A Expense ($)
Type
*
*

SUBTOTAL COSTS ($)

Facilities Capital Cost of Money (FCCM) ($)
Type
*
*

TOTAL ESTIMATED COSTS ($)

Fee/Profit ($)
Fee/Profit (%)
TOTAL ($)
- Prepare one of these forms for each CLIN/SLIN for all Calendar Years as specified in Worksheet L-N "Matrix Instructions."
- Round cost values to whole dollars.
- Link values on this form with values/equations on other forms Do not just paste values where value can be linked to another form.
- Sub totals must calculate within this form and not be linked to other forms
- Link each cell containing the NRE/RE Material Costs, Major Sub-Contractor Costs, Other Sub-Contractors Costs, Cross Organizational Transfer Costs, Labor Category Costs (number of hours), and Other Direct Costs with the unburdened values in Form L-I . Link each cell containing rates to appropriate cells in Form L-L.
- Calculations with rates computed on this form shall link to rates from Form L-L and material and labor costs from Form L-J.
- Cost basis for application of Material Overhead, Indirect Labor Rates, G&A and FCCM must link to value(s) contained in Form L-H, not Form L-J.
- For CLIN/SLINs which do not have a required Form L-I or L-J, contractor shall enter costs directly onto this form.
- Categories provided are for example only. The Offeror shall link categories to actual categories listed on Form L-L.
- All values shall be bid in accordance with Offeror's Accounting System Disclosure Statement (OH, Fringe, etc.)

SSDS CSEA SECTION L COST TABLE ATTACHMENT H

Update Fee if necessary

L-I

SSDS CSEA SECTION L COST TABLE ATTACHMENT I

Cost Summary Table by Contract WBS for CLIN/SLIN **** entitled *****

CLIN TotalCY19CY20
WBSBOE IDCLINDescriptionCost ElementHoursDirect LaborFringeOverheadSubcontractorSubK OverheadMaterialMaterial OverheadG&AFCCMTotal CostsTarget Fee (Completion)Min FeeMax FeeTotal FeeTotal Price (Cost Plus Target Fee)Cost ElementHoursDirect LaborFringeOverheadSubcontractorSubK OverheadMaterialMaterial OverheadG&AFCCMTotal CostsTarget Fee (Completion)Min FeeMax FeeTotal FeeTotal Price (Cost Plus Target Fee)Cost ElementHoursDirect LaborFringeOverheadSubcontractorSubK OverheadMaterialMaterial OverheadG&AFCCMTotal Costs
Line Item
(See Tab "Instructions" For WBS Structure Applicability).

Totals

- Prepare one of these forms for each CLIN as specified on Form L-N "Matrix Instructions."
- Round cost values to whole dollars.
- Total values shall be computed in the form.
- Cells containing the Material Costs, Major Sub-Contractor Costs, Other Sub-Contractors Costs, Inter-Organizational Transfer Costs, Labor Category Costs (number of hours), and Other Direct Costs in this form are Industry Inputs.
- Link each cell containing rates to appropriate cells in Form L-L. Displayed rate shall include all direct and indirect rates.
- Provide equations for Total Cost computation. Costs shall be through FCCM.
- The Offeror shall add additional columns for additional labor, material, sub-contractor, and indirect costs as required.
- The formulas in this form shall compute the appropriate parent/child cost roll up relationships.
- If the Offeror further defines the WBS Structure to lower level work structures, Offeror shall include that those lines and clear description of the lower level WBS element in the appropriate columns.

SSDS CSEA SECTION L COST TABLE ATTACHMENT I

L-J

SSDS CSEA SECTION L COST TABLE ATTACHMENT J
Additional Instructions for LOE Engineering Services Labor Rate Tables and LOE Placeholders for Out-Year Completion CLIN Conversion Place Holders
Cost Summary Detail for CLIN/SLIN **** entitled *****
1CLINs 0010-0059 Major Cost Element Table: The Contractor shall provide all cost elements, the proposed hours, and the proposed direct and indirect rates (linked to tab L-L) for LOE CLINs 0010-0059. CLINs 0010-0059 shall align with the Government recommended labor mix provided by the Government in Section L Appendix 2. The Offeror can tailor the spreadsheet to identifiy additionl cost elements to align with their BOEs and WBS.
Major Cost ElementCLIN XXXX - CY XX
HoursRateSubtotal $
** See Additional Instructions 1 & 2 **2CLINs 1000, 1001, 1002, and 1003 Major Cost Element Table: The Contractor shall provide all Major cost elements by description, the proposed hours, and proposed direct and indirect rates (linked to tab L-L). CLINs 1000, 1001, 1002, and 1003 shall include columns for each Calendar Year, in accordance with Section F of the solicitation.
Labor3CLIN 0010-0059 and CLINs 1000, 1001, 1002, and 1003 - Labor Category Allocation Table: The Contractor shall directly convert all Proposed Major Cost Elements Labor Hours into the Labor Category Allocation table utilizing the Government to Contractor Labor Matrix filled out in Tab L-L.

- For CLIN 0010-0059, this table shall verify the labor mix aligns with the Government Recommended Labor Mix.

- For CLINs 1000, 1001, 1002, 1003; the table shall include columns for each Calendar Year, in accordance with Section F of the solicitation.

Program Management
Category/Personnel
*
*4Labor Totals: Roll Up for CLINs 0010-0059: the Offeror shall compute the composite labor rates for all CLINs 0010-0059. The composite rates shall be calculated using linked cells across the excel workbook.

- "Composite Rate at Cost Through FCCM" shall be a direct calculation of "Total Target Cost" divided by "Total Labor (Hours)."

- "FCCM" shall be directly linked to the Major Cost Element Table.

- "Composite Rate With Fee" shall be a direct calculation of "Total Target Cost Plus Target Fee" by "Total Labor (Hours)," decimals shall be rounded at the hundredth position.

*
Program Management Indirect Rates
*
*
*5Out Year Labor Category Allocation Table: The Offeror shall populate the below tables for both CLIN 1000 and CLIN 1001 which include all proposed hours matrixed to the Government Labor Categories. A weighted average will be calculate for CLIN 1000 and CLIN 1001 setting the labor mix for CLINs 1010-1090 Out Year LOE Placeholders. A Labor Mix will be calculated based on a weighted average of the Offeror's proposal for CLIN 1000 and CLIN 1001. This calculated Labor Mix will be the basis of pricing for CLIN 1010-1090.
Engineering
Category/Personnel
*
*
*
G&A Expense ($)6Out Year Labor Hours Pricing: The Offeror shall price the calculated Labor Mix for each Out Year LOE Placeholder CLIN (Columns P - AG).

- The Offeror shall use the labor mix as provided calculated and shall not adjust the calculated labor mix under any circumstances.

- The Offeror shall use the Tab L-N "Matrix Instructions" and provide to the Government all required pricing sheets for CLINs 1010-1090.

- The Offeror shall calculate the priced labor rates for each labor category using the fee structure proposed by the Offeror for CLIN 1000.

- The Offerors priced labor mix for CLINs 1010-1090 will be codified as an attachment to the contract and, by utilizing the process provided under H-30 'Government Intent to Convert LOE," may be converted to completion tasking at a future date.

- For the purposes of pricing in Section B for CLINs 1010-1090, a weighted average calculation of the Offerors priced labor mix shall be used for Section B pricing, see Section B, Note D.

SUBTOTAL COSTS ($)

Facilities Capital Cost of Money (FCCM) ($)
TOTAL ESTIMATED COSTS ($)
Fee ($)
Fee (%)
TOTAL ESTIMATED PRICE USING TARGET FEE**The below number are provided for example purposes only to illustrate the calculation of the CLIN 1010-1090 Labor Mix **
** Shall be bid in accordance with Offeror's Accounting System Disclosure Statement (OH, Fringe, etc.)CLIN 1000 and 1001 Weighted Average Labor Mix for CLIN 1010-1090
** See Additional Instruction 5 **
Labor Category Allocation TableCLIN XX XX- CY XXLabor CategoryCLINs 1000Total
Hours% of Total HoursCY 19CY 20CY 21CY 22CY 23
** See Additional Instruction 3 **Senior Engineer6694,8968,7568,1321,23523,688
Senior EngineerMid-Level Engineer5645218956348
Mid-Level EngineerJunior Engineer8546874122321,582
Junior EngineerSenior Logistics Personnel5445464432151,199
Senior Logistics PersonnelMid-Level Logistics Personnel4,5635,4566,8439,5441,12327,529** CLINs 1010-1090: Out Year Place Holder Labor Hours See Instruction 6 **
Mid-Level Logistics PersonnelJunior Logistics Personnel845463694634561,918Composite Labor Mix - 1000 and 1001CLIN 1010 - Calendar Year 2020CLIN 1020 - Calendar Year 2021CLIN 1030 - Calendar Year 2022CLIN 1040 - Calendar Year 2023CLIN 1050- Calendar Year 2024CLIN 1060 - Calendar Year 2025CLIN 1070 - Calendar Year 2026CLIN 1080 - Calendar Year 2027CLIN 1090 - Calendar Year 2028
Junior Logistics PersonnelSenior Budget/Financial Personnel1,5849,8415,4631,2364,55422,678Labor CategoryPercent of MixLOE Placeholder Hours68,318LOE Placeholder Hours57,389LOE Placeholder Hours92,194LOE Placeholder Hours154,902LOE Placeholder Hours210,824LOE Placeholder Hours238,747LOE Placeholder Hours239,018LOE Placeholder Hours241,200LOE Placeholder Hours119,677
Senior Budget/Financial PersonnelMid-Level Budget/Financial Personnel216585512188Senior Engineer20%139191169218783315594295348641486974914124383
Mid-Level Budget/Financial PersonnelJunior Budget/Financial Personnel366995655981,430Mid-Level Engineer1%8647261166196026673020302430511514
Junior Budget/Financial PersonnelSenior Administrative Personnel2,2358774123452,564Junior Engineer2%10398731403235732073632363636701821
Senior Administrative PersonnelMid-Level Administrative Personnel2523211233265793Senior Logistics Personnel1%7696461038174423742688269127161347
Mid-Level Administrative PersonnelJunior Administrative Personnel56516516135881,311Mid-Level Logistics Personnel24%162221362721891367815005956689567545727228417
Junior Administrative PersonnelTOTAL9,58523,44223,84420,0788,27985,228Junior Logistics Personnel3%227419103069515770187948795780293984
TOTALCLIN 1001Senior Budget/Financial Personnel29%199251673826889451786148869632697117034734904
CY 19CY 20CY 21CY 22CY 23TotalMid-Level Budget/Financial Personnel5%3586301248398130110651253112545126596281
Labor Totals - Roll UpCLIN XXXX - CY XXSenior Engineer6542874162Junior Budget/Financial Personnel3%216418182920490766787562757176403791
HoursRateSubtotal $Mid-Level Engineer44561186541,133Senior Administrative Personnel3%213817962886484865997473748175493746
** See Additional Instruction 4 **Junior Engineer512856532199Mid-Level Administrative Personnel2%11299481523255934833944394939851977
Total Labor (Hours)Senior Logistics Personnel681891212119Junior Administrative Personnel6%4288360257879723132331498615003151407512
Composite Rate at Cost Through FCCMMid-Level Logistics Personnel136894218267TOTAL100%Total68,318Total57,389Total92,194Total154,902Total210,824Total238,747Total239,018Total241,200Total119,677
Total CLIN FCCMJunior Logistics Personnel3543218411423211,979
Total Target Price using Target FeeSenior Budget/Financial Personnel1,2385,6511,1232,2211,23111,464Attachment J-05: Calendar Year Rate Sheets for Clause H-30
Composite Rate Without Fee (Includes FCCM)Mid-Level Budget/Financial Personnel1,1233,2131131,3511565,956CLIN 1010 - Calendar Year 2020CLIN 1020 - Calendar Year 2021CLIN 1030 - Calendar Year 2022CLIN 1040 - Calendar Year 2023CLIN 1050- Calendar Year 2024CLIN 1060 - Calendar Year 2025CLIN 1070 - Calendar Year 2026CLIN 1080 - Calendar Year 2027CLIN 1090 - Calendar Year 2028
Composite Rate With FeeJunior Budget/Financial Personnel1251561,6511232232,278Target Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per HourTarget Cost Per HourTarget Price Per Hour
Senior Administrative Personnel3002001002003001,100Senior EngineerPriced Labor sheet to become Attachment J-05 "Calendar Year Rate Sheets for H-30
Mid-Level Administrative Personnel1483645388741,141Mid-Level Engineer
- Prepare one of these forms for each CLIN as specified on Form L-N Instructions.Junior Administrative Personnel1,8961,5261,1355868946,037Junior Engineer
- See additional Instructions for Engineering Services Composite Labor Rate for CLINs 1010-1090 titled "CLIN 1000 and 1001 Weighted Average Labor Mix for CLIN 1010-1090."TOTAL5,46211,6015,2094,8544,70931,835Senior Logistics Personnel
- Round cost values to whole dollars, Round Rates to two decimal points and G&A and FCCM to three decimal points.Mid-Level Logistics Personnel
- Link values on this form with values and equations on other forms. Do not just paste values where values can be linked to another form.Junior Logistics Personnel
- Labor Categories provided in "CLIN 1000 and 1001 Weighted Average Labor Mix for CLIN 1010-1090" are for example purposes only.Senior Budget/Financial Personnel
- The Offeror shall matrix contractor unique labor categories to Government categories listed in Section L - Appendix 2.Mid-Level Budget/Financial Personnel
- Rate cells shall be linked to the rates Form L-L. Total values shall be computed in this form.Junior Budget/Financial Personnel
- Provide equations for Total Cost computation.Senior Administrative Personnel
Mid-Level Administrative Personnel
Junior Administrative Personnel
SSDS CSEA SECTION L COST TABLE ATTACHMENT J

L-K

SSDS CSEA SECTION L COST TABLE ATTACHMENT K
123
CLINBOE IDWBSGovernment CategoriesContractor Labor CategoriesTOTAL HOURS
1000TOTAL CLIN 1000
10001(See Tab "Instructions" For WBS Structure Applicability).Senior EngineerEng 110
10001Mid-Level EngineerEng 215
100023Junior EngineerEng 48
100034Senior Logistics PersonnelEng213
100023Mid-Level Logistics PersonnelSUB /Name/Labor Cat.12
1000Junior Logistics Personnel
1000Senior Budget/Financial Personnel
1000Senior Engineer
1000Junior Budget/Financial Personnel
1000Senior Administrative Personnel
1000Mid-Level Administrative Personnel
1000Junior Administrative Personnel
1001TOTAL CLIN 1001
1001Senior Engineer
1001Mid-Level Engineer
1001Junior Engineer
1001Senior Logistics Personnel
1001Mid-Level Logistics Personnel
1001Junior Logistics Personnel
1001Senior Budget/Financial Personnel
1001Mid-Level Budget/Financial Personnel
1001Junior Budget/Financial Personnel
1001Senior Administrative Personnel
1001Mid-Level Administrative Personnel
1001Junior Administrative Personnel
1002TOTAL CLIN 1002
1002Senior Engineer
1002Mid-Level Engineer
1002Junior Engineer
1002Senior Logistics Personnel
1002Mid-Level Logistics Personnel
1002Junior Logistics Personnel
1002Senior Budget/Financial Personnel
1002Mid-Level Budget/Financial Personnel
1002Junior Budget/Financial Personnel
1002Senior Administrative Personnel
1002Mid-Level Administrative Personnel
1002Junior Administrative Personnel
1003TOTAL CLIN 1003
1003
1003
1003
1003
1003
1003
1003
1003
TTLTOTAL CLINS 0010-0059
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTLTOTAL CLINS: (1010/1020/1030/1040/1050/1060/1070/1080/1090)
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
TTL
- Prepare one of these forms for each CLIN as specified on Form L-N Instructions.
- The purpose of this spreadsheet is to matrix the Offeror's Proposal by WBS to the unique labor category matrix filed out by the Contractor in L-L "Labor Matrix."
- The Government Labor Mix in this sheet is provided for example only. The Offeror shall use the Government Labor Categories as provided in Section L - Appendix 2.
- The Offeror shall expand the Government categories in Column D and populate Column E with its unique labor codes, as illustrated in the example from Rows 4-8.
- The Offeror shall identify all hours from subcontractors, providing the name of the subcontractor and applicable labor code.
- As subcontractor pricing information may be considered proprietary data, the Government understands that the data (hard copy and electronic) may be submitted under separate correspondence. This fact does not absolve the Offeror from identifying the Subcontractor labor category.
- It is critical to note that the subcontractor’s data is part of the Offeror’s complete proposal, and as such, the Offeror will be held responsible for its timely and complete delivery.
- The Offeror’s entire proposal will be considered late if subcontractor data is not received by the stated deadline.
SSDS CSEA SECTION L COST TABLE ATTACHMENT K

L-L

1234567891011
Cost Element2019202020212022202320242025202620272028
Eng 1$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00NOTE
Eng 2$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00
Eng 3$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00
Eng 4$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00$ 5.00Instructions: The Offeror shall fill this table in with its unique cost element codes and rates in accordance with the instructions set forth in Section L, "Substantiating Cost Narrative," of the solicitation.

- Indirect factors must be in the billionths and direct labor rates must be to the hundredths.

- In this NOTE column, please provide a brief description of the cost base each indirect rate is applied to (e.g., Fringe factor is applied to direct labor costs).

- Additionally, the Contractor shall populate the Government Labor Mix Matrix, aliging the Contrac tor FPRR or FPRA to the Government Labor Mix from Section L - Appendix 2. Table "CLINs 0010-0059 Specified Hours Table," is provided below for the Offeror to price CLIN 0010-0059. These hours shall be unsed for the pricing of CLINs 0010-0059. The Labor mix is a provided in Section L Appendix 2.

(….)
Fringe5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%
Overhead5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%
Material Overhead5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%
SubK Overhead5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%
G&A5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%
FCCM5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%5.000%
(…)
Government to Contractor Labor Matrix
Government Labor CategoriesContractor Labor Categories
Senior Engineer
Mid-Level Engineer
Junior Engineer
Senior Logistics Personnel
Mid-Level Logistics Personnel
Junior Logistics Personnel
Senior Budget/Financial Personnel
Mid-Level Budget/Financial Personnel
Junior Budget/Financial Personnel
Senior Administrative Personnel
Mid-Level Administrative Personnel
Junior Administrative Personnel
FeeCLIN 0010-0057CLIN 1000CLIN 1001CLIN 1002CLIN 1003CLINs 1010-1090
Target Fee (CPIF)0%0%0%0%0%0%
Share Ratio - Overrun0%0%0%0%0%0%
Share Ratio - Underrun0%0%0%0%0%0%
Min Target Fee0%0%0%0%0%0%
Max Target Fee0%0%0%0%0%0%
Total0.000%0.000%0%
CLINs 0010-0059 Specified Hours Table
CLINs 0010-0059 Total Hours 408,492CLIN 0010CLIN 0011CLIN 0012CLIN 0013CLIN 0014CLIN 0015CLIN 0016CLIN 0017CLIN 0018CLIN 0019CLIN 0020CLIN 0021CLIN 0022CLIN 0023CLIN 0024CLIN 0025CLIN 0026CLIN 0027CLIN 0028CLIN 0029CLIN 0030CLIN 0031CLIN 0032CLIN 0033CLIN 0034CLIN 0035CLIN 0036CLIN 0037CLIN 0038CLIN 0039CLIN 0040CLIN 0041CLIN 0042CLIN 0043CLIN 0044CLIN 0045CLIN 0046CLIN 0047CLIN 0048CLIN 0049CLIN 0050CLIN 0051CLIN 0052CLIN 0053CLIN 0054CLIN 0055
Labor CategoryTotal CLIN 0010-0059 Hours Allocation% of Total CLIN HoursTotal Hours per CLIN3,1684,0974,3713,8543,7393,6263,5173,7523,3093,20911,20722,15821,49219,66626,70419,24119,02118,44916,88219,6496,46613,37812,97615,73219,45614,80111,48411,13910,8049,8242,2414,0144,0234,1453,9604,2634,3284,3094,4431,9657761,6301,7031,4361,4311,332
Senior Engineer7352918.00%Senior Engineer5707387876946736536336755965782,0173,9883,8693,5404,8073,4633,4243,3213,0393,5371,1642,4082,3362,8323,5022,6642,0682,0061,9461,767404722723747713767779777800354140293307258258240
Mid-Level Engineer16993341.60%Mid-Level Engineer1,3181,7041,8181,6031,5551,5081,4631,5601,3761,3354,6629,2198,9418,18211,1098,0047,9137,6757,0238,1742,6905,5655,3986,5458,0946,1574,7774,6344,4944,0879321,6701,6741,7241,6471,7731,8001,7901,848817322679709598595553
Junior Engineer4493411.00%Junior Engineer3484514814244123993874133643531,2332,4372,3642,1632,9372,1172,0922,0291,8572,1617111,4721,4271,7312,1401,6281,2631,2251,1881,08124744244345643646947647448921685179187158157147
Senior Logistics Personnel6821816.70%Senior Logistics Personnel5296847306446256065876275535361,8723,7003,5893,2844,4603,2133,1773,0812,8183,2811,0802,2342,1672,6273,2492,4721,9181,8601,8041,641374670672692661712723720742328130272284240239222
Mid-Level Logistics Personnel00.00%Mid-Level Logistics Personnel- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Junior Logistics Personnel4983612.20%Junior Logistics Personnel3865005334704564424294584033911,3672,7032,6222,3993,2582,3472,3212,2512,0602,3987891,6321,5831,9192,3741,8061,4011,3591,3181,19927349049150648352052852654224095199208175175163
Senior Budget/Financial Personnel00.00%Senior Budget/Financial Personnel- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Mid-Level Budget/Financial Personnel8170.20%Mid-Level Budget/Financial Personnel789877787622454339533937373439132726313930232222204888899994233333
Junior Budget/Financial Personnel00.00%Junior Budget/Financial Personnel- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Administrative Personnel00.00%Senior Administrative Personnel- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Mid-Level Administrative Personnel00.00%Mid-Level Administrative Personnel- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Junior Administrative Personnel12250.30%Junior Administrative Personnel101213111111111110103466645980585755515919403947584434333229712121212131313136255444
TOTAL HOURS -

L-M

SSSD CSEA - SECTION L COST TABLE ATTACHMENT M

CY Cost Summary Detail for CLIN/SLIN **** entitled *****

CLINCY 19CY 20CY 21CY 22CY 23CY 24CY 25CY 26CY 27CY28Total $
CostCostCostCostCostCostCostCostCostCost
CLIN 0002
CLIN 0010
CLIN 0011
CLIN 0012
CLIN 0013
CLIN 0014
CLIN 0015
CLIN 0016
CLIN 0017
CLIN 0018
CLIN 0019
CLIN 0020
CLIN 0021
CLIN 0022
CLIN 0023
CLIN 0024
CLIN 0025
CLIN 0026
CLIN 0027
CLIN 0028
CLIN 0029
CLIN 0030
CLIN 0031
CLIN 0032
CLIN 0033
CLIN 0034
CLIN 0035
CLIN 0036
CLIN 0037
CLIN 0038
CLIN 0039
CLIN 0040
CLIN 0041
CLIN 0042
CLIN 0043
CLIN 0044
CLIN 0045
CLIN 0046
CLIN 0047
CLIN 0048
CLIN 0049
CLIN 0050
CLIN 0051
CLIN 0052
CLIN 0053
CLIN 0054
CLIN 0055
CLIN 0056
CLIN 0057
CLIN 0058
CLIN 0059
CLIN 0060
CLIN 0061
CLIN 0062
CLIN 0063
CLIN 0064
CLIN 0065
CLIN 0066
CLIN 0067
CLIN 0068
CLIN 0069
CLIN 0070
CLIN 0071
CLIN 0072
CLIN 0073
CLIN 0074
CLIN 0075
CLIN 0076
CLIN 0077
CLIN 0078
CLIN 0079
CLIN 1000
CLIN 1001
CLIN 1002
CLIN 1003
CLIN 1010
CLIN 1020
CLIN 1030
CLIN 1040
CLIN 1050
CLIN 1060
CLIN 1070
CLIN 1080
CLIN 1090

Total

- Prepare one of these forms as specified on Form L-N Instructions.
* CLIN 0002 - Offeror shall include a SLIN Row for each Enhanced Data Rights Item priced option offered in section B.
- Round cost values to whole dollars.
- The cells on this form do not need to be linked to any other form.
- Cost should be through FCCM

SSSD CSEA - SECTION L COST TABLE ATTACHMENT M

L-N Matrix Instructions

SSDS CSEA SECTION L COST TABLE ATTACHMENT N

CLINDescriptionForm L-GForm L-HForm L-IForm L-JForm L-KForm L-LForm L-M
CLIN summarySummary data including all CLINS
(Excluding Data CLIN 0001)XXX
0001Data
0002Option-Enhanced Data Rights **X
0010XX
0011XX
0012XX
0013XX
0014XX
0015XX
0016XX
0017XX
0018XX
0019XX
0020XX
0021XX
0022XX
0023XX
0024XX
0025XX
0026XX
0027XX
0028XX
0029XX
0030XX
0031XX
0032XX
0033XX
0034XX
0035XX
0036XX
0037XX
0038XX
0039XX
0040XX
0041XX
0042XX
0043XX
0044XX
0045XX
0046XX
0047XX
0048XX
0049XX
0050XX
0051XX
0052XX
0053XX
0054XX
0055XX
0056XX
0057XX
0058XX
0059XX
0060
0061
0062
0063
0064
0065
0066
0067
0068
0069
0070
0071
0072
0073
0074
0075
0076
0077
0078
0079
1000XXXX
1001XXXX
1002XXXX
1003XXXX
1010XXX
1020XXX
1030XXX
1040XXX
1050XXX
1060XXX
1070XXX
1080XXX
1090XXX

SSDS CSEA SECTION L COST TABLE ATTACHMENT N

Sheet1

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .