# Product Carbon Footprint Worksheet (Cradle-to-Gate, Excel) > Source: https://netray.co/tools/product-carbon-footprint-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Row-by-row bill of activities with emission factors that totals kg CO2e per functional unit and exports to Excel for customer carbon requests. ## Category ehs-workforce ## Industry Manufacturing ## Audience - Sustainability lead - Product engineer - Customer quality ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Activity or material **Key:** item **Type:** text #### Life cycle stage **Key:** stage **Type:** select **Options:** - Raw materials - Manufacturing - Inbound transport - Packaging - Distribution - Use - End of life #### Quantity per functional unit **Key:** qty **Type:** number **Help:** Amount consumed per one finished unit. #### Activity unit **Key:** unit **Type:** select **Options:** - kg - kWh - tonne-km - m3 - litre - MJ #### Emission factor (kg CO2e per unit) **Key:** ef **Type:** number **Format:** decimal #### kg CO2e **Key:** co2e **Type:** number **Expr:** qty * ef **Format:** decimal **Rows:** **Item:** Hot rolled steel housing **Stage:** Raw materials **Qty:** 12 **Unit:** kg **Ef:** 2.1 **Item:** Aluminium bracket (primary) **Stage:** Raw materials **Qty:** 1.8 **Unit:** kg **Ef:** 8.2 **Item:** ABS cover **Stage:** Raw materials **Qty:** 0.9 **Unit:** kg **Ef:** 3.5 **Item:** Plant electricity for machining and assembly **Stage:** Manufacturing **Qty:** 18 **Unit:** kWh **Ef:** 0.4 **Item:** Truck freight of steel from mill (0.0125 t x 400 km) **Stage:** Inbound transport **Qty:** 5 **Unit:** tonne-km **Ef:** 0.1 **Item:** Corrugated carton **Stage:** Packaging **Qty:** 0.6 **Unit:** kg **Ef:** 0.9 **Totals:** #### Total kg CO2e per unit **Key:** co2e **Agg:** sum **Format:** decimal **Summary:** #### Tonnes CO2e per 1,000 units **Key:** tonnes_1000 **Expr:** sum_co2e **Format:** decimal **Description:** Numerically equal to kg per unit because 1,000 units times kg per unit divided by 1,000. #### Lines in inventory **Key:** lines **Expr:** count **Format:** integer **Notes:** Example factors are illustrative rounded values, not for disclosure. Replace each with a factor from your own supplier data, an LCA database or an environmental product declaration, and record the source and year beside the row. ## Content **Intro:** Customers in automotive, electronics and construction now ask suppliers for a carbon footprint per part. This worksheet is the working document behind that answer: one row per material, energy or transport input, each multiplied by an emission factor and summed to a cradle-to-gate total. **Sections:** #### How to use it **Body:** Define the functional unit first, such as one assembled pump or one kilogram of machined part. Then list every input to make it, using quantities per unit from the bill of materials, routing energy and freight. Choose the life cycle stage for each row, enter the emission factor, and the worksheet multiplies the two. Add or delete rows freely and export the table to Excel to attach to the customer response. **Bullets:** - Start from the BOM so no material is missed - Allocate plant energy by machine hours or output - Include scrap by raising the input quantity - Keep the factor source and year in a note per row #### The method behind it **Body:** A product carbon footprint sums activity data times emission factor across the chosen boundary. Cradle-to-gate covers raw material extraction through your factory gate, and is what most B2B requests mean. The structure follows ISO 14067 and the GHG Protocol Product Standard: functional unit, system boundary, data quality and allocation must be stated. Use primary data from suppliers where you can, and secondary database factors where you cannot. #### Reading the result **Body:** Sort the table by the kg CO2e column. In metal parts the raw material rows usually dominate, so a supplier switch to recycled or low-carbon aluminium or electric arc furnace steel moves the result far more than plant efficiency. If one row is more than half of the total, improve the data quality of that row first because its factor drives the whole answer. #### Common mistakes **Body:** Frequent errors are leaving out scrap and yield loss, mixing mass and unit-count quantities, applying an average factor to a material with a very different route, and quoting a number without the boundary. Avoid double counting energy already inside a purchased component factor. State the boundary and functional unit next to the total every time. **Cta:** Netray can pull BOM quantities, routings and energy data from your ERP into a worksheet like this so each customer PCF request is a repeatable report instead of a spreadsheet project. **Faq:** #### What is a product carbon footprint? **Answer:** It is the total greenhouse gas emissions attributable to one unit of product across a defined boundary, expressed in kg CO2e. Cradle-to-gate stops at your factory gate, while cradle-to-grave also includes use and end of life. #### Where do I get emission factors? **Answer:** Prefer supplier-specific data or environmental product declarations. Otherwise use a recognised LCA database or government factor set, and record the name, version and year so the figure is reproducible. #### How do I handle scrap? **Answer:** Count the gross material input needed to make one good unit, including scrap and yield loss, rather than only the net weight of the finished part. Otherwise the footprint is understated. #### Can I send this to a customer as is? **Answer:** Send it as supporting data with the boundary, functional unit, factor sources and any assumptions stated. Some customers also require third-party verification or a specific format, so check their request. ## Search terms product carbon footprint worksheet, product carbon footprint excel template, pcf calculation template, cradle to gate carbon footprint, lca spreadsheet manufacturing, embodied carbon of a part, customer pcf request, kg co2e per unit calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json