Attachment 12_BA SUMMARY_11-R-0007.xlsx

XLSX spreadsheet 21 KB Posted Apr 20, 2011

Attached to: Removal, transportation, and disposal of hazardous waste from Barstow and surrounding locations
Solicitation number: SP4500-11-R-0007
Issued by: Defense Logistics Agency Disposition Services

About this file

From the source

Attachment 12 BA Summary

View the file

Other files

File	Type	Posted
SP4500-11-R-0007-05.pdf	PDF	Jun 16, 2011
Bid Schedule_SP4500-11-R-0007_Amendment 5.xlsx	XLSX spreadsheet	Jun 16, 2011
SP4500-11-R-0007-04.pdf	PDF	Jun 2, 2011
SP4500-11-R-0007-03.pdf	PDF	May 26, 2011
SP4500-11-R-0007-02.pdf	PDF	May 19, 2011
SP4500-11-R-0007-01.pdf	PDF	Apr 28, 2011
Attachment 11_AF SUMMARY_11-R-0007.xlsx	XLSX spreadsheet	Apr 20, 2011
Attachment 10_AF GRAND TOTAL_11-R-0007.xlsx	XLSX spreadsheet	Apr 20, 2011
SP4500-11-R-0007.pdf	PDF	Apr 20, 2011
Bid Schedule_SP4500-11-R-0007.xlsx	XLSX spreadsheet	Apr 20, 2011

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.

BA SUMMARY

