RFQ_R-2526-06_Attachment_5_(blank).xlsx

XLSX spreadsheet 46 KB Posted

Attached to
A&E Shortlist RFQ R-2526-06
Solicitation number
0000036906
Issued by
California

About this file

This is a blank Request for Quotation (RFQ) attachment template for contract R-2526-06, designed for environmental testing and remediation services. The document serves as a pricing schedule for qualified vendors to submit comprehensive bids across multiple service categories including labor, laboratory testing, equipment rental, and supplies. The RFQ encompasses a broad range of environmental analysis capabilities, including air quality testing for volatile organic compounds (VOCs) and fixed gases, soil and water analysis for metals, pesticides, PFAS compounds, petroleum hydrocarbons, and specialty contaminants such as dioxins and PCBs. Laboratory testing services are categorized by turnaround time requirements: 10-day, 5-day, 3-day, and 24-hour analysis options, each with separate pricing structures and weighting factors to determine overall bid competitiveness.

The pricing structure includes two labor categories—non-prevailing wage and prevailing wage—with 29 distinct labor classifications ranging from Principal-level positions to administrative support staff, each with assigned hourly weighting factors representing hypothetical weekly allocations. Equipment pricing encompasses field instruments and sampling equipment such as water level meters, multiparameter water quality instruments, various pump types, holding tanks, and soil boring equipment available for daily or weekly rental rates. Supplies pricing covers consumables including sampling containers, protective equipment, filtration supplies, and specialized certified canisters for air sampling. The blank template indicates all pricing fields are set to $0.00, requiring bidders to populate actual rates. A summary scoring section applies weighting factors across all service categories (labor non-prevailing at 10x weight, prevailing wage at 1x weight, laboratory testing at varying weights from 5x to 15x, equipment at 10x-5x weight, and supplies at 10x weight) to calculate total weighted bid scores for comparative evaluation.

View the file

Other files

File Type Posted
RFQ_R-2526-06_A_E_Shortlist_-_Addendum_1_Final.pdf PDF
RFQ_R-2526-06_A_E_Shortlist.pdf PDF
RFQ_R-2526-06_Attachment_3_(blank).xlsx XLSX spreadsheet

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Others

Routine volatiles
Dissolved Calif. Admin. List
IndividuL Anion
Bromate
8270C 1
EPA Title 22 Metals, Volatile Organics
Hexavalant Chromium
Custom6101B Boron
KMnO4
Individual Metal
CAC Title 22 Metals
Volatile Organics C Total Disolve Solid Sample Filtration
Total Alkalinity
Total Disolved Solids
Custom Anion Lis
SM 3500 FE B
Chemicl Oxygen Demand
Hexavalaent Chromium
8260B Routine+Oxy's
4-Dioxane-SIM_MS_ID
Volatile Organic Compounds in Ambient Air

Cover Sheet

Company Name:
Region:
Contact Person:
Email:
Phone Number:

Labor_Non PW

ID#Labor ClassificationNon-Prevailing Salaries/ Wages/ HourBenefits/HourEmployer-Paid Federal and State Payroll Taxes/HourAdministrative Overhead Costs/HourProfit/HourNon-Prevailing Salary/Wage Total Rate/HourWeighting Factor (hours in a hypothetical week)Non-Prevailing Salary/Wage Total Rate/Hour with Weighting
L1Principal II$0.000.5$0.00
L2Principal I$0.001$0.00
L3Program Manager/Contract Manager$0.002$0.00
L4Registered Geologist$0.002$0.00
L5Registered Civil Engineer$0.001$0.00
L6Certified Industrial Hygienist$0.002$0.00
L7Engineer/ Geologist/ Hydrogeologist IV$0.008$0.00
L8Engineer/ Geologist/ Hydrogeologist III$0.0016$0.00
L9Engineer/ Geologist/ Hydrogeologist II$0.0016$0.00
L10Engineer/ Geologist/ Hydrogeologist I$0.001$0.00
L11Scientist/ Chemist/ Biologist IV$0.004$0.00
L12Scientist/ Chemist/ Biologist III$0.008$0.00
L13Scientist/ Chemist/ Biologist II$0.008$0.00
L14Scientist/Chemist/Biologist I$0.000.5$0.00
L15Toxicologist/Risk Assessor (Eco/ Human) III$0.000.5$0.00
L16Toxicologist/Risk Assessor (Eco/ Human) II$0.000.5$0.00
L17Toxicologist/Risk Assessor (Eco/ Human) I$0.002$0.00
L18GIS/Graphics Specialist II$0.001$0.00
L19GIS/Graphics Specialist I$0.002$0.00
L20CADD Drafter/ Drafting II$0.001$0.00
L21CADD Drafter/ Drafting I$0.001$0.00
L22Field Supervisor$0.004$0.00
L23Field Technician II$0.008$0.00
L24Field Technician I$0.008$0.00
L25Project Control/ Procurement$0.008$0.00
L26Technical Editor$0.001$0.00
L27Word Processor$0.002$0.00
L28Admin Clerical$0.002$0.00
L29Cost Estimator$0.001$0.00
$0.00

