Attachment 5 - Biobased Product Purchases.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- RFP-2023-23044
- Issued by
-
Department of Energy Office of Science
View the file
Other files
Show all 22
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
Biobased Products Reporting
| Workbook Name: | Biobased Products Purchases_FY | Point of Contact Name: |
| Site Name | Phone: | |
| Fiscal Year | Email: |
| Important Note: Do not submit data that can be reported in SAM.gov (SAM is the preferred biobased reporting system). | ||||
| Instructions: | ||||
| 1) The Biobased Product Purchases Workbook should only be completed by sites that cannot report into SAM.gov. The product purchases must be listed as USDA BioPreferred products and originate from a service or construction contract awarded after May 2012 with a total contract value equal or greater than $10,000. | ||||
| 2) Use the Biobased Products Dropdown List tab to determine the category and product type categorization for the drop-down selections. | ||||
| 3) Include a brief description of the product(s) purchased, if available. However, if "Miscellaneous" is selected you must provide a description. | ||||
| 4) Enter spend on the biobased product type in whole dollars. | ||||
| 5) Enter additional information, if necessary. | ||||
| 6) Add more rows as needed. | ||||
| Fields: | ||||
| Prime Contract Number: | ||||
| Sub-Contract Number: | Note, if more than one contract, please list them. | |||
| Category | Product Type | Product Description (Optional) | Cost ($) | Additional Information (Optional) |
| Cafeteria |
| Cleaners/Solvents and Custodial |
| Construction Materials |
| Grounds/Landscaping |
| Lubricants |
| Office |
| Operations/Fleet |
| Shipping |
| Miscellaneous |
Biobased Reporting FAQ
| Biobased Product Purchases Reporting - Frequently Asked Questions |
| What is a biobased product? |
| The term "biobased product" means a product determined by the USDA Secretary to be a commercial or industrial product (other than food or feed) that is (A) composed, in whole or in significant part, of biological products, including renewable domestic agricultural materials, renewable chemicals, and forestry materials; or (B) an intermediate ingredient or feedstock. |
| DOE sites must ensure that the biobased products reported in this workbook are USDA BioPreferred certified: |
| https://www.biopreferred.gov/BioPreferred/ |
| Where is the requirement to report? |
| Per Federal Acquisition Regulation (FAR) 52.223-2 - Affirmative Procurement of Biobased Products under Service and Construction Contracts, sites should report to http://www.sam.gov (with a copy to the Contracting Officer) on the product types and dollar value of any USDA-designated biobased products purchased by the Contractor during the previous Government fiscal year. If reporting in SAM.gov, this annual reporting requirement is to be completed by October 31st. |
| If reporting in this workbook, the data must be submitted into the Dashboard one week prior (i.e., by October 22nd). This allows DOE headquarters time to review, compile, and submit the data to USDA by October 31st. |
| Per FAR 23.406, sites should insert the clause at 52.223-2 in service or construction solicitations and contracts, unless the contract will not involve the use of USDA-designated items at http://www.biopreferred.gov or 7 CFR part 3201. |
| Note, FAR 52.223-2 is also in DEAR 970.5223-7 - Sustainable Acquisition Program. |
| How to report in the System for Award Management (SAM)? |
| To report the biobased product purchases, the original contract(s) must be reported in the Federal Procurement Data System-Next Generation (FPDS) and have the “Recovered Materials/Sustainability” field coded for any of the available options that include the wording “bio-based” (with the ultimate code selection being dependent upon which other sustainability clauses are applicable). Note, if using the FPDS Data Dictionary for reference (see FPDS Guidance tab), the corresponding biobased code selections are E, H, J, K, or L (depending on which other sustainability clauses are applicable). Once you have access to SAM, the user must “select a contract from your list of contracts which require BioPreferred reporting”. |
| DOE cannot give SAM access to a site that does not utilize FPDS as the systems are connected. |
| All purchases that originate from contracts awarded prior to May 2012 cannot be reported into the SAM system and should not be included in this workbook. These contracts predate the SAM system and are currently not being collected for DOE to lessen the reporting burden on sites and align with other Federal agencies. |
| What should be reported in this Biobased Product Purchases Workbook? |
| Biobased product purchases that meet all of the following: 1) Originate from a service or construction contract with a total contract value equal or greater than $10,000; 2) Originate from a contract awarded after May 2012; 3) Cannot be reported in SAM at this time*; and 4) Listed as USDA BioPreferred Products (see above). |
| *If the biobased reporting cannot be completed in SAM at this time, please provide the reporting needed through the Dashboard (i.e., workbook). MA can work with the site to determine if data corrections are needed in FPDS to report to SAM in the future and provide assistance with next steps for corrections. |
| This workbook must be submitted one week earlier than the Federal October 31st deadline to allow DOE headquarters time to review, compile, and submit the data to USDA. |
| Note, the FY 2020 SAM BioPreferred summary year-end report is an automatically generated report and does not include DOE's supplemental biobased product purchase data. |
| How do I report a biobased product if it doesn't fit in a "category"? |
| Confirm that the product is listed in the USDA BioPreferred catalog (https://www.biopreferred.gov/BioPreferred/). If not on this list, it is not an approved biobased product by USDA. This workbook aligns with the categories in the BioPreferred list and any product(s) that doesn't fit in the other categories should be included as “miscellaneous”. If "miscellaneous" is selected, a description of the product(s) must be included. |
| FPDS User Guide (see the FPDS Guidance tab for more info and/or page 50 for "Recovered Materials/Sustainability" field coding): |
| https://www.fpds.gov/downloads/Manuals/FPDS-NG_User_Manual_V15.pdf |
| FPDS Data Dictionary (see page 90 for "Recovered Materials/Sustainability" field coding): |
| FPDS_DataDictionary_V1.5.pdf |
| See the FAQ on FedCenter for more information: |
| https://www.fedcenter.gov/_kd/go.cfm?destination=Page&Pge_ID=4135 |
https://www.biopreferred.gov/BioPreferred/https://www.fedcenter.gov/_kd/go.cfm?destination=Page&Pge_ID=4135https://www.fpds.gov/downloads/Manuals/FPDS-NG_User_Manual_V15.pdfhttps://www.fpds.gov/downloads/Version_1.5_specs/FPDS_DataDictionary_V1.5.pdf FPDS Guidance To report the biobased product purchases, the original contract(s) must be reported in the Federal Procurement Data System-Next Generation (FPDS) and have the “Recovered Materials/Sustainability” field coded for any of the available options that include the wording “bio-based” (with the ultimate code selection being dependent upon which other sustainability clauses are applicable).
| FPDS User Manual: | Microsoft Word - FPDS_User_Manual_V1.5 | |||||||
| 4.10.8 Recovered Materials/Sustainability (Data Dictionary Element 8L) | ||||||||
| This data element Populates on a DO against a single award IDV and modifications. | ||||||||
| It is required on a DO against a multiple IDV and BOA and all other awards. | ||||||||
| This field designates whether the contracting officer included clauses in the contract for the Recovered Materials Certification and/or Estimate of Percentage of Recovered Material Content for EPA Designated Products. | ||||||||
| Please select the appropriate value from the drop-down menu. | ||||||||
| See Data Dictionary Element 8L Use Case for appropriate data entry requirements. | ||||||||
| Note: When EPA Designated Product(s) is coded as 'Not Required' (E), then "Recovered Materials/Sustainability" must be 'No Clauses Included and No Sustainability Included' (C), 'Energy Efficient' (D), 'Bio-based' (E), or 'Environmentally Preferable' (F). | ||||||||
| Definitions for each value and whether it includes a biobased selection is marked as 'Yes' or 'No' in the table below. | ||||||||
| Biobased (Y/N) | Code | Short Description | Long Description | |||||
| No | A | FAR 52.223-4 Included | The solicitation included the provision at FAR 52.223-4, Recovered Material Certification. | |||||
| No | B | FAR 52.223-4 and FAR 52.223-9 Included | The solicitation included the provision at FAR 52.223-4, Recovered Material Certification and the contract includes the clause at FAR 52.223-9, Estimate of Percentage of Recovered Material Content for EPA-Designated Products. | |||||
| No | C | No Clauses Included and No Sustainability Included | Neither clause is included in the contract. | |||||
| No | D | Energy efficient | Energy efficient. | |||||
| Yes | E | Bio-based | Bio-based. | |||||
| No | F | Environmentally preferable | Environmentally preferable (http://www.whitehouse.gov/omb/procurement_index_green/). | |||||
| No | G | FAR 52.223-4 & energy efficient | FAR 52.223-4 & energy efficient. | |||||
| Yes | H | FAR 52.223-4 & bio-based | FAR 52.223-4 & bio-based. | |||||
| No | I | FAR 52.223-4 & environmentally preferable | FAR 52.223-4 & environmentally preferable (http://www.whitehouse.gov/omb/procurement_index_green/). | |||||
| Yes | J | FAR 52.223-4 & bio-based & energy efficient | FAR 52.223-4 & bio-based & energy efficient. | |||||
| Yes | K | FAR 52.223-4 & bio-based & environmentally preferable | FAR 52.223-4 & bio-based & environmentally preferable (http://www.whitehouse.gov/omb/procurement_index_green/). | |||||
| Yes | L | FAR 52.223-4 & bio-based & energy efficient & environmentally preferable | FAR 52.223-4 & bio-based & energy efficient & environmentally preferable (http://www.whitehouse.gov/omb/procurement_index_green/). | |||||
| FPDS Data Dictionary: | FPDS_DataDictionary_V1.5.pdf | |||||||
| 8L | Recovered Materials/Sustainability | |||||||
| Element Number: | 8L | |||||||
| Name: | Recovered Materials/Sustainability | |||||||
| DEName: | Recovered_Material_Clauses | |||||||
| Screen Name: | Recovered Materials/Sustainability | |||||||
| XML Tag Name: | recoveredMaterialClauses | |||||||
| XML Version: | Version 1.0 and later | |||||||
| Derivation: | None | |||||||
| Definition: | Designates whether Recovered Material Certification and/or Estimate of Percentage of Recovered Material Content for EPA-Designated Products clauses were included in the contract. | |||||||
| Instruction: | When EPA Designated Product(s) is coded as 'Not Required' (E), then "Recovered Materials/Sustainability" must be 'No Clauses Included and No Sustainability Included' (C). Otherwise, "Recovered Materials/Sustainability" can have any value. | |||||||
| FAR/DFARS: | FAR 23.406; FAR 52.223-4; FAR 52.223-9; DFARS 253.204-70(b)(12)(vii) | |||||||
| SF279: | 19B | |||||||
| DD350: | B12G | |||||||
| Source: | CO | |||||||
| Format: | String | |||||||
| Length: | 1 | |||||||
| Requirement State - Award: | DO referencing an FSS, GWAC and Multiple Award IDC | DO referencing a Single Award IDC | DO referencing a BOA | PO | DCA | Part 8 BPA Call | Part 13 BPA Call | MOD |
| Required | Propogates | Required | Required | Required | Required | Required | Propogates |
| Requirement State - IDV: | FSS | GWAC | BOA | Part 8 BPA Call | Part 13 BPA Call | IDC | MOD |
| Not Applicable | Required | Not Applicable | Not Applicable | Not Applicable | Required | Propagates | |
| Access Restricted: | No | ||||||
| Values: | See table above. |
https://www.fpds.gov/downloads/Version_1.5_specs/FPDS_DataDictionary_V1.5.pdfhttps://www.fpds.gov/downloads/Manuals/FPDS-NG_User_Manual_V15.pdf Biobased Products Dropdown List
| Note: Sites are required to specify these products in all contracts and any other procurements per the Federal Acquisition Regulation Part 23. | |||||||||||||||
| Animal_Care | Asphalt_Concrete_Maintenance | Cleaning_Janitorial | Construction_Renovation | Fleet | Food_Services | Greases_and_Lubricants | Groundskeeping_Agricultural | Housing_Household | Intermediates_Feedstocks | Metalworking | Miscellaneous | Operations_and_Maintenance | Office_Supplies_Printing | Personal_Care | Shipping |
| Animal Cleaning Products | Asphalt Restorers | Adhesive and Mastic Removers | Acoustical Composite Panels | Aircraft Cleaners | Dishwashing Products | Chain and Cable Lubricants | 2-Cycle Engine Oils | Bedding, Bed Linens, and Towels | Chemicals | Corrosion Preventatives | Fire Logs and Fire Starters | Adhesives | Electronic Component Cleaners | Bath Products | Expanded Polystyrene Foam Recycling Products |
| Animal Habitat Care Products | Asphalt and Tar Removers | Air Fresheners and Deodorizers | Blast Media | Boat Cleaners | Disposable Containers | Firearm Lubricants | Agricultural Spray Adjuvants | Candles and Wax Melts | Cleaner Components | Corrosion Removers | Firearm Cleaners, Lubricants, and Protectants | Bioremediation Materials | Folders and Filing Products | Cuts, Burns, and Abrasions Ointments | Packing and Insulating Materials |
| Animal Repellants | Concrete Leveling Materials | Bathroom and Spa Cleaners | Carpets | Automotive Care Products | Disposable Cutlery | Forming Lubricants | Compost Activators and Accelerators | General Purpose Laundry Products | Fibers and Fabrics | General Metal Cleaners | Product Packaging | Dust Suppressants | Ink Removers and Cleaners | Deodorants | Durable Thermal Shipping Containers |
| Concrete Patching Materials | General Purpose Carpet/Upholstery | Countertops | Transmission Fluids | Disposable Tableware | Gear Lubricants | De-Icers | General Purpose Household Cleaners | Foams | Stainless Steel Cleaners and Corrosion Removers | Epoxy Systems | News Ink | Facial Care Products | Non-Durable Thermal Shipping Materials | ||
| Concrete and Asphalt Cleaners | Cleaners | Floor Coverings (Non-Carpet) | Diesel Fuel Additives | Durable Cutlery | Heat Transfer Fluids | Dethatchers | Heating Fuels and Wick Lamps | Lubricant Components | General Purpose Soluble, Semi-Synthetic, and Synthetic Oil Fluids | Industrial Cleaners | Printer Toner (> 25 Pages per Minute) | Feminine Care Products | Non-Durable Films | ||
| Concrete and Asphalt Release Fluids | Carpet and Upholstery Spot Removers | Exterior Paints and Coatings | Engine Crankcase Oil | Durable Tableware | Mobile Equipment Hydraulic Fluids | Erosion Control Materials | Laundry Pretreatment and Spot Removers | Oils, Fats, and Waxes (65%) | Powder Coatings | Synthetic Ester-Based Fluid-Filled Transformers | Printer Toner (< 25 Pages per Minute) | Foot Care Products | Semi-Durable Films | ||
| Concrete Curing Agents | Cleaning Tools | Interior Composite Panels | Fuel Conditioners | Food Cleaners | Forming Lubricants | Fertilizers | Laundry Dryer Sheets | Paint and Coating Components | Vegetable Oil-Based Fluid-Filled Transformers | Sheetfed Ink (Black) | Hair Care Conditioners | ||||
| Membrane Concrete Sealers | Floor Cleaners and Protectors | Interior Latex and Waterborne Alkyd Paint | Gasoline Fuel Additives | Food Grade Greases | Gear Lubricants | Foliar Sprays | Toys and Sporting Gear | Personal Care Product Components | Parts Wash Solutions | Sheetfed Ink (Color) | Hair Care Shampoos | ||||
| Materials | Floor Strippers | Interior Oil-based and Solventborne Alkyd Paint | Truck Greases | Kitchenware and Accessories | Multipurpose Greases | Gardening Supplies and Accessories | Rugs and Floor Mats | Plastic Resins | Phase Change Materials | Specialty Inks | Hand Cleaners | ||||
| Playground and Athletic Surface | Furniture Cleaners and Protectors | Paint Removers | Oven and Grill Cleaners | Multipurpose Lubricants | Mulch and Compost Materials | Rubber Materials | Sorbents | Hand Sanitizers | |||||||
| Traffic and Zone Marking Paints | Glass Cleaners | Plastic Insulating Foam for Construction | Other Greases | Textile Processing Materials | Specialty Precision Cleaners and Solvents | Lip Care Products | |||||||||
| Penetrating Liquid Wood and Concrete Sealers | Graffiti and Grease Removers | Plastic Lumber Composite Panels | Other Lubricants | Wastewater Systems Coatings | Lotions and Moisturizers | ||||||||||
| Wood and Concrete Stains | Leather, Vinyl, and Rubber Care Products | Powder Coatings | Pneumatic Equipment Lubricants | Water Tank Coatings | Shaving Products | ||||||||||
| Microbial Drain Maintenance Products | Roof Coatings | Rail Truck Greases | Water and Wastewater Treatment Chemicals | Sun Care Products | |||||||||||
| General Microbial Cleaning Products | Structural Interior Composite Panels | Slide Way Lubricants | Topical Pain Relief Products | ||||||||||||
| Microbial Wastewater Maintenance Products | Structural Wall Composite Panels | Stationary Equipment Hydraulic Fluids | |||||||||||||
| Multipurpose Cleaners | Surface Guards, Molding, and Trim | Straight Oils | |||||||||||||
| Shopping and Trash Bags | Wall Coverings | Turbine Drip Oils | |||||||||||||
| Water Turbine Bearing Oils |
File details come from the government source that posted it. Updated .