DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Halstow LogisticsAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders197 kg2 orders in scope
Largest category40.3%Workwear
Units bought137every line counted once
Recycled content16%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0255075100kg CO2eWorkwear: 80 kg80 kgJanitorial: 64 kg64 kgChemicals: 42 kg42 kgPPE: 12 kg12 kgWorkwearJanitorialChemicalsPPE
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures4 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
Workwear806136%40.3%
Janitorial6446214%32.6%
Chemicals4224140%21.3%
PPE126137%5.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.