Attachment_13_-_Cost_and_Price_Evaluation_Submittal_Sheet.xls

XLS spreadsheet 147 KB Posted Jul 15, 2014

Attached to: COMPETITIVE SOLICITATION FOR THE BUILD TO PRINT PRODUCTION OF THE COMMON DISPLAY SYSTEM (CDS)
Solicitation number: N00024-14-R-5210
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Attachment 13 - Cost and Price Evaluation Submittal Sheets

View the file

Other files

File	Type	Posted
Government_Response_to_Industry_Bidder_Questions_-_Round_Two.pdf	PDF	Aug 1, 2014
Conformed_Copy_-_N00024-14-R-5210.pdf	PDF	Aug 1, 2014
Attachment_13_-_Cost_and_Price_Evaluation_Submittal_Sheet_(to_be_removed_upon_contract_award).xls	XLS spreadsheet	Aug 1, 2014
Attachment_11_-_Spares_and_Repairs_Pricing_List.xlsx	XLSX spreadsheet	Aug 1, 2014
Amendment_0002_-_N00024-14-R-5210.pdf	PDF	Aug 1, 2014
Government_Response_to_Industry_Bidder_Questions_FINAL.pdf	PDF	Jul 15, 2014
Attachment_11_-_Spares_and_Repairs_Pricing_List.pdf	PDF	Jul 15, 2014
N00024-14-R-5210-0001_7.15.14_(final).pdf	PDF	Jul 15, 2014
Attachment_1_-_DD_254.pdf	PDF	Jul 15, 2014
Attachment 1 - Contract Security Classification Specification DD254.PDF	PDF	Apr 29, 2014
Attachment 13 - Cost and Price Evaluation Submittal Sheet	—	Apr 29, 2014
Attachment 12 - Offeror Question and Answer sheet	—	Apr 29, 2014
N00024-14-R-5210.pdf	PDF	Apr 29, 2014
Attachment 10 - Government Furnished Information	—	Apr 29, 2014
Exhibit A Contract Data Requirements List	—	Apr 29, 2014
Attachment 11 - Spares and Repairs Pricing List.xlsx	XLSX spreadsheet	Apr 29, 2014

Show all 16

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.

Cover

Attachment 13: Cost and Price Evaluation Submittal Sheet

COMMON DISPLAY SYSTEM (CDS)

Solicitation: N00024-14-R-5210

Vol III, Sect 2.1 Price Summ

VOLUME III, SECTION 2.1

The following worksheets contain the format required for the cost and pricing summary.

CLINs

			Pricing					Cost
