Bill of Materials Calculator
Start your Sustainable Footprint Calculation & create your Bill of Materials below!
Use of terms:
Product’s circularity value between 0% and 100%. 100% being the best circular score. The value is determined with this Excel model.
Circularity value of a component, material, assembly or semi-finished product between 0% and 100%. 100% being the best circular score.
The term product is only applied in the CPF system for products with a usage phase and processing in the “end-of-life phase". A product goes through the entire life cycle.
All elements that make up or maintain a product. These can be raw materials, materials, semi-finished products or complete sub-assemblies.
The most important feature is: a component has no usage phase on its own, it is by definition first processed in a product. For example, a bucket of paint, a roll of steel, a car tire, an electric motor, a roll of textile, etc.
Note: Suppliers of the mentioned components may call them a “product", however, these are not products within this CPF system!
Components resulting from the disassembly of a product. Disassembly can be a simple procedure, but it also may involve specific tools and, in extreme cases, destructive removal of other components and/or materials (e.g. grinding/sawing).
Different components of a product can be assembled inseparably. For example, steel and a paint coating: during manufacturing – two components/materials; at the end-of-life cycle – a complete disassembly.
The connection has consequences at the end-of-life processing. The components obtained during disassembly may not necessarily be the same that made up a product initially.
Raw material that has not been previously used or consumed. These are materials that have been extracted directly from nature in their raw state, such as wood, iron ore, coal, minerals, stone, metals, petroleum etc. and all components manufactured from them.
Material that has already been used in a product, or waste resulting from production, which has undergone a waste treatment. This waste treatment can be mechanical, thermal and chemical. Recycled material is created before or after the usage phase (pre- or post-consumer).
Component previously used in a product, or waste resulting from production, which has not undergone a waste treatment. For example, a bag made from the fabric of a used pair of jeans.
Raw material of ecological or animal origin. This includes biobased materials. An important parameter for renewable raw material is whether it has a short or long life cycle.
Wood from a rainforest is also renewable, but its life cycle is not short. The limit between short and long cycles is 9 years for CPF (equivalent to Cradle to Cradle).
Materials with a growth time exceeding 9 years are not considered renewable, unless they belong in an FSC or PEFC-managed forest with responsible cultivation. Cotton, leather, wool are short-cycled renewable raw materials.
The possibility to recycle a disassembly in whole or in part at least once. Note: there are some materials that may not be recycled at present, for example plastic crisp bags and an aluminum profile.
A material is compostable if it deteriorates under certain conditions within a short period of time (usually a few months), consequently supplying nutrients to ecosystems.
Compostability is demonstrated with an appropriate ASTM, ISO, CEN or DIN standard. (For example the ASTM D6400-04 standard for plastic). Compostable is not equal to biodegradable. Even the plastic soup in the ocean is ultimately biodegradable, but that process takes a long time.
Production waste Material that has been released during the production process but has not been used in the product.
In Dutch: stuklijst. List of all components making up a product. To create the CPFx, use the “CPFx calculation" worksheet tab and perform the following steps:
Prepare overview with weights
Prepare a complete bill of materials for the component material, assembly, semi-finished or finished product. Enter all the components making up the product (column B) in the “CPFx calculation" worksheet. Enter information about supplier(s), unit used, unit weight and number of units per product.
Ask the supplier for the CPFx calculation:
If the supplier has itself compiled a CPFx calculation, then that value must be applied. Select “yes" in column J: “CPFx known from supplier?" and enter the value. Imports for ratio of recycled, reused or renewable raw materials are blocked
Proof secondary raw material:
Ask your supplier for the ratio of recycled, reused or renewable raw materials that make up the component. Also ask for any proof documents. To do this, create a folder for that purpose with files and refer to the file name in this Excel sheet.
-> If the ratios are not known, market average percentages can be applied. If different sources mention different ratios, the lowest value (worst case) must be selected.
Input Production waste:
For each component of the BoM, enter the production waste that occurs during your own production. Also enter how the production waste is processed: offered for recycling, reuse (such as in your own process) or composted. Add proof documentation for that processing in the folder, and refer to the file name.
Process for CPF
To prepare the CPF, complete the following steps:
Calculate CPFx first
First, set up the CPFx, see Step 1 to Step 4 to do this.
Enter the components used in the maintenance phase.
List of disassemblies
Make a complete list of disassemblies (see above for the definition of disassembly). Also enter the weights and numbers.</p>
Enter the end-of-life scenario
Enter the processing method for each disassembly: ratio offered for recycling, reuse or composting. Add proof documentation for that processing in the folder, and refer to the file name.
BoM CALCULATOR (Bill of Materials)
GSES System Dashboard
Update: January 2021