Labor_PW

ID#Labor ClassificationPrevailing Wage Salaries/ Wages/ HourBenefits/HourEmployer-Paid Federal and State Payroll Taxes/HourAdministrative Overhead Costs/HourProfit/HourPrevailing Salary/Wage Total Rate/HourWeighting Factor (hours in a hypothetical week)Prevailing Salary/Wage Total Rate/Hour with Weighting
L30Principal II$0.000.5$0.00
L31Principal I$0.001$0.00
L32Program Manager/Contract Manager$0.002$0.00
L33Registered Geologist$0.002$0.00
L34Registered Civil Engineer$0.001$0.00
L35Certified Industrial Hygienist$0.002$0.00
L36Engineer/ Geologist/ Hydrogeologist IV$0.008$0.00
L37Engineer/ Geologist/ Hydrogeologist III$0.0016$0.00
L38Engineer/ Geologist/ Hydrogeologist II$0.0016$0.00
L39Engineer/ Geologist/ Hydrogeologist I$0.001$0.00
L40Scientist/ Chemist/ Biologist IV$0.004$0.00
L41Scientist/ Chemist/ Biologist III$0.008$0.00
L42Scientist/ Chemist/ Biologist II$0.008$0.00
L43Scientist/Chemist/Biologist I$0.000.5$0.00
L44Toxicologist/Risk Assessor (Eco/ Human) III$0.000.5$0.00
L45Toxicologist/Risk Assessor (Eco/ Human) II$0.000.5$0.00
L46Toxicologist/Risk Assessor (Eco/ Human) I$0.002$0.00
L47GIS/Graphics Specialist II$0.001$0.00
L48GIS/Graphics Specialist I$0.002$0.00
L49CADD Drafter/ Drafting II$0.001$0.00
L50CADD Drafter/ Drafting I$0.001$0.00
L51Field Supervisor$0.004$0.00
L52Field Technician II$0.008$0.00
L53Field Technician I$0.008$0.00
L54Project Control/ Procurement$0.008$0.00
L55Technical Editor$0.001$0.00
L56Word Processor$0.002$0.00
L57Admin Clerical$0.002$0.00
L58Cost Estimator$0.001$0.00
$0.00

Lab Testing

