RFQ_23-251_Attachment_A_-_Cost_Worksheet.xlsm

XLSM spreadsheet 60 KB Posted May 3, 2024

Attached to: RFQ 23-251 Labatory equipment - Gas Chromatograph Units
Solicitation number: 0000031264
Issued by: California

About this file

Written by GovTribe AI · May 16, 2024

This document is a Cost Worksheet from the California Department of Justice (DOJ) for RFQ 23-251, a solicitation for Agilent 8890 Gas Chromatograph (GC) units or equivalent. The solicitation is for 16 GC units to be delivered to 10 different shipping locations across California. The contract term is for 5 years with optional renewal years. Bidders must provide pricing for all items, as partial quotes will not be accepted. The equipment must be new and the latest model in current production. Delivery and installation costs are included in the pricing. The Cost Worksheet provides detailed pricing for each location, including unit costs, quantities, and applicable sales tax rates ranging from 7.25% to 9.75%. The total grand cost across all locations is provided, broken down by taxable and non-taxable subtotals and total sales tax.

The pricing terms specify net 45 days for invoice payment. There are no indications of set-asides, incumbent contractors, or specific funding sources. The Cost Worksheet appears to be for evaluation purposes only, as the pricing is not finalized.

View the file

Other files

File	Type	Posted
RFQ_23-251.docx	DOCX document	May 3, 2024
RFQ_23-251_Attachment_M_-_SOW.pdf	PDF	May 3, 2024

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.

Cost Worksheet - General

California Department of Justice	Notes to Bidder:
Attachment A - Cost Worksheet	Quotation Award - For the purposes of this solicitation, bidders are required to provide pricing for all items. Partial quotes will not be accepted.
Solicitation #:
Term Date:	If your bid proposes an “equivalent” good(s) other than listed in this Cost Worksheet, please list the “equivalent” brand name(s) and provide specifications describing how the “equivalent” good(s) are equivalent.
Invoice Payment Terms:
Vendor Name:	All equipment to be provided in response to a State of California solicitation shall be new and latest model in current production. USED, SHOPWORN, DEMONSTRATOR, PROTOTYPE OR DISCONTINUED MODELS ARE NOT ACCEPTABLE.
Vendor Contact Name:
Date:	Optional Years are for evaluation purposes only.

		FY 22/23 - Year 1 Cost		FY 23/24 - Year 2 Cost		FY 24/25 - Year 3 Cost		FY 25/26 - Year 4 Cost		FY 26/27 - Year 5 Cost
		Committed Year		Committed Year		Optional Year		Optional Year		Optional Year
		7/1/2022 - 6/30/2023		7/1/2023 - 6/30/2024		7/1/2024 - 6/30/2025		7/1/2025 - 6/30/2026		7/1/2026 - 6/30/2027
GRAND TOTAL		Tax Rate	0.00%	Tax Rate	8.75%	Tax Rate	8.75%	Tax Rate	8.75%	Tax Rate	8.75%
Non-Taxable Subtotal	$ - 0	Non-Taxable Subtotal	$ - 0	Non-Taxable Subtotal	$ - 0	Non-Taxable Subtotal	$ - 0	Non-Taxable Subtotal	$ - 0	Non-Taxable Subtotal	$ - 0
Taxable Subtotal	$ - 0	Taxable Subtotal	$ - 0	Taxable Subtotal	$ - 0	Taxable Subtotal	$ - 0	Taxable Subtotal	$ - 0	Taxable Subtotal	$ - 0
Sales Tax	$ - 0	Sales Tax	$ - 0	Sales Tax	$ - 0	Sales Tax	$ - 0	Sales Tax	$ - 0	Sales Tax	$ - 0
YEAR 1 TOTAL	$ - 0	YEAR 1 TOTAL	$ - 0	YEAR 2 TOTAL	$ - 0	YEAR 3 TOTAL	$ - 0	YEAR 4 TOTAL	$ - 0	YEAR 5 TOTAL	$ - 0

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Taxable?
(Y/N)	TOTAL	Year 1 Unit Cost	Year 1 Extended Cost	Year 2 Unit Cost	Year 2 Extended Cost	Year 3 Unit Cost	Year 3 Extended Cost	Year 4 Unit Cost	Year 4 Extended Cost	Year 5 Unit Cost	Year 5 Extended Cost
	1						$ - 0		$ - 0		$ - 0	$ - 0	$ - 0	$ - 0
	2						$ - 0		$ - 0		$ - 0	$ - 0	$ - 0	$ - 0
	3						$ - 0		$ - 0		$ - 0	$ - 0	$ - 0	$ - 0
	4						$ - 0		$ - 0		$ - 0	$ - 0	$ - 0	$ - 0
	5						$ - 0		$ - 0		$ - 0	$ - 0	$ - 0	$ - 0

