DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Clearvale Cleaning SuppliesAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders1,280 kg7 orders in scope
Largest category39.8%Workwear
Units bought626every line counted once
Recycled content23%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0188375563750kg CO2eWorkwear: 509 kg509 kgMachines: 230 kg230 kgChemicals: 207 kg207 kgJanitorial: 117 kg117 kgNTRL Eco: 114 kg114 kgWashroom & Paper: 87 kg87 kgCatering Hygiene: 13 kg13 kgPPE: 4 kg4 kgWorkwearMachinesChemicalsJanitorialNTRL EcoWashroom & PaperCatering HygienePPE
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
Workwear50923634%39.8%
Machines2304237%17.9%
Chemicals207262433%16.2%
Janitorial11743318%9.1%
NTRL Eco11432393%8.9%
Washroom & Paper8742521%6.8%
Catering Hygiene13410%1%
PPE43122%0.3%
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.