Attch_2_-_Test_Market_Basket.xlsx

XLSX spreadsheet 20 KB Posted Dec 15, 2021

Attached to: 2895 - Cummins Engine and Replacement Parts Federal contract opportunity
Solicitation number: N0060422Q4007
Issued by: Department of the Navy Naval Supply Systems Command

View the file

Other files for this federal contract opportunity

Other files attached to 2895 - Cummins Engine and Replacement Parts, newest first.
File	Type	Posted
Attch_3_-_Amd001_FAR_Representations.pdf	PDF	Dec 16, 2021
Attch_1_Redacted_JA.pdf	PDF	Dec 15, 2021
Attch_3_-_FAR_Representations.pdf	PDF	Dec 15, 2021

On GovTribe

Work with this file on GovTribe

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.

Cummins Engines & Parts

TEST MARKET BASKET

OVERVIEW

Commander Navy Region Hawaii, Regional Boat Maintenance Center (RBMC) is implementing a preventative maintenance program for its boat fleet with Cummins Engines. When fully implemented, RBMC intends to maintain a 6-month inventory of Cummins engines and OEM replacement parts necessary for its preventative maintenance program and corrective repairs that may occur. The Government has identified the following items as a test market basket to evaluate the Quoter’s minimum discount %. The estimated quantities of the items represent the estimated annual order volume when the RBMC’s preventative maintenance program is fully implemented.

IMPORTANT:

The Government is obligated only to the extent of authorized calls (orders) actually placed against this BPA and shall not be liable in any manner in the event no calls are made. Please note that a BPA is not a contract. A BPA is a streamlined method for acquiring supplies on an as-needed basis from qualified sources that are readily available and thus eliminates the need for repetitive costly re-procurements. There is no minimum or maximum guaranteed quantity.

INSTRUCTIONS

1. Input the Offeror’s minimum discount %. in the highlighted cell below.

2. In COLUMN E, input the Offeror’s manufacturer schedule price for the applicable items. A MSRP must be provided for all items.

3. The test market basket shall calculate Column F, Column G, and Column H (No input is required). The Offeror’s total evaluation price shall be calculated by using the inputted %, Column F, Column G, and Column H and the stated estimated quantities.

		MINIMUM DISCOUNT ON REPLACEMENT PARTS (-%):
		MINIMUM DISCOUNT ON ENGINES(-%):
					COLUMN E	COLUMN F	COLUMN G	COLUMN H
		PART #	DESCRIPTION	EST QTY	Input Manufacturer Suggested Retail Price (MSRP)	Minimum Discount %	Evaluated Unit Price	Evaluated Extended Price
	REPLACEMENT PARTS	3349230	ISOLATOR, VIBRATION	48		0%	$ - 0	$ - 0
		3969778	ALARM	4		0%	$ - 0	$ - 0
		5523951	ALTERNATOR	6		0%	$ - 0	$ - 0
		5466980	BELT,V RIBBED	6		0%	$ - 0	$ - 0
		3978311	BEZEL, DISPLAY PANEL	6		0%	$ - 0	$ - 0
		3903242	BUSHING	6		0%	$ - 0	$ - 0
		3901306	BUSHING, CAMSHAFT	24		0%	$ - 0	$ - 0
		3937743	CARTRIDGE, LUBE OIL FILTER	60		0%	$ - 0	$ - 0
		4931610	CLEANER, AIR	48		0%	$ - 0	$ - 0
		5288253	COOLER, FUEL	8		0%	$ - 0	$ - 0
		3975986	COOLER, OIL	6		0%	$ - 0	$ - 0
		3912146	COOLER, OIL	6		0%	$ - 0	$ - 0
		5566839	CORE,AFTERCOOLER	4		0%	$ - 0	$ - 0
		3975189	COVER, HEAT EXCHANGER	6		0%	$ - 0	$ - 0
		3972473	COVER, PROTECTIVE	6		0%	$ - 0	$ - 0
		3949561	FILTER, LUBRICATING OIL	60		0%	$ - 0	$ - 0
		3977721	FUEL FILTER	60		0%	$ - 0	$ - 0
		3977722	FUEL FILTER HEAD	24		0%	$ - 0	$ - 0
		3959612	FUEL FILTER	144		0%	$ - 0	$ - 0
		3958645	GASKET, CYLINDER HEAD	8		0%	$ - 0	$ - 0
		3978517	GASKET, CYLINDER HEAD	8		0%	$ - 0	$ - 0
		3978312	GASKET, DISPLAY PANEL	6		0%	$ - 0	$ - 0
		3975187	GASKET, HEAT EXCHANGER	144		0%	$ - 0	$ - 0
		3963379	GASKET, RKR LEVER HOUSING	16		0%	$ - 0	$ - 0
		3921926	GASKET, TURBOCHARGER	24		0%	$ - 0	$ - 0
		3954324	GASKET, VALVE COVER	16		0%	$ - 0	$ - 0
		3921961	GASKET,EXH OUT CONNECTION	16		0%	$ - 0	$ - 0
		4933308	HOUSING,AFTERCOOLER	8		0%	$ - 0	$ - 0
		5263319	INJECTOR	20		0%	$ - 0	$ - 0
		4089973	KIT, ISOLATOR, VIBRATION	24		0%	$ - 0	$ - 0
		4089149	KIT, CYL BLOCK HARDWARE	8		0%	$ - 0	$ - 0
		3802820	KIT, SEAL	8		0%	$ - 0	$ - 0
		3926126	KIT, SEAL	8		0%	$ - 0	$ - 0
		3974456	KIT, WP REPAIR (MINOR)	8		0%	$ - 0	$ - 0
		4933306 (3977267)	KIT,AFTERCOOLER CORE	6		0%	$ - 0	$ - 0
		4933305	KIT,AFTERCOOLER SEAL	16		0%	$ - 0	$ - 0
		3974457	KIT,WP IDLER REPAIR-INTERM	12		0%	$ - 0	$ - 0
		5268424	KIT,WP REPAIR (MAJOR)	4		0%	$ - 0	$ - 0
		3965159	MODULE, ELECTRONIC CONTROL	4		0%	$ - 0	$ - 0
		4921776RX	MODULE, ELECTRONIC CONTROL
