DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Brightside FacilitiesAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders1,460 kg4 orders in scope
Largest category77.5%PPE
Units bought540every line counted once
Recycled content10%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
03136259381.3kkg CO2ePPE: 1,132 kg1,132 kgJanitorial: 157 kg157 kgWashroom & Paper: 125 kg125 kgWorkwear: 24 kg24 kgCatering Hygiene: 10 kg10 kgNTRL Eco: 8 kg8 kgChemicals: 5 kg5 kgPPEJanitorialWashroom & PaperWorkwearCatering HygieneNTRL EcoChemicals
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
PPE1,13240327%77.5%
Janitorial1576458%10.8%
Washroom & Paper12549319%8.5%
Workwear2413239%1.6%
Catering Hygiene107128%0.7%
NTRL Eco82196%0.6%
Chemicals52121%0.4%
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.