Cost Worksheet - Hardware Only

California Department of Justice		Notes to Bidder:
Attachment A - Cost Worksheet		Quotation Award - For the purposes of this solicitation, bidders are required to provide pricing for all items. Partial quotes will not be accepted.
Solicitation #:	RFQ 23-251
Term Date:	N/A	If your bid proposes an “equivalent” good(s) other than listed in this Cost Worksheet, please list the “equivalent” brand name(s) and provide specifications describing how the “equivalent” good(s) are equivalent.
Invoice Payment Terms:	Net 45
Vendor Name:
Vendor Contact Name:		All equipment to be provided in response to a State of California solicitation shall be new and latest model in current production. USED, SHOPWORN, DEMONSTRATOR, PROTOTYPE OR DISCONTINUED MODELS ARE NOT ACCEPTABLE.
Date:

Optional Years are for evaluation purposes only.

RFQ is for 16 GC's. Cost worksheet is broken down for 10 shipping locations.

GRAND TOTAL
Non-Taxable Subtotal	$ - 0
Taxable Subtotal	$ - 0
Sales Tax Rate	Various
Sales Tax	$ - 0
Grand Total	$ - 0

Location 1: BFS Central Valley 1306 Hughes Lane, Ripon, CA 95366

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	1	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	3		Y	$ - 0
	2	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	6	N	$ - 0
	3	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	3	Y	$ - 0
	4	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	3	Y	$ - 0
	5	EA	X-fer Insulation (or equivalent)	G1099-20301	3	Y	$ - 0
	6	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	3	Y	$ - 0
	7	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	7.750%
						Sales Tax	$ - 0
						Total Location 1	$ - 0
	Location 2:		BFS Chico

3870 Morrow Lane, Suite A, Chico, CA 95928

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	8	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	1		Y	$ - 0
	9	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	2	N	$ - 0
	10	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	1	Y	$ - 0
	11	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	1	Y	$ - 0
	12	EA	X-fer Insulation (or equivalent)	G1099-20301	1	Y	$ - 0
	13	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	1	Y	$ - 0
	14	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	8.250%
						Sales Tax	$ - 0
						Total Location 2	$ - 0
	Location 3:		BFS Eureka

1011 West Wabash, Eureka, CA 95501

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	15	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	1		Y	$ - 0
	16	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	2	N	$ - 0
	17	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	1	Y	$ - 0
	18	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	1	Y	$ - 0
	19	EA	X-fer Insulation (or equivalent)	G1099-20301	1	Y	$ - 0
	20	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	1	Y	$ - 0
	21	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	9.250%
						Sales Tax	$ - 0
						Total Location 3	$ - 0
	Location 4:		BFS Freedom

440 Airport Blvd, Building A, Watsonville, CA 95076

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	22	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	1		Y	$ - 0
	23	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	2	N	$ - 0
	24	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	1	Y	$ - 0
	25	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	1	Y	$ - 0
	26	EA	X-fer Insulation (or equivalent)	G1099-20301	1	Y	$ - 0
	27	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	1	Y	$ - 0
	28	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	9.750%
						Sales Tax	$ - 0
						Total Location 4	$ - 0
	Location 5:		BFS Fresno

5311 N. Woodrow Ave, Fresno, CA 93740

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	29	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	2		Y	$ - 0
	30	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	4	N	$ - 0
	31	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	2	Y	$ - 0
	32	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	2	Y	$ - 0
	33	EA	X-fer Insulation (or equivalent)	G1099-20301	2	Y	$ - 0
	34	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	2	Y	$ - 0
	35	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	8.350%
						Sales Tax	$ - 0
						Total Location 5	$ - 0
	Location 6:		BFS Redding