CLIN	Description	Units	QTY: 1	QTY: 2-17	QTY: 18-53	QTY: 54-250	Qty	Est. Cost	Fixed Fee	CPFF
0001	Variant A Display console w/Cem & Chair	Each
0002	Variant A Display Console Only w/Chair	Each
0003	Variant B Display Console w/ CEM and Chair	Each
0004	Variant B Display Console Only w/Chair	Each
0005	Remote CEM Kit w/ DCU (MCE)	Each
0006	Data Processing Cabinet (MCE)	Each
0007	Remote CEM Kit w/ DCU (ACE)	Each
0008	ACE Remote CEM (ARC)	Each
0009	Red Keyboard and Task Light	Each
0010	Right Joystick	Each
0011	Left Joystick	Each
0012	Far Left VAB Panel	Each
0013	Center Left VAB Panel	Each
0014	Far and Center Left VAB Panel	Each
0015	Far Right VAB Panel	Each
0016	Center Right VAB Panel	Each
0017	Far and Center Right VAB Panel	Each
0018	Solid State Disk Drive (300GB)	Each
0019	Reserved
0020	Hand Controller Unit	Each
0021	Spares and INCO	Each
0022	Engineering Studies	Hours					12000
0023	Incidental Materials and ODCs	Lot					$80,000
0024	Variant A Display Console w/CEM & Chair, w/o GFE	Each
0024AA	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)2.1
0024AB	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)3.0
0025	Variant B Display Console w/CEM and Chair w/o GFE	Each
0025AA	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)2.1
0025AB	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)3.0
0026	Remote CEM Kit w/ DCU (MCE) w/o GFE	Each
0026AA	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)2.1
0026AB	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)3.0
0027	Remote CEM Kit w/ DCU (ACE) w/o GFE	Each
0027AA	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)2.1
0027AB	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)3.0
1001	Variant A Display console w/Cem & Chair	Each
1002	Variant A Display Console Only w/Chair	Each
1003	Variant B Display Console w/ CEM and Chair	Each
1004	Variant B Display Console Only w/Chair	Each
1005	Remote CEM Kit w/ DCU (MCE)	Each
1006	Data Processing Cabinet (MCE)	Each
1007	Remote CEM Kit w/ DCU (ACE)	Each
1008	ACE Remote CEM (ARC)	Each
1009	Red Keyboard and Task Light	Each
1010	Right Joystick	Each
1011	Left Joystick	Each
1012	Far Left VAB Panel	Each
1013	Center Left VAB Panel	Each
1014	Far and Center Left VAB Panel	Each
1015	Far Right VAB Panel	Each
1016	Center Right VAB Panel	Each
1017	Far and Center Right VAB Panel	Each
1018	Solid State Disk Drive (300GB)	Each
1019	Reserved
1020	Hand Controller Unit	Each
1021	Spares and INCO	Each
1022	Engineering Studies	Hours					12000
1023	Incidental Materials and ODCs	Lot					$80,000
1024	Variant A Display Console w/ Cem & Chair, w/o GFE	Each
1024AA	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)2.1
1024AB	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)3.0
1025	Variant B Display Console w/ CEM and Chair w/o GFE	Each
1025AA	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)2.1
1025AB	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)3.0
1026	Remote CEM Kit w/ DCU (MCE) w/o GFE	Each
0026AA	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)2.1
0026AB	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)3.0
1027	Remote CEM Kit w/ DCU (ACE) w/o GFE	Each
0027AA	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)2.1
0027AB	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)3.0
2001	Variant A Display console w/Cem & Chair	Each
2002	Variant A Display Console Only w/Chair	Each
2003	Variant B Display Console w/ CEM and Chair	Each
2004	Variant B Display Console Only w/Chair	Each
2005	Remote CEM Kit w/ DCU (MCE)	Each
2006	Data Processing Cabinet (MCE)	Each
2007	Remote CEM Kit w/ DCU (ACE)	Each
2008	ACE Remote CEM (ARC)	Each
2009	Red Keyboard and Task Light	Each
2010	Right Joystick	Each
2011	Left Joystick	Each
2012	Far Left VAB Panel	Each
2013	Center Left VAB Panel	Each
2014	Far and Center Left VAB Panel	Each
2015	Far Right VAB Panel	Each
2016	Center Right VAB Panel	Each
2017	Far and Center Right VAB Panel	Each
2018	Solid State Disk Drive (300GB)	Each
2019	Reserved
2020	Hand Controller Unit	Each
2021	Spares and INCO	Each
2022	Engineering Studies	Hours					12000
2023	Incidental Materials and ODCs	Lot					$80,000
2024	Variant A Display Console w/ Cem & Chair, w/o GFE	Each
2024AA	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)2.1
2024AB	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)3.0
2025	Variant B Display Console w/ CEM and Chair w/o GFE	Each
2025AA	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)2.1
2025AB	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)3.0
2026	Remote CEM Kit w/ DCU (MCE) w/o GFE	Each
0026AA	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)2.1
0026AB	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)3.0
2027	Remote CEM Kit w/ DCU (ACE) w/o GFE	Each
0027AA	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)2.1
0027AB	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)3.0
3001	Variant A Display console w/Cem & Chair	Each
3002	Variant A Display Console Only w/Chair	Each
3003	Variant B Display Console w/ CEM and Chair	Each
3004	Variant B Display Console Only w/Chair	Each
3005	Remote CEM Kit w/ DCU (MCE)	Each
3006	Data Processing Cabinet (MCE)	Each
3007	Remote CEM Kit w/ DCU (ACE)	Each
3008	ACE Remote CEM (ARC)	Each
3009	Red Keyboard and Task Light	Each
3010	Right Joystick	Each
3011	Left Joystick	Each
3012	Far Left VAB Panel	Each
3013	Center Left VAB Panel	Each
3014	Far and Center Left VAB Panel	Each
3015	Far Right VAB Panel	Each
3016	Center Right VAB Panel	Each
3017	Far and Center Right VAB Panel	Each
3018	Solid State Disk Drive (300GB)	Each
3019	Reserved
3020	Hand Controller Unit	Each
3021	Spares and INCO	Each
3022	Engineering Studies	Hours					12000
3023	Incidental Materials and ODCs	Lot					$80,000
3024	Variant A Display Console w/ Cem & Chair, w/o GFE	Each
3024AA	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)2.1
3024AB	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)3.0
3025	Variant B Display Console w/ CEM and Chair w/o GFE	Each
3025AA	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)2.1
3025AB	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)3.0
3026	Remote CEM Kit w/ DCU (MCE) w/o GFE	Each
3026AA	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)2.1
3026AB	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)3.0
3027	Remote CEM Kit w/ DCU (ACE) w/o GFE	Each
3027AA	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)2.1
3027AB	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)3.0
4001	Variant A Display console w/Cem & Chair	Each
4002	Variant A Display Console Only w/Chair	Each
4003	Variant B Display Console w/ CEM and Chair	Each
4004	Variant B Display Console Only w/Chair	Each
4005	Remote CEM Kit w/ DCU (MCE)	Each
4006	Data Processing Cabinet (MCE)	Each
4007	Remote CEM Kit w/ DCU (ACE)	Each
4008	ACE Remote CEM (ARC)	Each
4009	Red Keyboard and Task Light	Each
4010	Right Joystick	Each
4011	Left Joystick	Each
4012	Far Left VAB Panel	Each
4013	Center Left VAB Panel	Each
4014	Far and Center Left VAB Panel	Each
4015	Far Right VAB Panel	Each
4016	Center Right VAB Panel	Each
4017	Far and Center Right VAB Panel	Each
4018	Solid State Disk Drive (300GB)	Each
4019	Reserved
4020	Hand Controller Unit	Each
4021	Spares and INCO	Each
4022	Engineering Studies	Hours					12000
4023	Incidental Materials and ODCs	Lot					$80,000
4024	Variant A Display Console w/ Cem & Chair, w/o GFE	Each
4024AA	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)2.1
4024AB	Variant A Display Console w/CEM & Chair, w/o GFE, CEM (v)3.0
4025	Variant B Display Console w/ CEM and Chair w/o GFE	Each
4025AA	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)2.1
4025AB	Variant B Display Console w/CEM and Chair w/o GFE, CEM (v)3.0
4026	Remote CEM Kit w/ DCU (MCE) w/o GFE	Each
4026AA	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)2.1
4026AB	Remote CEM Kit w/ DCU (MCE) w/o GFE, CEM (v)3.0
4027	Remote CEM Kit w/ DCU (ACE) w/o GFE	Each
4027AA	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)2.1
4027AB	Remote CEM Kit w/ DCU (ACE) w/o GFE, CEM (v)3.0
5001	Provisioning Item Order (PIO)	Each
5002	Test Equipment - Acceptance Test Equipment	Lot
5003	Data for Exhibit A	Lot
5004	Data for Exhibit B	Lot
5005	Data for Exhibit C	Lot
6001	First Article Requirements - Variant A Console w/ CEM	Each
6002	First Article Requirements - Variant A Console w/ RCEM (MCE)	Each
6003	First Article Requirements - Variant B Console w/ CEM	Each
6004	First Article Requirements - Variant B Console w/ ACE RCEM (ARC)	Each

