DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Barrowdale FacilitiesAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders656 kg4 orders in scope
Largest category33.2%Machines
Units bought450every line counted once
Recycled content21%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
063125188250kg CO2eMachines: 218 kg218 kgJanitorial: 184 kg184 kgWorkwear: 113 kg113 kgCatering Hygiene: 77 kg77 kgNTRL Eco: 35 kg35 kgWashroom & Paper: 13 kg13 kgChemicals: 10 kg10 kgPPE: 7 kg7 kgMachinesJanitorialWorkwearCatering HygieneNTRL EcoWashroom & PaperChemicalsPPE
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures8 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
Machines2182131%33.2%
Janitorial18496416%28%
Workwear1135010%17.2%
Catering Hygiene77250227%11.7%
NTRL Eco3510198%5.3%
Washroom & Paper132211%2%
Chemicals101518%1.5%
PPE75118%1.1%
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.