SV0105-20 - ATTACHMENT 1 - PRICING SHEET.xlsx

XLSX spreadsheet 26 KB Posted Dec 6, 2019

Attached to: FILTER PROGRM
Solicitation number: SV0105-20
Issued by: Department of Justice Bureau of Prisons Correctional Facilities

View the file

Other files

File	Type	Posted
SV0105-20 - updated 12-09-19.pdf	PDF	Dec 9, 2019
AMEND 1 - SV0105-20 12-9-19.doc.pdf	PDF	Dec 9, 2019
SV0105-20.PDF	PDF	Dec 6, 2019
Business Mgmt Quest. - SV0105-20.doc	DOC document	Dec 6, 2019

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.

Sheet1

ATTACHMENT #1

Solicitation #SV0105-20 Consignment

The below parts must be included in the offeror proposal for consignment:

Note: Offeror proposal will not be accepted if proposals does not include; filter part #, size,

description, quantity, unit price, extended price, unit of measure, total of each line item and grand total.

Metal Wire
Filter Part #	Size	Description	Quantity	U/M	Price	Total
FIL2002009	18 7/8" X 1800'
FIL2002011	22 3/4" X 1800'
FIL2002012	23 7/8 X 1800'

Media
Filter Part #	Size
FIL1002209	19 3/4 x 3600
FIL1002212	23 1/2 x 3600
FIL1002213	24.625 x 3600

		1” Die-Cuts
Filter Part #	Size		Description	Quantity	U/M	Price	Total
FIL5002012	12x24x1
FIL5002025	16x20
FIL5002028	16x25
FIL5002035	20x20
FIL5002038	20x25
FIL5002042	24x24

		2"Die-Cuts
Filter Part #	Size		Description	Quantity	U/M	Price	Total
FIL5002104	12X24X2
FIL5002110	16x20
FIL5002054	16x24
FIL5002122	16x25
FIL5002116	20x20
FIL5002117	20X24
FIL5002123	20x25
FIL5002169	24x24(BOT)
FIL5002119	24x24(TOP)

4"Die-Cuts
Filter Part #	Size	Description	Quantity	U/M	Price	Total
FIL5002301	16x20(BOT)
FIL5002584	16x20(TOP) S/C
FIL5002593	16x20(TOP) H/C
FIL5002302	16x25(BOT)
FIL5002585	16x25(TOP) S/C
FIL5002594	16x25(TOP) H/C
FIL5002304	20x20(BOT)
FIL5002587	20x20(TOP) S/C
FIL5002596	20X20(TOP)H/C
FIL5002305	20X24(BOT)
FIL5002588	20X24(TOP) S/C
FIL5002597	20x24(TOP) H/C
FIL5002306	20x25(BOT)
FIL5002589	20x25(TOP) S/C
FIL5002598	20x25(TOP) H/C
FIL5002307	24x24(BOT)
FIL5002581	24x24(TOP) S/C
FIL5002293	24x24(TOP) H/C
Carton

Filter Part #	Size	Description	Quantity	U/M	Price	Total
FIL4001040	20x24x2
FIL4001047	25x25x2
FIL4002003	12x24x2
FIL4002008	20x25x1
FIL4002009	20x20x1
FIL4002010	16x25x1
FIL4002011	16x20x1
FIL4002012	24x24x1
FIL4002013	20x25x2
FIL4002014	20x20x2
FIL4002015	16x25x2
FIL4002016	16x20x2
FIL4002017	24x24x2

Consignment Raw Materials

Vendor PartNum	Material	Safety Stock	EOQ	Unit	Net Price	Dimensions	Depth	Description	Material Type	Target	Actual	New 5yr Target
FIL4002010	PAC6701	600	300	EA	0.135136	16x25	1	Box	Box	15,000	14,960	26,000
FIL4002008	PAC1699	600	300	EA	0.1533534	20x25	1	Box	Box	25,500	25,202	44,000
FIL4002003	PAC6725	600	300	EA	0.261723	12x24	2	Box	Box	10,000	8,202	15,000
FIL4002016	PAC6706	600	300	EA	0.171598	16x20	2	Box	Box	20,600	15,150	27,000
FIL4002015	PAC6705	600	300	EA	0.194052	16x25	2	Box	Box	14,000	13,260	23,000
FIL4002014	PAC6704	600	300	EA	0.20909	20x20	2	Box	Box	17,900	17,726	31,000
FIL4002013	PAC6713	600	300	EA	0.241535	20x25	2	Box	Box	31,000	30,750	53,000
FIL4002017	PAC6707	600	300	EA	0.27913	24x24	2	Box	Box	24,200	23,444	41,000
FIL5002012	FIL5002012	1,500	1,500	EA	0.5521	12x24	1		Die-Cut	100,000	54,000	93,000
FIL5002025	DCL9107	4,000	2,000	EA	0.484	16x20	1		Die-Cut	300,000	108,000	186,000
FIL5002028	DCL9108	4,000	2,000	EA	0.5807	16x25	1		Die-Cut	300,000	96,000	166,000
FIL5002035	DCL9109	6,000	2,000	EA	0.613	20x20	1		Die-Cut	500,000	204,000	350,000
FIL5002038	DCL9110	4,000	1,000	EA	0.613	20x25	1		Die-Cut	100,000	53,000	91,000
FIL5002042	DCL9111	4,000	2,000	EA	0.449	24x24	1	2 EA	Die-Cut	500,000	106,000	182,000
FIL5002104	DCL0339	1,500	1,000	EA	0.6264	12x24	2	T&B	Die-Cut	111,500	56,500	98,000
	DCL9205	500	1,000	EA	0.795	15x20	2		Die-Cut	15,000	9,000	16,000
