Attachment_11_Cost_Summary_Format_06262013.xls

XLS spreadsheet 103 KB Posted Aug 1, 2013

Attached to: COMPETITIVE SOLICITATION FOR THE PRODUCTION OF THE COMMON PROCESSING SYSTEM (CPS) (SB SET-ASIDE)
Solicitation number: N0002413R5213
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Attachment 11 - Cost Summary Format

View the file

Other files

File	Type	Posted
N00024-13-R-5213_Amendment_2.pdf	PDF	Sep 26, 2013
20132609_BQResponse_(A0055-A0061).xlsx	XLSX spreadsheet	Sep 26, 2013
13R5213_-_CDRL_DATA_PKG_05SEP13.pdf	PDF	Sep 11, 2013
20130609_BQResponse_(A0001-A0054).xlsx	XLSX spreadsheet	Sep 11, 2013
N00024-13-R-5213_Amendment_1.pdf	PDF	Sep 11, 2013
Attachment_A_-__CDRL14JUN13.pdf	PDF	Aug 1, 2013
Attachment_8_-_dated_2_July_2013.pdf	PDF	Aug 1, 2013
N00024-13-R-5213_07052013.pdf	PDF	Aug 1, 2013
Attachment_1_-_Form_DD254_dated_01_May_2013.pdf	PDF	Aug 1, 2013
Attachment_10_Bidders_Questions_Form.xls	XLS spreadsheet	Aug 1, 2013
N0002413R5213_Attachment_10_Bidders_Questions_Form.xls	XLS spreadsheet	Jul 5, 2013
N0002413R5213_Attachment_11_Cost_Summary_Format_06262013.xls	XLS spreadsheet	Jul 5, 2013
N0002413R5213_Attachment_1_-_Form_DD254_dated_01_May_2013.pdf	PDF	Jul 5, 2013
N0002413R5213_Attachment_A_-__CDRL14JUN13.pdf	PDF	Jul 5, 2013
N0002413R5213_Attachment_8_-_dated_2_July_2013.pdf	PDF	Jul 5, 2013

Show all 15

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 11: Format for Price/Cost Summaries and Detailed Cost Data for CPFF CLINs

COMMON PROCESSING SYSTEM (CPS)

Solicitation: N00024-13-R-5213

Vol III, Sect 2.1 Price Summ

VOLUME III, SECTION 2.1

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

CLINs

Pricing

Spares Pricing

Cost

CLIN

Description

Units

QTY: 1

QTY: 2-87

QTY: 8-14

QTY: 15+

QTY: 1-4

QTY: 5-9

QTY: 10+

Repairs

Qty

Est. Cost

Fixed Fee

CPFF

0001

Water Cooled with GFM

Each

0002

Water Cooled

Each

0003

Air Cooled

Each

0004

Air Cooled with GFM

Each

0005

Spares and Installation and Checkout

Lot

0006

Engineering Studies

Hours

8,000

0007

Material and Other Direct Costs (ODC)

Lot

$ 80,000

1001

Water Cooled with GFM

Each

1002

Water Cooled

Each

1003

Air Cooled

Each

1004

Air Cooled with GFM

Each

1005

Spares and Installation and Checkout

Lot

1006

Engineering Studies

Hours

8,000

1007

Material and Other Direct Costs (ODC)

Lot

$ 80,000

2001

Water Cooled with GFM

Each

2002

Water Cooled

Each

2003

Air Cooled

Each

2004

Air Cooled with GFM

Each

2005

Spares and Installation and Checkout

Lot

2006

Engineering Studies

Hours

8,000

2007

Material and Other Direct Costs (ODC)

Lot

$ 80,000

3001

Water Cooled with GFM

Each

3002

Water Cooled

Each

3003

Air Cooled

Each

3004

Air Cooled with GFM

Each

3005

Spares and Installation and Checkout

Lot

3006

Engineering Studies

Hours

8,000

3007

Material and Other Direct Costs (ODC)

Lot

$ 80,000

4001

PIO

Lot

4002

First Article Requirements - Water Cooled with GFM

Each

4003

First Article Requirements - Water Cooled

Each

4004

First Article Requirements - Air Cooled

Each

4005

First Article Requirements - Air Cooled with GFM

Each

5001

Data

Lot

Spares

Unit Prices for Spares and INCO Spares