Vol III, Sect 2.2.1 Supp Price

VOLUME III, SECTION 2.2.1

The following worksheet contains the format required for submitting supporting cost or pricing data.

Required Sources

Unburdened Cost

Burdened Cost

CDS P/N

Part Description

Mfg P/N

Mfg Cage

Mfg Name

Base Year

Option Year 1

Option Year 2

Option Year 3

Option Year 4

Base Year

Option Year 1

Option Year 2

Option Year 3

Option Year 4

A003850

2.5 mm Stereo Cable

117075-L01

0MJF9

Themis Computer

A003684

Cable, Storage Expansion, I2C Mini Firewire (W58)

116615-L01

0MJF9

Themis Computer

A003686

Cable, Storage Expansion, Power (W60)

116509-L01

0MJF9

Themis Computer

A003685

Cable, Storage Expansion, PCIe Mini SAS (W59)

116505-L01

0MJF9

Themis Computer

1010295

CEM (v)2.1 Processing System

514-100001-L01

0MJF9

Themis Computer

514-100001-L08

CEM (v)3.0 Processing System

514-100001-L08

0MJF9

Themis Computer

514-121112-L01

CEM (v)3.0 LCEM Storage Power/Reset Cable

514-121112-L01

0MJF9

Themis Computer

514-121113-L01

CEM (v)3.0 LCEM Storage I2C/Clk Cable

514-121113-L01

0MJF9

Themis Computer

514-116505-L01

CEM (v)3.0 LCEM Storage Mini-SAS Cable

514-116505-L01

0MJF9

Themis Computer

116201-L01

CEM Chassis

116201-L01

0MJF9

Themis Computer

514-116201-L03