FIL5002110	DCL9112	4,500	1,500	EA	0.5484	16x20	2		Die-Cut	500,000	154,500	266,000
FIL5002054	DCL9207	1,000	1,500	EA	0.7831	16x24	2	T&B	Die-Cut	50,000	19,500	35,000
FIL5002122	DCL9113	4,500	1,500	EA	0.6667	16x25	2		Die-Cut	500,000	121,500	209,000
	DCL9126	500	3,000	EA	0.8612	18x24	2	T&B	Die-Cut	20,000	13,500	26,000
	DCL9203	250	500	EA	0.53	18x25	2	BOT	Die-Cut	5,000	1,500	3,000
	DCL9202	250	500	EA	0.53	18x25	2	TOP	Die-Cut	5,000	2,000	4,000
FIL5002116	DCL9114	4,500	1,500	EA	0.5484	20x20	2		Die-Cut	500,000	160,500	276,000
FIL5002117	DCL0338	1,500	1,500	EA	0.7743	20x24	2	T&B	Die-Cut	500,000	105,000	180,000
FIL5002123	DCL9115	4,000	2,000	EA	0.742	20x25	2		Die-Cut	500,000	159,500	274,000
FIL5002169	DCL9116	3,000	3,000	EA	0.4301	24x24	2	BOT	Die-Cut	500,000	183,000	315,000
FIL5002119	DCL8000	3,000	1,500	EA	0.4301	24x24	2	TOP	Die-Cut	500,000	184,500	317,000
	DCL9211	500	500	EA	0.6252	25x25	2	BOT	Die-Cut	10,000	2,000	4,000
	DCL9210	500	500	EA	0.6783	25x25	2	TOP	Die-Cut	10,000	2,000	4,000
FIL5002301	DCL8001	500	500	EA	0.5349	16x20	4	BOT	Die-Cut	50,000	14,000	24,000
FIL5002593	DCL0342	500	500	EA	0.7969	16x20	4	TOP HC	Die-Cut	14,000	2,000	4,000
FIL5002584	DCL9118	500	500	EA	0.5896	16x20	4	TOP SC	Die-Cut	50,000	11,000	19,000
FIL5002302	DCL9122	500	500	EA	0.6042	16x25	4	BOT	Die-Cut	30,000	11,000	19,000
FIL5002594	DCL0340	500	500	EA	0.720588	16x25	4	TOP HC	Die-Cut	10,000	2,500	5,000
FIL5002585	DCL9119	500	500	EA	0.6768	16x25	4	TOP SC	Die-Cut	30,000	8,500	15,000
	DCL9128	500	500	EA	0.6042	18x24	4	BOT	Die-Cut	10,000	6,500	12,000
	DCL9127	500	500	EA	0.742	18x24	4	TOP HC	Die-Cut	10,000	5,000	9,000
	DCL9129	500	500	EA	0.6677	18x24	4	TOP SC	Die-Cut	5,000	1,500	3,000
