DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Ludgate Row RestaurantsAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders350 kg3 orders in scope
Largest category24.2%PPE
Units bought217every line counted once
Recycled content33%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0255075100kg CO2ePPE: 85 kg85 kgNTRL Eco: 82 kg82 kgWashroom & Paper: 79 kg79 kgWorkwear: 45 kg45 kgJanitorial: 27 kg27 kgChemicals: 24 kg24 kgCatering Hygiene: 9 kg9 kgPPENTRL EcoWashroom & PaperWorkwearJanitorialChemicalsCatering 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
PPE8524114%24.2%
NTRL Eco8246274%23.3%
Washroom & Paper7949321%22.6%
Workwear4544210%12.8%
Janitorial2729232%7.6%
Chemicals2420237%6.7%
Catering Hygiene95134%2.7%
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.