Recon Equivalent 4921776RX	4		0%	$ - 0	$ - 0
		4929301	MODULE, ETR INTERFACE	4		0%	$ - 0	$ - 0
		3964428	MOTOR, STARTING st951GF	16		0%	$ - 0	$ - 0
		3004853	NUT,LOCK	80		0%	$ - 0	$ - 0
		3978300	PANEL, END	12		0%	$ - 0	$ - 0
		3970463	PLUG, ZINC ELECTRODE	40		0%	$ - 0	$ - 0
		68241	PLUG, ZINC ELECTRODE	40		0%	$ - 0	$ - 0
		5260632	PUMP, FUEL TRANSFER	8		0%	$ - 0	$ - 0
		526424 RX	PUMP, FUEL	4		0%	$ - 0	$ - 0
		3902023	SCREW, HEX FLANGE HEAD CAP	80		0%	$ - 0	$ - 0
		3975185	SCREW, HEXAGON HEAD CAP	48		0%	$ - 0	$ - 0
		3978302	SEAL, CONTROL PANEL	40		0%	$ - 0	$ - 0
		3937142	SEAL, INJECTOR	144		0%	$ - 0	$ - 0
		4890926	SEAL, O RING	72		0%	$ - 0	$ - 0
		145545	SEAL, O RING	48		0%	$ - 0	$ - 0
		3937111	SEAL, OIL KIT	8		0%	$ - 0	$ - 0
		5259499	SEAL, OIL	12		0%	$ - 0	$ - 0
		540392	SEAL, OIL	24		0%	$ - 0	$ - 0
		3949688	SEAL, RECTANGULAR RING	24		0%	$ - 0	$ - 0
		3969779	SENSOR, TEMPERATURE	6		0%	$ - 0	$ - 0
		3977913	SET, LUB OIL COOLER GASKET	48		0%	$ - 0	$ - 0
		5263317	SCREW, HEX FLANGE HEAD CAP INJECTOR	4		0%	$ - 0	$ - 0
		3904166	SLEEVE, SALVAGE	8		0%	$ - 0	$ - 0
		3964428 NW	STR, DENSO 12V, 13T, 2.	8		0%	$ - 0	$ - 0
		3967726	ALTERNATOR	6		0%	$ - 0	$ - 0
		3978304	SWITCH, CRUISE	12		0%	$ - 0	$ - 0
		3978310	SWITCH, KEY	6		0%	$ - 0	$ - 0
		3978306	SWITCH, RPM	12		0%	$ - 0	$ - 0
		3978305	SWITCH, SLOW IDLE	12		0%	$ - 0	$ - 0
		3978309	SWITCH, START	6		0%	$ - 0	$ - 0
		3978307	SWITCH, STATION SELECT	18		0%	$ - 0	$ - 0
		3978308	SWITCH, STOP	6		0%	$ - 0	$ - 0
		3978303	SWITCH, SYNC	12		0%	$ - 0	$ - 0
		3973820	TENSIONER,BELT	8		0%	$ - 0	$ - 0
		3954829	SEAL, THERMOSTAT	16		0%	$ - 0	$ - 0
		5292748	THERMOSTAT	12		0%	$ - 0	$ - 0
		3909409	TOOL, SEAL INSTALLATION	12		0%	$ - 0	$ - 0
		4089425	TOOL, SEAL INSTALLATION	12		0%	$ - 0	$ - 0
		3904351	TOOL, SEAL INSTALLATION	48		0%	$ - 0	$ - 0
		4089816	TURBOCHARGERHX40	4		0%	$ - 0	$ - 0
		4090048	TURBOCHARGERHX41	4		0%	$ - 0	$ - 0
		3975186	WASHER, SEALING	24		0%	$ - 0	$ - 0
		4089973	WASHER, PLAIN	12		0%	$ - 0	$ - 0
		3921916	WIRE, ELECTRICAL	20		0%	$ - 0	$ - 0
		4955707 (3418017)	WATER PUMP ASSY - BB	8		0%	$ - 0	$ - 0
		3607067	TUBE BREATHER - BB/TB	44		0%	$ - 0	$ - 0
		LF14000NN	LUBE OIL FILTER	50		0%	$ - 0	$ - 0
		3974456	WATERPUMP IMPELLER	40		0%	$ - 0	$ - 0
		3035679	WATER PUMP IMPELLER -BB	56		0%	$ - 0	$ - 0
		5566839	AFTERCOOLER	4		0%	$ - 0	$ - 0
		LF3349	LUBE OIL FILTER	100		0%	$ - 0	$ - 0
		3972735	ALTERNATOR	8		0%	$ - 0	$ - 0
		3934778	ALTERNATOR	4		0%	$ - 0	$ - 0
		FF5488	FUEL FILTER - BB/WB/TB	100		0%	$ - 0	$ - 0
		WIX 33792	RACOR FILTER - BB/ WB/TB	152		0%	$ - 0	$ - 0
		VD 2000/S-85-N	SEAWATER STRAINER	200		0%	$ - 0	$ - 0
		3401544/LF 9009	LUBE OIL FILTER - WB	24		0%	$ - 0	$ - 0
		3924540	AIR FILTER	80		0%	$ - 0	$ - 0
		3008400	HYDRAULIC RAW WATER PUMP GASKET	30		0%	$ - 0	$ - 0
	ENGINES	WORKBOAT ENGINE		1		0%	$ - 0	$ - 0
		Engine Model	QSL9-SW
		Power Rating	286 BHP 213 kWm
		Rated Speed	1800 RPM
		Rating Type:	Continuous
		Emissions	EPA3/EU3a/IMO2
		BARRIER BOAT ENGINE		1		0%	$ - 0	$ - 0
		Engine Model	QSM11-SW
		Power Rating	448 bhp 334 kWm
		Rated Speed	2100 RPM
		Rating Type:	Medium Continuous
		Emissions	EPA3/EU3a/IMO2
		TOURBOAT ENGINE		2		0%	$ - 0	$ - 0
		Engine Model	QSB 5.9 T2 M 380@3000 HO F
		ReCon DR#	DR6496RX
		ReCon Core#	DR6496D
		Rated HP:	230
		Rated Speed:	3000
		Duty Cycle:	HO
		TOTAL EVALUATED PRICE						$ - 0

File details come from the government source that posted it. Updated Dec 15, 2021.