Environmental Reporting System - 10-NOV-10 02.20.54 PM BA 6 Character HIN Summary Report DO Issue Date Range Begin : '01-JAN-2004' to End : '10-NOV-2010' Contract # : 'SP450007D0005' Generator DODAAC : '%'
HIN	OBL QUANTITY	PU QUANTITY	UM	COST	AVG. COST/UNIT	DESCRIPTION
081200	83	83	EA	4565	55	INERT-SMALL
0812TW	5	5	EA	325	65	Compressed Gas Cylinders (inert) Small Cylinder, Thin wall
081300	22	14	EA	1870	85	INERT - MEDIUM
081400	1	1	EA	95	95	INERT - LARGE
082400	1	1	EA	250	250	OXIDIZER - LARGE
083200	2	0	EA	1300	650	SILANE/PYROPHORIC - SMALL
083300	1	0	EA	1100	1100	SILANE/PYROPHORIC - MEDIUM
083400	2	2	EA	3500	1750	SILANE/PYROPHORIC - LARGE
084200	5	5	EA	3250	650	TOXIC - SMALL
087200	156	122	EA	7800	50	CYLINDER- SMALL
0872AC	1	1	EA	150	150	Small cylinder, acetylene w/asbestos lining
0872TW	28	28	EA	3500	125	Compressed Gas Cylinder (Flammable) Small cylinder thin wall
087300	10	8	EA	1500	150	CYLINDER - MEDIUM
632100	32	32	EA	8000	250	PROVIDE AND PREPARE LAB PACKS, CONSISTING OF SMALL QUANTITY ITEMS (55 gl)
632200	14	14	EA	2800	200	PROVIDE AND PREPARE LAB PACKS, CONSISTING OF SMALL QUANTITY ITEMS (20-30 gl)
632300	103	103	EA	15450	150	PROVIDE AND PREPARE LAB PACKS, CONSISTING OF SMALL QUANTITY ITEMS (5-15 gl)
633000	6	6	EA	600	100	EXPEDITED REMOVAL - 15 DAYS
633100	22	22	EA	3300	150	EXPEDITED REMOVAL - 10 DAYS
633200	17	17	EA	3400	200	EXPEDITED REMOVAL - 7 DAYS
633300	38	38	EA	11400	300	EXPEDITED REMOVAL - 5 DAYS
633400	17	12	EA	6800	400	EXPEDITED REMOVAL - 3 DAYS
633500	16	16	EA	12000	750	EXPEDITED REMOVAL - 1 DAY
634000	4	4	EA	600	150	EXPEDITED PERFORMANCE - 15 DAYS
634100	7	7	EA	1750	250	EXPEDITED PERFORMANCE - 10 DAYS
634200	22	22	EA	6600	300	EXPEDITED PERFORMANCE - 7 DAYS
634300	7	7	EA	2450	350	EXPEDITED PERFORMANCE - 5 DAYS
634400	6	6	EA	2400	400	EXPEDITED PERFORMANCE - 3 DAYS
634500	8	8	EA	6000	750	Expedited performance, 01 day
635000	22	22	EA	11000	500	TANK CLEANING/SERVICES - (ABOVE GROUND) MOBILIZATION COST
635100	11	11	EA	9350	850	TANK CLEANING/SERVICES - (BELOW GROUND) MOBILIZATION COST
635500	3	3	EA	1500	500	TANK CLEANING/SERVICES - (OTHER) MOBILIZATION COST
635600	11	11	EA	2750	250	TANK CLEANING/SERVICES - ADDITIONAL MOVILIZATION COST FOR CONFINED ENTRY
636000	80	80	HR	4400	55	PERSONNEL FOR CLEANING/SERVICING OF TANKS, TOTES, OIL/WATER SEPARATORS - TEAM LEADER
636100	173	173	HR	6055	35	PERSONNEL FOR CLEANING/SERVICING OF TANKS, TOTES, OIL/WATER SEPARATORS - TECHNICIAN
637200	99	97	EA	44550	450	PROVIDE STORAGE CONTAINER (20 cy)
637500	35	34	EA	15750	450	PROVIDE STORAGE CONTAINER (40 cy)
6377BV	3	3	EA	6750	2250	Provide Storage Container. 20,000 gal. Baker Tank.
6377MC	2	2	EA	8006.64	4003.32	CONTRACTOR FURNISHED CONTAINERS
638200	29	29	EA	10150	350	RENTAL - STORAGE CONTAINERS (20 cy)
638500	14	14	EA	4900	350	RENTAL - STORAGE CONTAINERS (40 cy)
6387BV	34	34	EA	40800	1200	Rental - Storage Containers. 20,000 gal Baker Tank
6388DC	15	15	EA	1425	95	TRANSPORTATION
6388HR	343	327	HR	32585	95	Transportation charge (move container on govt' property)
6400TS	48	16	EA	36000	750	Perform unknown analysis (two-step) and prepare waste profile form.
640100	1	1	EA	250	250	PERFORM HAZARDOUS WASTE CHARACTERISTICS ANALYSIS TO DETERMINE IGNITABILITY (D001), CORROSIVITY (D002), REACTIVITY (D003)
640300	1	1	EA	300	300	PERFORM TCLP METALS ANALYSIS TO DETERMINE 8 TCLP METALS (D004-D011)
6403AA	11	11	EA	2750	250	MANAGEMENT SERVICES Analysis
641000	1	1	EA	2500	2500	PERFORM TESTING OF CYLINDERS
641100	4	4	EA	1600	400	PERFORM VOLATILE ORGANICS ANALYSIS
641700	1	1	EA	350	350	Test for semi-volatile organics as listed in 40 CFR 268, Apprndix III
642400	19	18	EA	2850	150	PERFORM POLYCHLORINATED BIPHENYL (PCB) ANALYSIS
642500	2	2	EA	700	350	PERFORM 96-HOUR BIOASSAY TEST
6500MM	67	67	LB	636.5	9.5	SURCHARGE FOR DISPOSAL OF HIGH LEVEL MERCURY
6509LL	145	145	HR	18125	125	Labor charges, general
6509LQ	110	110	HR	24750	225	Labor charges for equipment operator.
6509LS	104	104	HR	36400	350	labor charges for project management / supervision.
6509ME	8	8	EA	178970.2	22371.275	Equipment and Supplies Reimbursement
6509NL	347	347	HR	26025	75	Labor charges, general
6509NP	8	8	HR	1000	125	Labor charges for professional services
6509NQ	163	163	HR	15485	95	Labor charges for equipment operator
6509NS	201	201	HR	30150	150	Labor charges for project management/supervision
651200	25	23	EA	1375	55	Pumping charges from drums
651300	1	1	EA	2850	2850	Prepare biennial report
6609CL	7	7	EA	4165	595	Management Services
6609ED	40	40	HR	1000	25	Record created by rehost conversion
6610PA	1	1	EA	1500	1500	TRANSPORTATION COSTS FOR MOVEMENT OF MATERIAL
700000	6756	6756	LB	4391.4	0.65	ARTICLES (OTHER THAN TRANSFORMERS & CAPACITORS) 500-4999 PPM PCB
700200	280	258	LB	182	0.65	ARTICLES (OTHER THAN TRANSFORMERS & CAPACITORS) 50-499 PPM PCB
700600	17	17	LB	12.75	0.75	MIXED PCB ITEMS
700700	638	638	LB	478.5	0.75	TRANSFORMERS 500-4999 PPM PCB
701000	863	863	LB	474.65	0.55	TRANSFORMERS 50-499 PPM PCB
701200	2456	2456	LB	1105.2	0.45	TRANSFORMERS LESS THAN 50 PPM PCB
701400	142	142	LB	63.9	0.45	SMALL CAPACITORS 500-4999 PPM PCB
701800	571	571	LB	856.5	1.5	SMALL CAPACITORS 50-499 PPM PCB
702600	41	41	LB	51.25	1.25	SWEEPING COMPOUND, PCB CONTAMINATED
702800	1386	1386	LB	2079	1.5	DEBRIS (EXAMPLE: RAGS, CANS, DRUMS, WOOD) PCB CONTAMINATED
702900	120	120	LB	102	0.85	SOIL, PCB CONTAMINATED
703000	11	11	LB	10.45	0.95	LIQUID 500-4999 PPM PCB
703100	235	235	LB	223.25	0.95	LIQUID 50-499 PPM PCB
888800	1	1	EA	250	250	Request for Equitable Adjustment
90002N	3	3	EA	165	55	Non-bulk, anti-freeze, 21-30 gl
90002P	21	19	EA	1785	85	Non-bulk, anti-freeze, 31-55 gl
90003A	3	3	LB	2.55	0.85	Small containers
90003F	2	2	EA	190	95	Non-bulk liquids, 31-55 gl
90003G	1	1	EA	475	475	Bulk liquids, IBC tote, 1 cu yd box
90003H	132543	110697	LB	23857.74	0.18	Bulk liquids, pumpable
90005A	2727	2331	LB	681.75	0.25	Lead acid, wet (industrial)
90005B	541	541	LB	243.45	0.45	Lead acid, dry
90005C	903	813	LB	677.25	0.75	Ni-Cad, wet
90005D	998	939	LB	848.3	0.85	Ni-Cad, dry
90005E	937	937	LB	2483.05	2.65	Lithium
90005G	6	6	LB	57	9.5	Mercury
90005H	3538	3534	LB	6899.1	1.95	Zinc/Titanium, Alkaline
90006A	41	41	LB	266.5	6.5	Small Containers
90006B	5	5	EA	1375	275	Non-bulk, 5 gl
90006D	2	2	EA	1500	750	Non-bulk, 11-20 gl
90006F	3	3	EA	3600	1200	Non-bulk, 31-55 gl
90007A	1	1	EA	65	65	Non-bulk, Mercury vapor, 5 gl
90007E	7	7	EA	2275	325	Non-bulk, Mercury vapor 31-55 gl
90007G	69642	63673	FT	24374.7	0.35	Flourescent, linear feet
90009A	8264	8256	LB	6222.75	0.7529949177	Small Containers
90009B	8995	8392	LB	8545.25	0.95	Aerosols
90009C	160	159	EA	12000	75	Non-bulk, 5 gl
90009D	23	22	EA	2185	95	Non-bulk, 6-10 gl
90009E	52	47	EA	6500	125	Non-bulk, 11-20 gl
90009F	34	32	EA	5950	175	Non-bulk, 21-30 gl
90009G	175	172	EA	43750	250	Non-bulk, 31-55 gl
90009H	22	22	EA	11220	510	Bulk liquids, IBC tote, pallet box
90010A	54	54	LB	81	1.5	Small containers
90010B	4	4	EA	220	55	Non-bulk liquids, 5 gl
90010C	1	1	EA	65	65	Non-bulk liquids, 6-10 gl
90010E	2	2	EA	390	195	Non-bulk liquids, 21-30 gl
90010F	9	9	EA	2475	275	Non-bulk liquids, 31-55 gl
90011B	1	1	EA	65	65	Non-bulk liquids, 5 gl
90011F	157	155	EA	19625	125	Non-bulk liquids, 31-55 gl
90011G	10	10	EA	4750	475	Bulk liquids, IBC tote
90011H	601645	601645	LB	90246.75	0.15	Bulk liquids, pumpable
90012A	225	225	LB	146.9	0.6528888889	Small containers
90012B	7	7	EA	455	65	Non-bulk solids, 5 gl
90012C	4	4	EA	260	65	Non-bulk solids, 6-10 gl
90012D	2	2	EA	130	65	Non-bulk solids, 11-20 gl
90012E	4	4	EA	260	65	Non-bulk solids, 21-30 gl
90012F	15	14	EA	1050	70	Non-bulk solids, 31-55 gl
90012G	26	26	EA	4550	175	Bulk solids, IBC tote, pallet, box
90012H	407	407	CY	34595	85	Bulk solids, debris
90012J	8271690	8271690	LB	827169	0.1	Bulk solids
90013A	181	181	LB	226.25	1.25	Small containers
90013B	7	7	EA	455	65	Non-bulk solids/liquids, 5 gl
90013C	2	2	EA	150	75	Non-bulk solids/liquids, 6-10 gl
90013D	3	3	EA	255	85	Non-bulk solids/liquids, 11-20 gl
90013E	1	1	EA	95	95	Non-bulk solids/liquids, 21-30 gl
90013F	23	23	EA	2875	125	Non-bulk solids/liquids, 31-55 gl
90013G	17	17	EA	4250	250	Bulk solids/liquids, IBC tote, pallet, box
90013J	8540	8540	LB	2135	0.25	Bulk solids
90014C	2	2	EA	370	185	Non-bulk solids, 6-10 gl
90014F	9	9	EA	2025	225	Non-bulk solids, 31-55 gl
90014G	12	9	EA	3000	250	Bulk solids, IBC tote, pallet, box
90014H	212	212	CY	27560	130	Bulk solids, debris
90015A	708	708	LB	1770	2.5	Hydrazine (non-bulk incineration)
90015C	7172	7172	LB	17930	2.5	Aluminum Powder (non-bulk incineration)
90015E	1	1	LB	8.5	8.5	TEMPERATURE CONTROLLED SUBSTANCES
90015F	1	1	EA	650	650	F027 Waste
910100	46016	42062	LB	29911.95	0.6500336839	IGNITABLE - SMALL CONTAINERS
910200	51667	48330	LB	28416.85	0.55	IGNITABLE - CONTAINERIZED LIQUIDS/MULTI-PHASE
9102RR	78143	73892	LB	31257.2	0.4	IGNITABLE - CONTAINERIZED LIQUIDS/MULTI-PHASE -- MANDATORY RECYCLING/fuels blending
910400	3332	3332	LB	8330	2.5	IGNITABLE - CONTAINERIZED SOLIDS
910500	288	288	LB	244.8	0.85	IGNITABLE - AEROSOLS
9106RR	81640	81640	LB	20410	0.25	IGNITABLE - BULK LIQUIDS (PUMPABLE) -- MANDATORY RECYCLING
920100	2382	2382	LB	3573	1.5	CORROSIVE - SMALL CONTAINERS
920200	18230	17014	LB	10026.5	0.55	CORROSIVE - CONTAINERIZED LIQUIDS/MULTI-PHASE
9204LA	11749	11749	LB	3524.7	0.3	CORROSIVE - CONTAINERIZED SOLIDS
920600	335574	335574	LB	83893.5	0.25	CORROSIVE - BULK LIQUIDS (PUMPABLE)
930100	93	92	LB	790.5	8.5	REACTIVE - SMALL CONTAINERS
930200	18	18	LB	58.5	3.25	REACTIVE - CONTAINERIZED LIQUIDS/MULTI-PHASE
930400	557	281	LB	529.15	0.95	REACTIVE - CONTAINERIZED SOLIDS
930500	16	16	LB	104	6.5	REACTIVE - AEROSOLS
940100	458	447	LB	435.1	0.95	TOXICITY - SMALL CONTAINERS
9401MM	57	53	LB	712.5	12.5	TOXICITY - SMALL CONTAINERS WITH MERCURY/MERCURY COMPOUNDS
940200	301860	279807	LB	120744	0.4	TOXICITY - CONTAINERIZED LIQUIDS/MULTI-PHASE
940400	134754	108233	LB	87590.1	0.65	TOXICITY - CONTAINERIZED SOLIDS
9404BB	90742	86033	LB	9074.2	0.1	TOXICITY - CONTAINERIZED SOLIDS
9404FL	1016	1016	LB	762	0.75	TOXICITY - CONTAINERIZED SOLIDS
9404MG	50	50	LB	175	3.5	TOXICITY - CONTAINERIZED SOLIDS
940600	17080	17080	LB	3074.4	0.18	TOXICITY - BULK LIQUIDS (PUMPABLE)
940700	3020	3020	LB	453	0.15	TOXICITY - BULK SOLIDS
9407DB	35640	35640	LB	12114.4	0.3399102132	TOXICITY - BULK SOLIDS
950100	38602	33844	LB	36671.9	0.95	SOLVENT - SMALL CONTAINERS
950200	13937	13097	LB	6968.5	0.5	SOLVENT - CONTAINERIZED LIQUIDS/MULTI-PHASE
9502RR	23275	18889	LB	12801.25	0.55	SOLVENT - CONTAINERIZED LIQUIDS/MULTI-PHASE -- MANDATORY RECYCLING
950400	41738	39468	LB	27129.7	0.65	SOLVENT - CONTAINERIZED SOLIDS
970100	10	10	LB	65	6.5	P-LISTED - SMALL CONTAINERS
970200	205	205	LB	512.5	2.5	P-LISTED - CONTAINERIZED LIQUIDS/MULTI-PHASE
970400	1	1	LB	2.5	2.5	P-LISTED - CONTAINERIZED SOLIDS
975100	128	116	LB	576	4.5	U-LISTED - SMALL CONTAINERS
975200	2847	2847	LB	2704.65	0.95	U-LISTED - CONTAINERIZED LIQUIDS/MULTI-PHASE
975500	60	60	LB	150	2.5	Aerosols
9800NC	17423	17073	LB	13067.25	0.75	NICAD BATTERIES.
9800UA	21091	18964	LB	31636.5	1.5	universal waste - alkaline batteries
9800UC	285	285	LB	2707.5	9.5	UNIVERSAL WASTE MERCURY BATTERIES
9800UG	90	90	LB	225	2.5	MAGNESIUM BATTERIES
9800UH	1012	1012	LB	1518	1.5	UNIVERSAL WASTE- nickel metal hydride batteries
9800UK	34068	32574	LB	51102	1.5	UNIVERSAL WASTE AEROSOLS
9800UL	43641	41750	LB	32730.75	0.75	UNIVERSAL WASTE LAMPS
9800UM	79	78	LB	750.5	9.5	Universal Waste Mercury thermostats/other mercury wastes
9800UU	68084	68058	LB	180422.6	2.65	UNIVERSAL WASTE LITHIUM BATTERIES
9800UZ	580	580	LB	1450	2.5	UNIVERSAL WASTE - CARBON ZINC BATTERIES
980100	28601	28327	LB	10010.35	0.35	STATE REG - SMALL CONTAINERS
9801LP	12397	9279	LB	15496.25	1.25	STATE REG - SMALL CONTAINERS
980200	176642	175896	LB	38861.68	0.2200024909	STATE REG - CONTAINERIZED LIQUIDS/MULTI-PHASE
9802AF	6225	6225	LB	2801.25	0.45	STATE REG - CONTAINERIZED LIQUIDS/MULTI-PHASE
9802FF	13314	11366	LB	11316.9	0.85	STATE REG - CONTAINERIZED LIQUIDS/MULTI-PHASE
9802LP	69614	55456	LB	52210.5	0.75	STATE REG - CONTAINERIZED LIQUIDS/MULTI-PHASE
9802RR	163311	163311	LB	34295.31	0.21	STATE REG - CONTAINERIZED LIQUIDS/MULTI-PHASE -- MANDATORY RECYCLING
980400	230110	222450	LB	103491.9	0.4497496849	STATE REG - CONTAINERIZED SOLIDS
9804AR	80151	70229	LB	28052.85	0.35	ALKALINE BATTERIES
9804RR	11083	7693	LB	4987.35	0.45	STATE REG - CONTAINERIZED SOLIDS -- MANDATORY RECYCLING
9804SR	11997	11997	LB	2999.25	0.25	CONTAINERIZED SOLIDS, SOIL RECYCLING.
980500	8	8	LB	20	2.5	STATE REG AEROSOLS
980600	1356848	1322010	LB	244232.64	0.18	STATE REG - BULK LIQUIDS (PUMPABLE)
9806RR	16660	16660	LB	2499	0.15	STATE REG - BULK LIQUIDS (PUMPABLE) -- MANDATORY RECYCLING
9806WR	7131540	7131540	LB	499207.8	0.07	Bulk liquids, pumpable
980700	185660	164660	LB	22279.2	0.12	STATE REG - BULK SOLIDS
9807AR	15580	15580	LB	3427.6	0.22	STATE REG - BULK SOLIDS
9807SR	153430	153430	LB	33754.6	0.22	BULK SOLIDS, SOIL RECYCLING.
990100	8047	7640	LB	2816.45	0.35	NON REG - SMALL CONTAINERS
990200	41600	36127	LB	14628	0.3516346154	NON-REG - CONTAINERIZED LIQUIDS/MULTI-PHASE
9902FA	12604	12604	LB	10713.4	0.85	NON-REG - CONTAINERIZED LIQUIDS/MULTI-PHASE
990400	1851556	1793701	LB	833200.2	0.45	NON-REG - CONTAINERIZED SOLIDS
9904CR	269	269	LB	228.65	0.85	Containerized solids
990600	43785	43785	LB	15324.75	0.35	NON-REG BULK LIQUIDS (PUMPABLE)
9906WR	1813330	1813330	LB	326399.4	0.18	Bulk solids
990700	134994	134994	LB	10799.52	0.08	NON-REG - BULK SOLIDS
9907SR	219530	219530	LB	48296.6	0.22	BULK SOLIDS, SOIL RECYCLING

Macro1

Macro1	Auto_Open
Macro10
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Macro8
Macro9
Recover

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