DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Hartsmere Health PartnershipAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders2,867 kg4 orders in scope
Largest category72%PPE
Units bought760every line counted once
Recycled content29%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
06251.3k1.9k2.5kkg CO2ePPE: 2,065 kg2,065 kgWashroom & Paper: 245 kg245 kgNTRL Eco: 245 kg245 kgJanitorial: 166 kg166 kgMachines: 98 kg98 kgChemicals: 46 kg46 kgCatering Hygiene: 3 kg3 kgPPEWashroom & PaperNTRL EcoJanitorialMachinesChemicalsCatering 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
PPE2,065505319%72%
Washroom & Paper24571339%8.5%
NTRL Eco24587484%8.5%
Janitorial16656526%5.8%
Machines982145%3.4%
Chemicals4620230%1.6%
Catering Hygiene319130%0.1%
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.