DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Ravensworth HousingAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders2,341 kg6 orders in scope
Largest category32.5%NTRL Eco
Units bought1,065every line counted once
Recycled content38%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
02505007501kkg CO2eNTRL Eco: 761 kg761 kgJanitorial: 488 kg488 kgMachines: 406 kg406 kgWorkwear: 234 kg234 kgWashroom & Paper: 212 kg212 kgCatering Hygiene: 126 kg126 kgPPE: 67 kg67 kgChemicals: 48 kg48 kgNTRL EcoJanitorialMachinesWorkwearWashroom & PaperCatering HygienePPEChemicals
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
NTRL Eco761241481%32.5%
Janitorial488179722%20.8%
Machines4066321%17.3%
Workwear234126719%10%
Washroom & Paper212288631%9%
Catering Hygiene126175627%5.4%
PPE6735422%2.9%
Chemicals4815321%2%
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.