Attachment L-09 - Cost and Price Sheet 23R5108 17JUL2023.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
Solicitation for Electronic Warfare Training Systems (EWTS) II
Solicitation number
N00024-23-R-5108
Issued by

About this file

Written by GovTribe AI ·

This document contains a cost and price sheet attachment for a solicitation seeking proposals for an Electronic Warfare Training Systems II contract. The Navy is soliciting proposals to provide engineering labor, materials, travel, storage, depot repair support, and production of BEWT II units over a five year period. Offerors must complete the cost and price sheet templates providing fully loaded rates for labor categories, unit pricing for different quantities of BEWT II production, and fixed prices for materials, travel, storage and a first article unit. Proposed pricing will be evaluated along with technical factors. The period of performance includes one base year and four option years, with a total estimated value of $5,375,000 over the five year term.

View the file

Other files

File Type Posted
Amendment 0002 Responses to Attachment L-02 Questions Comments and Data Request Form.xlsx XLSX spreadsheet
Conformed N00024-23-R-5108 through Amendment 0002.docx DOCX document
Attachment L-04 - Previous Contract Effort Narratives 23R5108 29AUG2023.docx DOCX document
RFP Amendment N00024-23-R-5108-0002.pdf PDF
RFP Amendment N00024-23-R-5108-0001.pdf PDF
Conformed N00024-23-R-5108 through Amendment 0001.docx DOCX document
Attachment L-08 - SAMPLE PROBLEMS 23R5108 _rev 1.docx DOCX document
Attachment L-03 - Past Performance Questionnaire 23R5108 03OCT2022.xlsx XLSX spreadsheet
Attachment L-05 - Facility Checklist 23R5108 .xlsx XLSX spreadsheet
Attachment J-01 - SEWTT Technical Information Package 23R5108 03OCT2022.docx DOCX document
Attachment J-04 - NULKA Technical Information Package 23R5108 03OCT2022.docx DOCX document
Attachment J-07 - Solicitation DD0254 23R5108 03OCT2022.pdf PDF
Attachment J-12 - Project Plan Template.docx DOCX document
Attachment J-08 - Consolidated GFP Attachment 03OCT2022.xlsx XLSX spreadsheet
Attachment J-06 - BEWT II FAT Procedure 23R5108.docx DOCX document
Attachment J-11 - IWS 1IT SEP Inclusion List 17NOV2022.docx DOCX document
Attachment L-07 - Pre-Award Accounting System Adequacy Checklist 23R5108 03OCT2022.docx DOCX document
Attachment L-08 - SAMPLE PROBLEMS 23R5108 (1).docx DOCX document
N00024-23-R-5108 BEWT-SEWTT DTD 27JULY23 CDRL Package.pdf PDF
Attachment J-09 - Key Personnel Requirements 23R5108 03OCT2022.docx DOCX document
Attachment J-00 - GFI List 23R5108 24JAN2023.xlsx XLSX spreadsheet
Attachment J-02 - BEWT II ProductionTechnical Information Package 23R5108 03OCT2022.docx DOCX document
Attachment L-06 - Employee Qualifications Form-23R5108 03OCT2022.xlsx XLSX spreadsheet
Attachment L-02 - Questions Comments and Data Request Form 23R5108 03OCT2022.xlsx XLSX spreadsheet
Attachment L-10 - Press Release EWTS II 23R5108 03OCT2022 (1).docx DOCX document
Attachment L-04 - Previous Contract Effort Narratives 23R5108 03OCT2022.docx DOCX document
Attachment J-03 - CIAT Technical Information Package 23R5108 03OCT2022.docx DOCX document
Attachment J-13 TSTC Teams Quick Reference Guide.docx DOCX document
Attachment J-10 - TRM Version 3.0_27MAR20.pdf PDF
N00024-23-R-5108 - FINAL.pdf PDF
Attachment L-01 - Cross Reference Matrix 23R5108 03OCT2022.xlsx XLSX spreadsheet
Attachment J-05 - BEWT ISEA SSA Support Technical Information Package 23R5108.docx DOCX document
Show all 32

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