(CLIN's 0004,1004, and 2004)

CPS P/N

Part Description

CLIN

0004

1004

2004

1-4

5-9

10+

Repairs

1-4

5-9

10+

Repairs

1-4

5-9

10+

Repairs

903050.00

Fan Assembly

0903040*

Heat Exchanger*

0903065-01

Temperature Sensor No. 1

0903065-03

Temperature Sensor No. 2

0903067*

Power & Temperature Control Assembly*

0903041*

Power Conditioner*

903015.00

Keyboard/Display

44T2277

Fan Module

1983.00

BladeCenter Power Supply

GTS-BCHT-2300

Chassis, BladeCenter (unpopulated)

4817.00

Media Tray

4822.00

BladeCenter 4GB Compact Flash

1604.00

Advanced Management Module

GTS-HS22RAM-07021911

Chassis, HS22 Blade Processing

1911.00

Memory Board, 8GB

1077.00

CCA, CFFh 1GB

GTS-MGT1RAM-07021911

Chassis, HS22 Blade Management #1

1068.00

PCIe Expansion Blade

Tsync-PCIe

CCA, IRIG-B

GTS-MGT2RAM-07021911

Chassis, HS22 Blade Management #2

5755.00

CCA, CFFh 10GB

1590.00

1/10GBE Switch Module

1639.00

10-Port 10GBE Switch Module

BNTBN-CKM-S-T

Transceiver

BNTBN-CKM-S-LX

Transceiver

BNTBN-CKM-SP-LR

Transceiver

5561.00

1TB Dual Port SATA Drive

5311.00

300GB 15K SAS Drive

4802.00

EXP Environmental Services Module

902007.00

EMI Filter

FOILX 15.5 X 18.0 X 0.5

Aluminum Dust Filter

903032.00

Indicator Panel Assembly

GTS-JON-SK721

Door Stop

GTS-PTCA-MOL232

Cable, PTCA Configuration

Vol III, Sect 2.2.1 Supp Price

VOLUME III, SECTION 2.2.1

The following worksheet contains the format required for submitting supporting price data.

Required Sources

					Unburdened Cost															Burdened Cost
Part Description	CDS P/N	Manuf P/N	Manuf Cage Code	Manuf Name	0001	0002	0003	0004	1001	1002	1003	1004	2001	2002	2003	2004	3002	3003	3004	0001	0002	0003	0004	1001	1002	1003	1004	2001	2002	2003	2004	3001	3002	3003	3004
Blade Center HT Chassis	8346866	X1RYMUS	49EQ3	IBM Corporation
SLIMLINE 1U 17.0IN WXGA AND FLAT PANEL MONITOR	8346868	90-711-007-A	1JA77	General Digital
BLADECENTER HS22 (PROCESSING BLADE)	8346869-01	X1RYQUS	49EQ3	IBM Corporation
HS22 (MANAGEMENT BLADE #1)	8346869-03	X1SACUS	49EQ3	IBM Corporation
HS22 (MANAGEMENT BLADE #2)	8346869-05	X1SADUS	49EQ3	IBM Corporation
BNT 1/10GB UPLINK ETHERNET SWITCH MODULE FOR IBM BLADECENTER	8346870	44W4407	49EQ3	IBM Corporation
10-PORT 10GB ETHERNET SWITCH MODULE	8346871	46C7194	49EQ3	IBM Corporation
Heater Exchanger	8346888	N/A	1T434	Thermacore Inc.
POWER CONDITIONER (ASSEMBLY)	8346913	N/A	1MYP5	Global Technical Systems
ISOLATION SHOCK MOUNT (900-1100 LBS)	8346799-05	0402040-05	1MYP5	Global Technical Systems
74" ENCLOSURE SIDAS ISOLATOR (350 LB PRELOAD)	8346831-03	0504002-03	1MYP5	Global Technical Systems

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
0005	Electrical Engineer	CO_EE1	3	$ 45	$ 7	$ 8	$ - 0	$ 9	$ 1	$ 68	$ 138
0005	Electrical Engineer	CO_EE2	6	$ 90	$ 14	$ 16	$ - 0	$ 18	$ 2	$ 137	$ 275
0005	Electrical Engineer	Subcontractor	9	$ - 0	$ - 0	$ - 0	$ 3,000	$ 440	$ 52	$ 3,440	$ 6,932
0005	Mechanical Engineer	CO_ME1	12	$ 180	$ 27	$ 31	$ - 0	$ 35	$ 4	$ 273	$ 551
0005	Test Engineer	CO_TE1	15	$ 225	$ 34	$ 39	$ - 0	$ 44	$ 5	$ 342	$ 688
0005	PMO/Admin	CO_PMO1	18	$ 270	$ 41	$ 47	$ - 0	$ 53	$ 6	$ 410	$ 826
0005	PMO/Admin	CO_ADMIN1	21	$ 315	$ 47	$ 55	$ - 0	$ 61	$ 7	$ 478	$ 964
0005	Manufacturing Support	CO_MFG1	24	$ 360	$ 54	$ 62	$ - 0	$ 70	$ 8	$ 547	$ 1,102
0005	Manufacturing Support	CO_MFG2	27	$ 405	$ 61	$ 70	$ - 0	$ 79	$ 9	$ 615	$ 1,239
1005	Electrical Engineer	CO_EE1	30	$ 450	$ 68	$ 78	$ - 0	$ 88	$ 10	$ 683	$ 1,377
1005	Electrical Engineer	CO_EE2	33	$ 495	$ 74	$ 86	$ - 0	$ 96	$ 11	$ 752	$ 1,515
(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
		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.

FY14

2	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0006	Electrical Engineer	CO_EE1	1	$ 14	$ 2	$ 2		$ 3	$ 0	$ 21	$ 42
	0006	Electrical Engineer	CO_EE2	2	$ 28	$ 4	$ 4		$ 5	$ 1	$ 41	$ 84
	0006	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 140	$ 16	$ 1,140	$ 2,296
	0006	Mechanical Engineer	CO_ME1	4	$ 56	$ 8	$ 9		$ 10	$ 1	$ 83	$ 167
	0006	Test Engineer	CO_TE1	5	$ 70	$ 10	$ 11		$ 13	$ 1	$ 104	$ 209
	0006	PMO/Admin	CO_PMO1	6	$ 84	$ 12	$ 13		$ 15	$ 2	$ 124	$ 251
	0006	PMO/Admin	CO_ADMIN1	7	$ 98	$ 14	$ 16		$ 18	$ 2	$ 145	$ 292
	0006	Manufacturing Support	CO_MFG1	8	$ 112	$ 16	$ 18		$ 20	$ 2	$ 166	$ 334
	0006	Manufacturing Support	CO_MFG2	9	$ 126	$ 18	$ 20		$ 23	$ 3	$ 187	$ 376
	1004	Electrical Engineer	CO_EE1	10	$ 140	$ 20	$ 22		$ 25	$ 3	$ 207	$ 418
	1004	Electrical Engineer	CO_EE2	11	$ 154	$ 22	$ 25		$ 28	$ 3	$ 228	$ 460
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)
			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 (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).

FY15

3	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0006	Electrical Engineer	CO_EE1	1	$ 15	$ 2	$ 3		$ 3	$ 0	$ 23	$ 46
	0006	Electrical Engineer	CO_EE2	2	$ 30	$ 5	$ 5		$ 6	$ 1	$ 45	$ 91
	0006	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 140	$ 17	$ 1,140	$ 2,297
	0006	Mechanical Engineer	CO_ME1	4	$ 60	$ 9	$ 10		$ 11	$ 1	$ 90	$ 182
	0006	Test Engineer	CO_TE1	5	$ 75	$ 11	$ 13		$ 14	$ 2	$ 113	$ 228
	0006	PMO/Admin	CO_PMO1	6	$ 90	$ 14	$ 16		$ 17	$ 2	$ 136	$ 273
	0006	PMO/Admin	CO_ADMIN1	7	$ 105	$ 16	$ 18		$ 19	$ 2	$ 158	$ 319
	0006	Manufacturing Support	CO_MFG1	8	$ 120	$ 18	$ 21		$ 22	$ 3	$ 181	$ 365
	0006	Manufacturing Support	CO_MFG2	9	$ 135	$ 20	$ 23		$ 25	$ 3	$ 204	$ 410
	1004	Electrical Engineer	CO_EE1	10	$ 150	$ 23	$ 26		$ 28	$ 3	$ 226	$ 456
	1004	Electrical Engineer	CO_EE2	11	$ 165	$ 25	$ 28		$ 31	$ 4	$ 249	$ 501
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)

FY16

4	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0006	Electrical Engineer	CO_EE1	1	$ 16	$ 3	$ 3		$ 3	$ 0	$ 25	$ 50
	0006	Electrical Engineer	CO_EE2	2	$ 32	$ 5	$ 6		$ 7	$ 1	$ 50	$ 101
	0006	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 160	$ 19	$ 1,160	$ 2,339
	0006	Mechanical Engineer	CO_ME1	4	$ 64	$ 10	$ 12		$ 14	$ 2	$ 100	$ 201
	0006	Test Engineer	CO_TE1	5	$ 80	$ 13	$ 15		$ 17	$ 2	$ 125	$ 252
	0006	PMO/Admin	CO_PMO1	6	$ 96	$ 15	$ 18		$ 21	$ 2	$ 150	$ 302
	0006	PMO/Admin	CO_ADMIN1	7	$ 112	$ 18	$ 21		$ 24	$ 3	$ 175	$ 352
	0006	Manufacturing Support	CO_MFG1	8	$ 128	$ 20	$ 24		$ 28	$ 3	$ 200	$ 403
	0006	Manufacturing Support	CO_MFG2	9	$ 144	$ 23	$ 27		$ 31	$ 4	$ 225	$ 453
	1004	Electrical Engineer	CO_EE1	10	$ 160	$ 26	$ 30		$ 34	$ 4	$ 250	$ 503
	1004	Electrical Engineer	CO_EE2	11	$ 176	$ 28	$ 33		$ 38	$ 4	$ 275	$ 554
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)

FY17

5	CLIN	Category	Company Unique Labor Category	Hours	Direct Labor	Fringe	Overhead	Subcontractor	G&A	FCCM	Fee	CPFF
	0006	Electrical Engineer	CO_EE1	1	$ 17	$ 3	$ 3		$ 4	$ 0	$ 27	$ 53
	0006	Electrical Engineer	CO_EE2	2	$ 34	$ 5	$ 6		$ 7	$ 1	$ 53	$ 107
	0006	Electrical Engineer	Subcontractor	3	$ - 0	$ - 0	$ - 0	$ 1,000	$ 160	$ 19	$ 1,160	$ 2,339
	0006	Mechanical Engineer	CO_ME1	4	$ 68	$ 11	$ 13		$ 15	$ 2	$ 106	$ 214
	0006	Test Engineer	CO_TE1	5	$ 85	$ 14	$ 16		$ 18	$ 2	$ 133	$ 267
	0006	PMO/Admin	CO_PMO1	6	$ 102	$ 16	$ 19		$ 22	$ 3	$ 159	$ 321
	0006	PMO/Admin	CO_ADMIN1	7	$ 119	$ 19	$ 22		$ 26	$ 3	$ 186	$ 374
	0006	Manufacturing Support	CO_MFG1	8	$ 136	$ 22	$ 25		$ 29	$ 3	$ 212	$ 428
	0006	Manufacturing Support	CO_MFG2	9	$ 153	$ 24	$ 28		$ 33	$ 4	$ 239	$ 481
	1004	Electrical Engineer	CO_EE1	10	$ 170	$ 27	$ 32		$ 37	$ 4	$ 265	$ 535
	1004	Electrical Engineer	CO_EE2	11	$ 187	$ 30	$ 35		$ 40	$ 5	$ 292	$ 588
	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)	(…)

Rates Summary

Company Unique Labor Category	FY14	FY15	FY16	FY17	Note:
CO_EE1	14	15	16	17
CO_EE2	14	15	16	17
CO_EE3	14	15	16	17
CO_ME1	14	15	16	17
CO_TE1	14	15	16	17
CO_PMO1	14	15	16	17
CO_ADMIN1	14	15	16	17
CO_MFG1	14	15	16	17
CO_MFG2	14	15	16	17
CO_EE1	14	15	16	17
CO_EE2	14	15	16	17
Subcontractor	0	0	0	0
Fringe	14%	15%	16%	16%	Please briefly state application (e.g., Direct Cost * Fringe Rate)
Overhead	14%	15%	16%	16%	Please briefly state application (e.g., Direct Cost * Overhead Rate)
G&A	14%	14%	16%	16%	Please briefly state application (e.g., Direct Cost * G&A Rate)
FCCM	0.014	0.015	0.016	0.016	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.