DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Willowford Garden CentresAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders666 kg5 orders in scope
Largest category45.8%Janitorial
Units bought395every line counted once
Recycled content27%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0100200300400kg CO2eJanitorial: 305 kg305 kgChemicals: 186 kg186 kgWorkwear: 65 kg65 kgCatering Hygiene: 49 kg49 kgWashroom & Paper: 29 kg29 kgNTRL Eco: 25 kg25 kgPPE: 6 kg6 kgJanitorialChemicalsWorkwearCatering HygieneWashroom & PaperNTRL EcoPPE
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
Janitorial30597529%45.8%
Chemicals186200121%27.9%
Workwear6519142%9.8%
Catering Hygiene4943338%7.4%
Washroom & Paper2925219%4.4%
NTRL Eco258280%3.8%
PPE63130%0.9%
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.