DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Applecross HygieneAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders695 kg4 orders in scope
Largest category65.8%Chemicals
Units bought855every line counted once
Recycled content36%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0125250375500kg CO2eChemicals: 457 kg457 kgPPE: 146 kg146 kgJanitorial: 53 kg53 kgWashroom & Paper: 16 kg16 kgNTRL Eco: 10 kg10 kgWorkwear: 9 kg9 kgCatering Hygiene: 4 kg4 kgChemicalsPPEJanitorialWashroom & PaperNTRL EcoWorkwearCatering Hygiene
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
Chemicals457624339%65.8%
PPE14685527%21%
Janitorial5358320%7.7%
Washroom & Paper1672128%2.3%
NTRL Eco108286%1.4%
Workwear95216%1.2%
Catering Hygiene4319%0.5%
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.