DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Marchmont Sports CentresAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders588 kg4 orders in scope
Largest category40.6%NTRL Eco
Units bought427every line counted once
Recycled content41%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
063125188250kg CO2eNTRL Eco: 238 kg238 kgWorkwear: 222 kg222 kgWashroom & Paper: 48 kg48 kgCatering Hygiene: 33 kg33 kgJanitorial: 30 kg30 kgPPE: 12 kg12 kgChemicals: 5 kg5 kgNTRL EcoWorkwearWashroom & PaperCatering HygieneJanitorialPPEChemicals
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures7 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
NTRL Eco238204265%40.6%
Workwear222158221%37.8%
Washroom & Paper4833221%8.1%
Catering Hygiene331321%5.6%
Janitorial3010110%5.2%
PPE126137%2%
Chemicals53137%0.8%
How it is worked out. Every ordered line in the window, multiplied by the carbon the product record carries. Same method as the Sustainability module (lib/sustainability.ts, byCategory), so the two always agree.