CEM (v)3.0 System Chassis

514-116201-L03

0MJF9

Themis Computer

1010211

Isolator Mount

2100058-4

OLRN7

Shock Tech

1010280-2

Chair, CDS Console, Ultra Leather Plus Fabric

500-7QR-CDS-2

0W5E3

Stidd Systems, Inc.

1010295-6

AC Power Module CEM (v)2.1 and (v)3.0 Compatible

116282-L01

0MJF9

Themis Computer

1010291-1

Display Module (CCFL)

356-7036-501

1NSE4

Aydin Displays, Inc.

1010295-5

IO Module

116199-L01

0MJF9

Themis Computer

514-120821-L01

CEM (v)3.0 I/O Module

514-120821-L01

0MJF9

Themis Computer

1010295-4

CPU Module

116479-L01

0MJF9

Themis Computer

514-120823-L02

CEM (v)3.0 CPU Module

514-120823-L02

OMJF9

Themis Computer

1010295-3

Media Module

116200-L01

0MJF9

Themis Computer

514-121124-L01

CEM (v)3.0 Media Module

514-121124-L01

OMJF9

Themis Computer

1010295-2

Storage Expansion Module

116478-L01

0MJF9

Themis Computer

514-117815-L01

CEM (v)3.0 SFP Transceiver Module, MMF, 1000Base – SX 850NM

514-117815-L01

0MJF9

Themis Computer

1010397-1

Variable Action Button Panel, CDS Console

6171AA

41WH0

Daisy Data Displays Inc.

13253843-01

Display Module (LED)

353-7257 Rev 0

1NSE4

Aydin Displays, Inc.

8500997

Cabinet Assembly, Mission Critical Enclosure—Type 26 (125 VAC), Single Latch

7420700-106

O2769

Lockheed Martin

8477598

AC/DC CONVERTER

AQF-30S12C

42169

NORVELL ELECTRONICS INC.

8500954

DVI-D CONVERTER, TRANSMITTER

M1-201DA-T

59DB1

VITEX, LLC

8500950

CEM (v)2.1 RCEM Processing System

514-100001-L04

0MJF9

Themis Computer

514-100001-L08

CEM (v)3.0 Processing System

514-100001-L08

0MJF9

Themis Computer

8500955

CONVERTER, POWER, 4 CHANNEL CEM (v)2.1

514-117815-L01

0MJF9

Themis Computer

8521083

FIBER CONTROL RELAY , TRANSMITTER

CT-8001-7

1TGU2

LITEWAY INC

8500951

CEM System Chassis, RCEM (v)2.1 and (v)3.0

116201-L03

0MJF9

Themis Computer

8565149

DVI-D CONVERTER, RECEIVER

M1-201DA-R

59DB1

VITEX, LLC

8521085

REMOTE HUMAN MACHINE INTERFACE (RHMI)

514-117373-L02

0MJF9

Themis Computer

514-121251-L01

CEM (v)3.0 REMOTE HUMAN MACHINE INTERFACE (RHMI)

514-121251-L01

0MJF9

Themis Computer

8500966

AC Power Module, CEM (v)2.1 and (v)3.0

116282-L01

0MJF9

Themis Computer

8565154

160GB 2 .5" SATA 3 GB/ S 25 NM MLC SSD

SSDSC2BB160G401

34649

INTEL

8500953

IO Module

116199-L04

0MJF9

Themis Computer

514-120821-L01

CEM (v)3.0 I/O Module

514-120821-L01

0MJF9

Themis Computer

8500957

CPU Module

116479-L03

0MJF9

Themis Computer

514-120823-L02

CEM (v)3.0 CPU Module

514-120823-L02

0MJF9

Themis Computer

8500961

Media Module

116200-L04

0MJF9

Themis Computer

514-121124-L01

CEM (v)3.0 Media Module

514-121124-L01

0MJF9

Themis Computer

514-121111-L04

CEM (v)3.0 RCEM Cable Kit

514-121111-L04

0MJF9

Themis Computer

514-117666-L01

CEM (v)3.0 SFP Transceiver Module, SMF, 1000Base – LX10 1310NM

514-117666-L01

0MJF9

Themis Computer

514-117666-L02

CEM (v)3.0 SFP Transceiver Module, SMF, 1000Base – LX10 1310NM (Shimmed)

514-117666-L02

0MJF9

Themis Computer

514-117815-L01

CEM (v)3.0 SFP Transceiver Module, MMF, 1000Base – SX 850NM

514-117815-L01

0MJF9

Themis Computer

514-115484-L02