Instructions To Offerors
Offerors shall complete Attachment L-09 Cost and Price Sheet, Tabs L1-L3 as part of proposal submission.

NOTE: YELLOW HIGHLIGHTED CELLS IN THIS WORKBOOK ARE PREPOPULATED BY THE GOVERNMENT AND SHALL NOT BE CHANGED.

Tab L-1: The Offeror's pricing in Tab L-2 shall directly correspond to Section B Note A Table B-1. In the event of any discrepency, Section B Note A Table B-1 will take precedents for X005 tab L-2.
Tab L-1: The Offeror's pricing for Items X001 and X007 are direct inputs from tab L-03.
Tab L-1: CLINs X003 and X004 are pre-populated with Government estimated cost and shall not deviate.
Tab L-1: CLINs X006 - The Offer shall propose Storage and Warehouse as FFP quantity one (1) for 1,000 Square Feet (Sq. Ft.) in column G.
Tab L-1: CLIN 0008 - The Offeror shall propose FAU as FFP quantity one (1) in column G, row 18.
Tab L-1: The Offeror will not be required to fill in prices in Table L-1 for CLIN X005. The price evaluation team will randomly choose a quantity from tabs L-2 Stepladder Pricing and insert that randomly choosen quantity in column C.

Tab L-2: The Offeror shall price the per unit price for X005 BEWT II in the Government provided Step Ladder quantities.

Tab L-3: The Offeror shall complete the Level-Of-Effort table tab L-03. The Offeror shall price the loaded hourly rate and fee percentage highlighted in blue.
For the purposes of populating Tab L-1, link the Composite Rates in Row 21 and 34 to the appropriate cells for CLINs X001 and X007, and the fee and cost amount of each CLIN year.

The term "loaded hourly rate" means the burdened labor cost for each full hourly cost, which included wages, fringe, and overhead.

The term "fully loaded hourly rate" means the fully-burdened labor cost for each full hourly cost, which includes wages, fringe, overhead and Profit/Fee.

L-1 Complete Section B

SOURCE SELECTION SENSITIVE

CLINDescriptionQTYEst CostFeeLoaded RateFFPTotal
0001Engineering/LOE35,573$ -$ -$ -$ -
0002CDRLs are Not-Separately Priced (NSP)
0003ODC/Material1$ 1,000,000.00$ 1,000,000.00
0004Travel1$ 75,000.00$ 75,000.00
0005BEWT II Production$ -$ -
0006Storage/Warehousing - Sqft (1,000 sqft)1$ -$ -
0007Depot Repair/ISEA-SSA Support3,840$ -$ -$ -$ -
0008First Article Unit (FAU) - BEWT II1$ -$ -
BASE$ 1,075,000.00
CLINDescriptionQTYEst CostFeeLoaded RateFFPTotal
1001Engineering/LOE35,573$ -$ -$ -$ -
1003ODC/Material1$ 1,000,000.00$ 1,000,000.00
1004Travel1$ 75,000.00$ 75,000.00
1005BEWT II Production$ -$ -
1006Storage/Warehousing - Sqft (1,000 sqft)1$ - 0$ -
1007Depot Repair/ISEA-SSA Support3,840$ -$ -$ -$ -
Opt 1$ 1,075,000.00
CLINDescriptionQTYEst CostFeeLoaded RateFFPTotal
2001Engineering/LOE35,573$ -$ -$ -$ -
2003ODC/Material1$ 1,000,000.00$ 1,000,000.00
2004Travel1$ 75,000.00$ 75,000.00
2005BEWT II Production$ -$ -
2006Storage/Warehousing - Sqft (1,000 sqft)1$ -$ -
2007Depot Repair/ISEA-SSA Support3,840$ -$ -$ -$ -
Opt 2$ 1,075,000.00
CLINDescriptionQTYEst CostFeeLoaded RateFFPTotal
3001Engineering/LOE35,573$ -$ -$ -$ -
3003ODC/Material1$ 1,000,000.00$ 1,000,000.00
3004Travel1$ 75,000.00$ 75,000.00
3005BEWT II Production$ -$ -
3006Storage/Warehousing - Sqft (1,000 sqft)1$ -$ -
3007Depot Repair/ISEA-SSA Support3,840$ -$ -$ -$ -
Opt 3$ 1,075,000.00
CLINDescriptionQTYEst CostFeeLoaded RateFFPTotal
4001Engineering/LOE35,573$ -$ -$ -$ -
4003ODC/Material1$ 1,000,000.00$ 1,000,000.00
4004Travel1$ 75,000.00$ 75,000.00
4005BEWT II Production$ - 0$ -
4006Storage/Warehousing - Sqft (1,000 sqft)1$ -$ -
4007Depot Repair/ISEA-SSA Support3,840$ -$ -$ -$ -
Opt 4$ 1,075,000.00
All Years$ 5,375,000.00
Eng. Labor$ -
ODC's$ 5,000,000.00
Travel$ 375,000.00
Production$ -
Storage$ -
Depot Repair$ -
FAU$ -
$ 5,375,000.00
Labor Hours197,065