9737 Tanqueray Court, Redding, CA 96003

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	36	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	1		Y	$ - 0
	37	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	2	N	$ - 0
	38	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	1	Y	$ - 0
	39	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	1	Y	$ - 0
	40	EA	X-fer Insulation (or equivalent)	G1099-20301	1	Y	$ - 0
	41	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	1	Y	$ - 0
	42	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	7.250%
						Sales Tax	$ - 0
						Total Location 6	$ - 0
	Location 7:		BFS Riverside

7425 Mission Blvd., Riverside, CA 92509

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	43	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	1		Y	$ - 0
	44	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	2	N	$ - 0
	45	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	1	Y	$ - 0
	46	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	1	Y	$ - 0
	47	EA	X-fer Insulation (or equivalent)	G1099-20301	1	Y	$ - 0
	48	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	1	Y	$ - 0
	49	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	7.750%
						Sales Tax	$ - 0
						Total Location 7	$ - 0
	Location 8:		BFS Sacramento

4949 Broadway, F-201, Sacramento, CA 95820

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	50	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	3		Y	$ - 0
	51	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	6	N	$ - 0
	52	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	3	Y	$ - 0
	53	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	3	Y	$ - 0
	54	EA	X-fer Insulation (or equivalent)	G1099-20301	3	Y	$ - 0
	55	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	3	Y	$ - 0
	56	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	8.750%
						Sales Tax	$ - 0
						Total Location 8	$ - 0
	Location 9:		BFS Santa Barbara

155 David Love Place, Goleta, CA 93117

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	57	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	1		Y	$ - 0
	58	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	2	N	$ - 0
	59	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	1	Y	$ - 0
	60	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	1	Y	$ - 0
	61	EA	X-fer Insulation (or equivalent)	G1099-20301	1	Y	$ - 0
	62	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	1	Y	$ - 0
	63	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	8.750%
						Sales Tax	$ - 0
						Total Location 9	$ - 0
	Location 10:		BFS Santa Rosa

410 Russell Ave., Santa Rosa, CA 95403

	Item #	Unit of Measure	Product Description	Product Number	Quantity	Unit Price	Taxable?
(Y/N)	Extended Price
	64	EA	Agilent 8890 GC System custom (or equivalent)

• Ship-to Country: USA

• Country of Origin: United States

• INERT Cap S/SI inlet with EPC - 100psi

• MSD Interface

• Factory plumbing For quick installation

• Exhaust Deflector Assy

• Installation (44K)

• Introduction (44L)	G3540A	2		Y	$ - 0
	65	EA	Supplemental Installation One Hour Labor for Chemical Analysis products (or equivalent)	H5949A	4	N	$ - 0
	66	EA	5977B Transfer Line Assy - HE Support (or equivalent)	G7077-67300	2	Y	$ - 0
	67	EA	O-Ring 29.87x1.78 FKM 75A BRN (or equivalent)	0905-1405	2	Y	$ - 0
	68	EA	X-fer Insulation (or equivalent)	G1099-20301	2	Y	$ - 0
	69	EA	Xferline Cup, 75 EI / CI (or equivalent)	G3170-00405	2	Y	$ - 0
	70	EA	Shipping & Handling	N/A	1	Y	$ - 0
						Non-Taxable Subtotal	$ - 0
						Taxable Subtotal	$ - 0
						Sales Tax Rate	9.250%
						Sales Tax	$ - 0
						Total Location 10	$ - 0

DOJ USE ONLY

FOR DOJ USE ONLY
FY	PO	Cost Code	Object Code	Cost	Sum of Cost	Column Labels
21/22	Original	860	4352	500		505	505 Total	735	735 Total	860		860 Total	861	861 Total	Grand Total
21/22	Amendment #1	860	4451	1000	Row Labels	4457		4455		4352	4451		4455
22/23		735	4455	10000	21/22					500	1000	1500			1500
22/23		861	4455	15000	22/23			10000	10000				15000	15000	25000
23/24		505	4457	1000	23/24	1000	1000			12000		12000			13000
23/24		860	4352	12000	Grand Total	1000	1000	10000	10000	12500	1000	13500	15000	15000	39500
21/22		860	4352

List

Invoice Payment Terms

Full Payment Upfront

Monthly In Arrears

Quaterly In Arrears

Annually In Arrears

Deliverables-Based

Time & Materials-Based

File details come from the government source that posted it. Updated May 16, 2024.