CEM (v)3.0 SFP Transceiver Module, MMF, I2C, 1000Base- LX10 1310NM (Shimmed)

514-115484-L02

0MJF9

Themis Computer

8500972

SOLID STATE RELAY

SD48D50A

11532

TELEDYNE

8500973

FIBER CONTROL RELAY, RECEIVER

CR-8001-7

1TGU2

LITEWAY INC

8500987

LCD KEYBOARD DRAWER

RD1U-CAT24170W.USN.0002

5A8X0

2S2

8562076

KVM

RD1U-CAT24170W.USN0004

5A8X0

DIT/2S2

8561998

UPS

GRSLPFC11-3K60-120-120-5M-3U-10634-1

29019

NOVA ELECTRIC

923717

UPS BATTERY

923717

29019

NOVA ELECTRIC

8501482

CUSTOM JONATHAN CABLE MANAGEMENT ARM

CMS151052

SK721

JONATHAN

8501475-8

DIGITAL TEMP SENSOR

06-1016516-UCE

45620

DAWN VME PRODUCTS

8501483

Power Temperature Control Unit (PTC)

N/A - GFP

CDSA Dam Neck

8346893

FAN ASSY AID

X17L24BGM5-07

67088

NIDEC

Vol III, Sect 2.2.2

VOLUME III, SECTION 2.2.2

The following worksheets contain the format and instructions required for submitting supporting cost data.

Total CPFF Detail

CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
0022	Systems Engineer	CO_EE1	3	$ 48	$ 8	$ 9	$ - 0	$ 10	$ 1	$ 75	$ 151
0022	Electrical Engineer	CO_EE2	6	$ 96	$ 15	$ 18	$ - 0	$ 21	$ 2	$ 150	$ 302
0022	Mechanical Engineer	Subcontractor	9	$ - 0	$ - 0	$ - 0	$ 3,000	$ 480	$ 56	$ 3,480	$ 7,016
0022	Test Engineer	CO_ME1	12	$ 192	$ 31	$ 36	$ - 0	$ 42	$ 5	$ 300	$ 605
0022	PMO/Admin	CO_TE1	15	$ 240	$ 39	$ 45	$ - 0	$ 52	$ 6	$ 375	$ 756
0022	Manufacturing Support	CO_PMO1	18	$ 288	$ 46	$ 54	$ - 0	$ 62	$ 7	$ 450	$ 907
1022	Systems Engineer	CO_EE1	21	$ 336	$ 54	$ 63	$ - 0	$ 73	$ 8	$ 525	$ 1,059
1022	Electrical Engineer	CO_EE2	24	$ 384	$ 62	$ 72	$ - 0	$ 83	$ 10	$ 600	$ 1,210
1022	Mechanical Engineer	Subcontractor	27	$ 432	$ 69	$ 80	$ - 0	$ 93	$ 11	$ 675	$ 1,361
1022	Test Engineer	CO_ME1	30	$ 480	$ 77	$ 89	$ - 0	$ 104	$ 12	$ 750	$ 1,512
1022	PMO/Admin	CO_TE1	33	$ 528	$ 85	$ 98	$ - 0	$ 114	$ 13	$ 825	$ 1,664
1022	Manufacturing Support	CO_PMO1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2022	Systems Engineer	CO_EE1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2022	Electrical Engineer	CO_EE2	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2022	Mechanical Engineer	Subcontractor	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2022	Test Engineer	CO_ME1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2022	PMO/Admin	CO_TE1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2022	Manufacturing Support	CO_PMO1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3022	Systems Engineer	CO_EE1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3022	Electrical Engineer	CO_EE2	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3022	Mechanical Engineer	Subcontractor	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3022	Test Engineer	CO_ME1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3022	PMO/Admin	CO_TE1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3022	Manufacturing Support	CO_PMO1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4022	Systems Engineer	CO_EE1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4022	Electrical Engineer	CO_EE2	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4022	Mechanical Engineer	Subcontractor	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4022	Test Engineer	CO_ME1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4022	PMO/Admin	CO_TE1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4022	Manufacturing Support	CO_PMO1	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
		Sample Spreadsheet: This worksheet shall be a sum of each value from other worksheets. As such, each FY worksheet must have the same number of rows, with the values of Columns B, C and D being exactly identical. If the identities of B, C and D are applicable one year and not others, the identity of the row must remain on the page and the Offeror should input 0 into the appropriate "Hours" or "Subcontractor" column, or leave it blank.

FY15