FIL5002304	DCL9123	1,000	500	EA	0.578654	20x20	4	BOT	Die-Cut	25,000	24,500	42,000
FIL5002596	DCL0341	1,000	500	EA	0.742012	20x20	4	TOP HC	Die-Cut	13,000	13,000	23,000
FIL5002587	DCL9120	1,000	500	EA	0.622326	20x20	4	TOP SC	Die-Cut	50,000	11,500	20,000
FIL5002305	FIL5002305	500	500	EA	0.688967	20x24	4	BOT	Die-Cut	50,000	7,500	13,000
FIL5002597	FIL5002597	500	500	EA	0.851604	20x24	4	TOP HC	Die-Cut	10,000	2,500	5,000
FIL5002588	FIL5002588	500	500	EA	0.936373	20x24	4	TOP SC	Die-Cut	50,000	5,500	10,000
FIL5002306	DCL9124	500	1,500	EA	0.654977	20x25	4	BOT	Die-Cut	30,000	22,500	39,000
FIL5002598	DCL0344	500	500	EA	0.742424	20x25	4	TOP HC	Die-Cut	50,000	5,000	9,000
FIL5002589	DCL9121	500	1,500	EA	0.742424	20x25	4	TOP SC	Die-Cut	20,000	19,500	35,000
FIL5002307	DCL9125	500	1,500	EA	0.687216	24x24	4	BOT	Die-Cut	51,000	51,000	89,000
FIL5002293	DCL0343	500	1,500	EA	0.840583	24x24	4	TOP HC	Die-Cut	40,000	37,500	65,000
FIL5002581	DCL9117	500	1,500	EA	0.796911	24x24	4	TOP SC	Die-Cut	15,000	13,000	24,000
FIL2002009	SHS2051	90,000	259,200	FT	0.0743	20	1800'	Expanded Metal	Expanded Metal	10,000,000	2,883,600	4,958,000
FIL2002011	SHS2052	90,000	324,000	FT	0.0923	24	1800'	Expanded Metal	Expanded Metal	10,000,000	3,402,000	5,994,000
FIL2002012	SHS2053	90,000	259,200	FT	0.0942	25	1800'	Expanded Metal	Expanded Metal	10,000,000	2,138,400	3,694,000
	FIL1002131		2,600	FT	0.4202	20	2600'	MERV-13	Media	25,000	13,000	24,000
	FIL1002132		2,600	FT	0.4997	24	2600'	MERV-13	Media	35,000	31,200	55,000
	FIL1002133		2,600	FT	0.5273	25	2600'	MERV-13	Media	20,000	13,000	24,000
	FIL1002127		3,600	FT	0.1852	20	3600'	MERV-11	Media	50,500	28,800	51,000
FIL1002209	FIL9126	90,000	122,400	FT	0.0947	20	3600'	MERV-7	Media	10,000,000	2,951,960	5,156,000
	FIL1002128		3,600	FT	0.2161	24	3600'	MERV-11	Media	100,000	68,400	119,000
FIL1002212	FIL9127	90,000	144,000	FT	0.0953	24	3600'	MERV-7	Media	10,000,000	3,488,376	6,081,000
	FIL1002129		3,600	FT	0.2388	25	3600'	MERV-11	Media	30,000	14,400	26,000
FIL1002213	FIL9128	90,000	93,600	FT	0.1059	25	3600'	MERV-7	Media	10,000,000	2,228,067	3,913,000

&"-,Bold"&18TEFL Consignment Inventory

Page &P of &N

Order History

Contract Item #	Material	Target	Actual
1	SHS2051	10,000,000	2,883,600
2	SHS2052	10,000,000	3,402,000
3	SHS2053	10,000,000	2,138,400
4	FIL9126	10,000,000	2,951,960
5	FIL9127	10,000,000	3,488,376
6	FIL9128	10,000,000	2,228,067
7	FIL5002012	100,000	54,000
8	DCL9107	300,000	108,000
9	DCL9108	300,000	96,000
10	DCL9109	500,000	204,000
11	DCL9111	500,000	106,000
12	DCL0339	111,500	56,500
13	DCL9112	500,000	154,500
14	DCL9207	50,000	19,500
15	DCL9113	500,000	121,500
16	DCL9114	500,000	160,500
17	DCL0338	500,000	105,000
18	DCL9115	500,000	159,500
19	DCL9116	500,000	183,000
20	DCL8000	500,000	184,500
21	DCL8001	50,000	14,000
22	DCL9118	50,000	11,000
23	DCL0342	14,000	2,000
24	DCL9122	30,000	11,000
25	DCL9119	30,000	8,500
36	DCL9110	100,000	53,000
39	DCL9126	20,000	13,500
40	DCL9202	5,000	2,000
41	DCL9203	5,000	1,500
42	DCL9205	15,000	9,000
43	DCL9210	10,000	2,000
44	DCL9211	10,000	2,000
45	DCL9127	10,000	5,000
46	DCL9128	10,000	6,500
47	DCL9129	5,000	1,500
48	FIL1002127	50,500	28,800
49	FIL1002128	100,000	68,400
50	FIL1002129	30,000	14,400
51	FIL1002131	25,000	13,000
52	FIL1002132	35,000	31,200
53	FIL1002133	20,000	13,000
116	PAC6725	10,000	8,202
117	PAC1699	25,500	25,202
118	PAC6701	15,000	14,960
119	PAC6713	31,000	30,750
120	PAC6704	17,900	17,726
121	PAC6705	14,000	13,260
122	PAC6706	20,600	15,150
123	PAC6707	24,200	23,444
137	DCL9121	20,000	19,500
138	DCL9123	25,000	24,500
139	DCL9124	30,000	22,500
140	DCL0341	13,000	13,000
141	DCL0343	40,000	37,500
142	DCL9125	51,000	51,000
167	DCL9117	15,000	13,000
220	FIL5002305	50,000	7,500
221	DCL9120	50,000	11,500
222	DCL0344	50,000	5,000
223	FIL5002588	50,000	5,500
286	FIL5002597	10,000	2,500
287	DCL0340	10,000	2,500

File details come from the government source that posted it. Updated Dec 6, 2019.