L-2 BEWT II Production

BEWT II Production (CLINs 0005, 1005, 2005, 3005, 4005)

CLIN 0005CLIN 1005CLIN 2005CLIN 3005CLIN 4005
QtyUnit PriceQtyUnit PriceQtyUnit PriceQtyUnit PriceQtyUnit Price
1$1$1$1$1$
2$2$2$2$2$
3$3$3$3$3$
4$4$4$4$4$
5$5$5$5$5$

L-3 LOE CLINs

Position Description CLINs 0001, 1001, 2001, 3001, 4001Notional % Labor Mix Per YearNotional Labor Hours All YearsFully Loaded Cost Total0001 Base Yr Labor HoursKey Persons % of time on this contractBase Year Loaded Hourly Rate (w/out Fee)Base Year Fully Loaded Total1001 Opt Yr 1 Labor HoursKey Persons % of time on this contractOpt Yr 1 Loaded Hourly Rate (w/out Fee)Opt Yr 1 Fully Loaded Total2001 Opt Yr 2 Labor HoursKey Persons % of time on this contractOY 2 Rate Loaded Hourly (w/out Fee)Opt Yr 2 Fully Loaded Total3001 Opt Yr 3 Labor HoursKey Persons % of time on this contractOpt Yr 3 Loaded Hourly Rate (w/out Fee)Opt Yr 3 Fully Loaded Total4001 Opt Yr 4 Labor HoursKey Persons % of time on this contractOpt Yr 4 Loaded Hourly Rate (w/out Fee)Opt Yr 4 Fully Loaded Total
Base Year Fully Loaded Rate (w/Fee)Opt Yr 1 Fully Loaded Rate (w/Fee)Opt Yr 2 Fully Loaded Rate (w/Fee)Opt Yr 3 Fully Loaded Rate (w/Fee)Opt Yr 4 Fully Loaded Rate (w/Fee)
Program Manager/Senior Engineer - EE/ME/CE (Key Personnel)5.4%9,6009,600- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Assistant PM/Senior Engineer - EE/ME (Key Personnel)5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Senior Engineer - EE/ME5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Mid-Level Engineer - EE/ME5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Project Engineer - EE/ME5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Hardware Designer/Senior Technician5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Senior Software Designer5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Senior Software Engineer (Key Personnel)5.4%9,6000- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Software Developer21.6%38,4000- 07,680$ - 0$ - 0$ - 07,680$ - 0$ - 0$ - 07,680$ - 0$ - 0$ - 07,680$ - 0$ - 0$ - 07,680$ - 0$ - 0$ - 0
Senior Project Analyst10.9%19,4650- 03,893$ - 0$ - 0$ - 03,893$ - 0$ - 0$ - 03,893$ - 0$ - 0$ - 03,893$ - 0$ - 0$ - 03,893$ - 0$ - 0$ - 0
Project Analyst8.1%14,4000- 02,880$ - 0$ - 0$ - 02,880$ - 0$ - 0$ - 02,880$ - 0$ - 0$ - 02,880$ - 0$ - 0$ - 02,880$ - 0$ - 0$ - 0
Test & Certification/QA Specialist10.8%19,2000- 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 0
Technical Writer5.4%9,600- 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 01,920$ - 0$ - 0$ - 0
Total100.0%177,8650.0035,5730.0035,5730.0035,5730.0035,5730.0035,5730.00
Key PersonnelComposite Rate All YearsComposite Rate All YearsComposite Rate Base YearComposite Rate Opt Year 1Composite Rate Opt Year 2Composite Rate Opt Year 3Composite Rate Opt Year 4
Program Manager/Senior Engineer - (Key Personnel)
Assistant PM/Senior Engineer - (Key Personnel)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Software Engineer - (Key Personnel)
Fee %:0.00%$ - 0Fee %:0.00%$ - 0Fee %:0.00%$ - 0Fee %:0.00%$ - 0Fee %:0.00%$ - 0
Cost:$ - 0Cost:$ - 0Cost:$ - 0Cost:$ - 0Cost:$ - 0
Total Cost + Fee$ - 0Total Cost + Fee$ - 0Total Cost + Fee$ - 0Total Cost + Fee$ - 0Total Cost + Fee$ - 0
Position Description CLINs 0007, 1007, 2007, 3007, 4007Notional % Labor Mix Per YearNotional Labor Hours All YearsFully Loaded Cost Total0001 Base Yr Labor HoursKey Persons % of time on this contractBase Year Loaded Hourly Rate (w/out Fee)Base Year Fully Loaded Rate (w/Fee)Base Yr Fully Loaded Total1001 Opt Yr 1 Labor HoursKey Persons % of time on this contractOpt Yr 1 Loaded Hourly Rate (w/out Fee)Opt Yr 1 Fully Loaded Total2001 Opt Yr 2 Labor HoursKey Persons % of time on this contractOpt Yr 2 Loaded Hourly Rate (w/out Fee)Opt Yr 2 Fully Loaded Total3001 Opt Yr 3 Labor HoursKey Persons % of time on this contractOpt Yr 3 Loaded Hourly Rate (w/out Fee)Opt Yr 3 Fully Loaded Total4001 Opt Yr 4 Labor HoursKey Persons % of time on this contractOpt Yr 4 Loaded Hourly Rate (w/out Fee)Opt Yr 4 Fully Loaded Total
Opt Yr 1 Fully Loaded Rate (w/Fee)Opt Yr 2 Fully Loaded Hourly Rate (w/Fee)Opt Yr 3 Fully Loaded Hourly Rate (w/Fee)Opt Yr 4 Fully Loaded Hourly Rate (w/Fee)
Project Analyst100.0%19,2000$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 03,840$ - 0$ - 0$ - 0

Composite Rate All Years Composite Rate Base Year Composite Rate Opt Year 1 Composite Rate Opt Year 2 Composite Rate Opt Year 3 Composite Rate Opt Year 4

$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Fee %:0.00%$ - 0Fee %:0.00%$ - 0Fee %:0.00%$ - 0Fee %:0.00%$ - 0Fee %:0.00%$ - 0
Cost:$ - 0Cost:$ - 0Cost:$ - 0Cost:$ - 0Cost:$ - 0
Total Cost + Fee$ - 0Total Cost + Fee$ - 0Total Cost + Fee$ - 0Total Cost + Fee$ - 0Total Cost + Fee$ - 0

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