2	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0005	Electrical Engineer	CO_EE1	1	$ 15	$ 2	$ 3		$ 3	$ 0	$ 23	$ 46
	0005	Electrical Engineer	CO_EE2	2	$ 30	$ 5	$ 5		$ 6	$ 1	$ 46	$ 92
	0005	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 150	$ 17	$ 1,150	$ 2,317
	0005	Mechanical Engineer	CO_ME1	4	$ 60	$ 9	$ 10		$ 12	$ 1	$ 91	$ 184
	0005	Test Engineer	CO_TE1	5	$ 75	$ 11	$ 13		$ 15	$ 2	$ 114	$ 230
	0005	PMO/Admin	CO_PMO1	6	$ 90	$ 14	$ 16		$ 18	$ 2	$ 137	$ 276
	0005	PMO/Admin	CO_ADMIN1	7	$ 105	$ 16	$ 18		$ 21	$ 2	$ 160	$ 322
	0005	Manufacturing Support	CO_MFG1	8	$ 120	$ 18	$ 21		$ 24	$ 3	$ 183	$ 368
	0005	Manufacturing Support	CO_MFG2	9	$ 135	$ 20	$ 23		$ 27	$ 3	$ 205	$ 414
	1005	Electrical Engineer	CO_EE1	10	$ 150	$ 23	$ 26		$ 30	$ 3	$ 228	$ 460
	1005	Electrical Engineer	CO_EE2	11	$ 165	$ 25	$ 28		$ 33	$ 4	$ 251	$ 506
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
			Sample Spreadsheet: There shall be one worksheet for each Fiscal Year (or Calendar Year, whichever is consistent with the presentation of the FPRA/FPRP/FPRR). All CLINs shall be listed on each spreadsheet. All rates should be linked to one root spreadsheet ("Rates Summary") either using a lookup function or by multiplying the base value*<cell number in "Rates Summary">. The only manually input values shall be for the number of hours and, if applicable, subcontractor costs (not including the prime contractor's pass through). Offerors shall expand the Government defined labor category examples (Column C) into its unique labor categories (Column D), which shall be directly traceable to those categories stated in its FPRA/FPRP/FPRR. All formulas shall be kept intact so that the Government may understand the base and the application of its rates. Each labor category and direct/indirect cost category shall be separated. Each spreadsheet for each FY/CY shall have the same Columns B, C and D even if that category is applicable in one year and not others (input 0 hours or 0 subcontractor costs shall be stated, or the cell should be left blank).

FY16

3	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0005	Electrical Engineer	CO_EE1	1	$ 16	$ 3	$ 3		$ 3	$ 0	$ 25	$ 50
	0005	Electrical Engineer	CO_EE2	2	$ 32	$ 5	$ 6		$ 7	$ 1	$ 50	$ 101
	0005	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 160	$ 19	$ 1,160	$ 2,339
	0005	Mechanical Engineer	CO_ME1	4	$ 64	$ 10	$ 12		$ 14	$ 2	$ 100	$ 201
	0005	Test Engineer	CO_TE1	5	$ 80	$ 13	$ 15		$ 17	$ 2	$ 125	$ 252
	0005	PMO/Admin	CO_PMO1	6	$ 96	$ 15	$ 18		$ 21	$ 2	$ 150	$ 302
	0005	PMO/Admin	CO_ADMIN1	7	$ 112	$ 18	$ 21		$ 24	$ 3	$ 175	$ 352
	0005	Manufacturing Support	CO_MFG1	8	$ 128	$ 20	$ 24		$ 28	$ 3	$ 200	$ 403
	0005	Manufacturing Support	CO_MFG2	9	$ 144	$ 23	$ 27		$ 31	$ 4	$ 225	$ 453
	1005	Electrical Engineer	CO_EE1	10	$ 160	$ 26	$ 30		$ 34	$ 4	$ 250	$ 503
	1005	Electrical Engineer	CO_EE2	11	$ 176	$ 28	$ 33		$ 38	$ 4	$ 275	$ 554
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
			Sample Spreadsheet: There shall be one worksheet for each Fiscal Year (or Calendar Year, whichever is consistent with the presentation of the FPRA/FPRP/FPRR). All CLINs shall be listed on each spreadsheet. All rates should be linked to one root spreadsheet ("Rates Summary") either using a lookup function or by multiplying the base value*<cell number in "Rates Summary">. The only manually input values shall be for the number of hours and, if applicable, subcontractor costs (not including the prime contractor's pass through). Offerors shall expand the Government defined labor category examples (Column C) into its unique labor categories (Column D), which shall be directly traceable to those categories stated in its FPRA/FPRP/FPRR. All formulas shall be kept intact so that the Government may understand the base and the application of its rates. Each labor category and direct/indirect cost category shall be separated. Each spreadsheet for each FY/CY shall have the same Columns B, C and D even if that category is applicable in one year and not others (input 0 hours or 0 subcontractor costs shall be stated, or the cell should be left blank).

FY17

4	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0005	Electrical Engineer	CO_EE1	1	$ 17	$ 3	$ 3		$ 4	$ 0	$ 27	$ 55
	0005	Electrical Engineer	CO_EE2	2	$ 34	$ 6	$ 7		$ 8	$ 1	$ 54	$ 110
	0005	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 170	$ 20	$ 1,170	$ 2,360
	0005	Mechanical Engineer	CO_ME1	4	$ 68	$ 12	$ 14		$ 16	$ 2	$ 109	$ 220
	0005	Test Engineer	CO_TE1	5	$ 85	$ 14	$ 17		$ 20	$ 2	$ 136	$ 275
	0005	PMO/Admin	CO_PMO1	6	$ 102	$ 17	$ 20		$ 24	$ 3	$ 163	$ 330
	0005	PMO/Admin	CO_ADMIN1	7	$ 119	$ 20	$ 24		$ 28	$ 3	$ 191	$ 384
	0005	Manufacturing Support	CO_MFG1	8	$ 136	$ 23	$ 27		$ 32	$ 4	$ 218	$ 439
	0005	Manufacturing Support	CO_MFG2	9	$ 153	$ 26	$ 30		$ 36	$ 4	$ 245	$ 494
	1005	Electrical Engineer	CO_EE1	10	$ 170	$ 29	$ 34		$ 40	$ 5	$ 272	$ 549
	1005	Electrical Engineer	CO_EE2	11	$ 187	$ 32	$ 37		$ 44	$ 5	$ 300	$ 604
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
			Sample Spreadsheet: There shall be one worksheet for each Fiscal Year (or Calendar Year, whichever is consistent with the presentation of the FPRA/FPRP/FPRR). All CLINs shall be listed on each spreadsheet. All rates should be linked to one root spreadsheet ("Rates Summary") either using a lookup function or by multiplying the base value*<cell number in "Rates Summary">. The only manually input values shall be for the number of hours and, if applicable, subcontractor costs (not including the prime contractor's pass through). Offerors shall expand the Government defined labor category examples (Column C) into its unique labor categories (Column D), which shall be directly traceable to those categories stated in its FPRA/FPRP/FPRR. All formulas shall be kept intact so that the Government may understand the base and the application of its rates. Each labor category and direct/indirect cost category shall be separated. Each spreadsheet for each FY/CY shall have the same Columns B, C and D even if that category is applicable in one year and not others (input 0 hours or 0 subcontractor costs shall be stated, or the cell should be left blank).

FY18

4	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0005	Electrical Engineer	CO_EE1	1	$ 17	$ 3	$ 3		$ 4	$ 0	$ 27	$ 55
	0005	Electrical Engineer	CO_EE2	2	$ 34	$ 6	$ 7		$ 8	$ 1	$ 54	$ 110
	0005	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 170	$ 20	$ 1,170	$ 2,360
	0005	Mechanical Engineer	CO_ME1	4	$ 68	$ 12	$ 14		$ 16	$ 2	$ 109	$ 220
	0005	Test Engineer	CO_TE1	5	$ 85	$ 14	$ 17		$ 20	$ 2	$ 136	$ 275
	0005	PMO/Admin	CO_PMO1	6	$ 102	$ 17	$ 20		$ 24	$ 3	$ 163	$ 330
	0005	PMO/Admin	CO_ADMIN1	7	$ 119	$ 20	$ 24		$ 28	$ 3	$ 191	$ 384
	0005	Manufacturing Support	CO_MFG1	8	$ 136	$ 23	$ 27		$ 32	$ 4	$ 218	$ 439
	0005	Manufacturing Support	CO_MFG2	9	$ 153	$ 26	$ 30		$ 36	$ 4	$ 245	$ 494
	1005	Electrical Engineer	CO_EE1	10	$ 170	$ 29	$ 34		$ 40	$ 5	$ 272	$ 549
	1005	Electrical Engineer	CO_EE2	11	$ 187	$ 32	$ 37		$ 44	$ 5	$ 300	$ 604
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
			Sample Spreadsheet: There shall be one worksheet for each Fiscal Year (or Calendar Year, whichever is consistent with the presentation of the FPRA/FPRP/FPRR). All CLINs shall be listed on each spreadsheet. All rates should be linked to one root spreadsheet ("Rates Summary") either using a lookup function or by multiplying the base value*<cell number in "Rates Summary">. The only manually input values shall be for the number of hours and, if applicable, subcontractor costs (not including the prime contractor's pass through). Offerors shall expand the Government defined labor category examples (Column C) into its unique labor categories (Column D), which shall be directly traceable to those categories stated in its FPRA/FPRP/FPRR. All formulas shall be kept intact so that the Government may understand the base and the application of its rates. Each labor category and direct/indirect cost category shall be separated. Each spreadsheet for each FY/CY shall have the same Columns B, C and D even if that category is applicable in one year and not others (input 0 hours or 0 subcontractor costs shall be stated, or the cell should be left blank).

FY19

4	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0005	Electrical Engineer	CO_EE1	1	$ 17	$ 3	$ 3		$ 4	$ 0	$ 27	$ 55
	0005	Electrical Engineer	CO_EE2	2	$ 34	$ 6	$ 7		$ 8	$ 1	$ 54	$ 110
	0005	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 170	$ 20	$ 1,170	$ 2,360
	0005	Mechanical Engineer	CO_ME1	4	$ 68	$ 12	$ 14		$ 16	$ 2	$ 109	$ 220
	0005	Test Engineer	CO_TE1	5	$ 85	$ 14	$ 17		$ 20	$ 2	$ 136	$ 275
	0005	PMO/Admin	CO_PMO1	6	$ 102	$ 17	$ 20		$ 24	$ 3	$ 163	$ 330
	0005	PMO/Admin	CO_ADMIN1	7	$ 119	$ 20	$ 24		$ 28	$ 3	$ 191	$ 384
	0005	Manufacturing Support	CO_MFG1	8	$ 136	$ 23	$ 27		$ 32	$ 4	$ 218	$ 439
	0005	Manufacturing Support	CO_MFG2	9	$ 153	$ 26	$ 30		$ 36	$ 4	$ 245	$ 494
	1005	Electrical Engineer	CO_EE1	10	$ 170	$ 29	$ 34		$ 40	$ 5	$ 272	$ 549
	1005	Electrical Engineer	CO_EE2	11	$ 187	$ 32	$ 37		$ 44	$ 5	$ 300	$ 604
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
			Sample Spreadsheet: There shall be one worksheet for each Fiscal Year (or Calendar Year, whichever is consistent with the presentation of the FPRA/FPRP/FPRR). All CLINs shall be listed on each spreadsheet. All rates should be linked to one root spreadsheet ("Rates Summary") either using a lookup function or by multiplying the base value*<cell number in "Rates Summary">. The only manually input values shall be for the number of hours and, if applicable, subcontractor costs (not including the prime contractor's pass through). Offerors shall expand the Government defined labor category examples (Column C) into its unique labor categories (Column D), which shall be directly traceable to those categories stated in its FPRA/FPRP/FPRR. All formulas shall be kept intact so that the Government may understand the base and the application of its rates. Each labor category and direct/indirect cost category shall be separated. Each spreadsheet for each FY/CY shall have the same Columns B, C and D even if that category is applicable in one year and not others (input 0 hours or 0 subcontractor costs shall be stated, or the cell should be left blank).

Rates Summary

Company Unique Labor Category	FY15	FY16	FY17	FY18	FY19	Note:
CO_EE1	15	16	17	18	19
CO_EE2	15	16	17	18	19
CO_EE3	15	16	17	18	19
CO_ME1	15	16	17	18	19
CO_TE1	15	16	17	18	19
CO_PMO1	15	16	17	18	19
CO_ADMIN1	15	16	17	18	19
CO_MFG1	15	16	17	18	19
CO_MFG2	15	16	17	18	19
CO_EE1	15	16	17	18	19
CO_EE2	15	16	17	18	19
Subcontractor	0	0	0	0	0
Fringe	15%	16%	17%	18%	19%	Please briefly state application (e.g., Direct Cost * Fringe Rate)
Overhead	15%	16%	17%	18%	19%	Please briefly state application (e.g., Direct Cost * Overhead Rate)
G&A	15%	16%	17%	18%	19%	Please briefly state application (e.g., Direct Cost * G&A Rate)
FCCM	0.015	0.016	0.017	0.018	0.019	Please briefly state application (e.g., Direct Cost * FCCM Rate)
Fee	1.00

File details come from the government source that posted it. Updated Nov 14, 2017.