DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Oakhurst Care HomesAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders319 kg3 orders in scope
Largest category45.9%NTRL Eco
Units bought271every line counted once
Recycled content53%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
03875113150kg CO2eNTRL Eco: 146 kg146 kgChemicals: 66 kg66 kgWorkwear: 45 kg45 kgWashroom & Paper: 43 kg43 kgCatering Hygiene: 16 kg16 kgPPE: 3 kg3 kgNTRL EcoChemicalsWorkwearWashroom & PaperCatering HygienePPE
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures6 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
NTRL Eco146164373%45.9%
Chemicals6616138%20.7%
Workwear4546411%14.2%
Washroom & Paper4325330%13.5%
Catering Hygiene1619122%4.9%
PPE3119%0.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.