MediaTypes of TestsEPA Testing Method10 Day Turnaround RateWeighting Factor 10-Day10 Day Turnaround TOTAL5 Day Turnaround RateWeighting Factor 5-Day5-Day Turnaround TOTAL3-Day Turnaround RateWeighting Factor 3-Day Turnaround3-Day Turnaround TOTAL24-Hour Turnaround RateWeighting Factor 24 Hour Turnaround24-hour Turnaround TOTAL
AirVOCs ("low level")T0-150.4800%$0.00000.1733%$0.0000.1733%$0.0000.1733%$0.000
VOCs ("Ultra low level")TO-15 SIM0.4800%$0.00000.1733%$0.0000.1733%$0.0000.1733%$0.000
Fixed Gases (Methane, CO, CO2, O2, N2, H2S, NH4)TO-03 et al.0.4800%$0.00000.1733%$0.0000.1733%$0.0000.1733%$0.000
SoilPCBs8082A0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Dioxins / Furans8280A0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Organochlorine Pesticides8081A0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
PFAS - 18 analytes (EPA 537 method list)537M or DoD QSM0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
PFAS - 40 analytes537M or DoD QSM0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Organophosphorus Pesticides8141A0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Antimony6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Arsenic6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Barium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Beryllium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Cadmium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Total Chromium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Cobalt6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Copper6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Lead6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Mercury7471B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Molybdenum6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Nickel6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Selenium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Silver6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Thallium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Vanadium6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Zinc6010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
California Administrative Manual (CAM) Metals - 176010B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
California Administrative Manual (CAM) Metals - 176020B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Volatile Organic Compounds8260B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Volatile Organic Compounds (Sampling Method 5035)8260B0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Toxicity Characteristic Leaching Procedure (TCLP) ExtractionTCLP0.0400%$0.00000.0217%$0.0000.0217%$0.000N/AN/A$0.00
Soluble Threshold Limit Concentration (STLC) ExtractionSTLC0.0400%$0.00000.0217%$0.0000.0217%$0.000N/AN/A$0.00
Total Recoverable Petroleum Hydrocarbons418.10.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Total Petroleum Hydrocarbons Scan8015D0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Total Petroleum Hydrocarbons - Diesel8015D0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Total Petroleum Hydrocarbons - Oil8015D0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Total Petroleum Hydrocarbons - Gas8015D0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Semivolatile Organic Compounds (SVOCs)8270C0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
SVOCs - SIM8270 SIM0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
Polynuclear Aromatic Hydrocarbons (PAHs)8270C0.0400%$0.00000.0144%$0.0000.0144%$0.0000.0144%$0.000
WaterPCBs8082A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Organochlorine Pesticides8081A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Dissolved SolidsSM 2540C0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
TurbiditySM 21300.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
ChlorideSM 9056A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
NitrateSM 9056A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Sulfide9030B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
SulfateSM 9056A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
CAC Title 22 Metals - Total6020B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Antimony6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Arsenic6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Barium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Beryllium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Cadmium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Cobalt6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Copper6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Lead6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Mercury7470A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Molybdenum6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Nickel6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Selenium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Silver6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Thallium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Vanadium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Zinc6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Chromium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
CAC Title 22 Metals - Dissolved6020B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Antimony6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Arsenic6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Barium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Beryllium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Cadmium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Cobalt6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Copper6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Lead6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Mercury7470A0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Molybdenum6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Nickel6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Selenium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Silver6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Thallium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Vanadium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Zinc6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Chromium6010B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Volatile Organic Compounds8260B0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
PFAS - 18 analytes (EPA 537 method list)537M or DoD QSM0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
PFAS - 40 analytes537M or DoD QSM0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Recoverable Petroleum Hydrocarbons418.10.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Petroleum Hydrocarbons - Diesel8015D0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Petroleum Hydrocarbons - Oil8015D0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Total Petroleum Hydrocarbons - Gas8015D0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
Semivolatile Organic Compounds (SVOCs)8270C0.0311%$0.00000.0112%$0.0000.0112%$0.0000.0112%$0.000
$0.0000$0.0000$0.0000$0.0000

Equipment

EquipmentSpecificationsBid Price Per DayBid Price Per Week
Water Level MeterUp to 200 ft
Water - multiparameter instrument (DO, ORP, pH, Temperature) - per day
Utility ClearanceLump sum per property of a ground penetrating radar survey for a private property; this price should not include the cost of prime contractor's labor
Bladder Pumps
Centrifugal Pumps
Peristaltic Pumps
ColorimeterDR/900 HACH or equivalent
Holding Tank - 1,000 gallon
Holding Tank - 5,000 gallon
Holding Tank - 21,000 gallon
Hand Auger
Power Auger
$ - 0$ - 0

Supplies

ID#SupplySpecificationBid UnitPrice per Unit
S1Container55 gallon drum, sealablePer Drum
S2Passive Diffusion BagAll sizesPer Bag
S3Personal Protective Equipment Level BProtective clothing and respirator needed for Level BPer day/per person
S4Personal Protective Equipment Level CProtective clothing and respirator needed for Level CPer day/per person
S50.45 Micron FilterPer Filter
S6Teflon TubingPer Foot
S7Disposable BailerPer Bailer
S8Reproduction
S9black and white, per page
S10color, per page
S11Spray Paint12 ozPer Can
S12Batch-Certified Summa Canister1 LiterPer canister
S13Batch-Certified Summa Canister6 LiterPer canister
$ - 0

Total Summary

SheetsTotals from TabsWeighting FactorTotals with Weighting
Labor_Non PW$0.0010$0.00
Labor_PW$0.001$0.00
Lab Testing_10 Days$0.0015$0.00
Lab Testing_5 Days$0.0010$0.00
Lab Testing_3 Days$0.008$0.00
Lab Testing_24 hrs$0.005$0.00
Equipment_Per Day$0.0010$0.00
Equipment_Per Week$0.005$0.00
Supplies$0.0010$0.00
$0.00

File details come from the government source that posted it. Updated .