DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Ashcombe Care GroupAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders829 kg3 orders in scope
Largest category60.2%PPE
Units bought553every line counted once
Recycled content20%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0125250375500kg CO2ePPE: 499 kg499 kgMachines: 124 kg124 kgWorkwear: 83 kg83 kgJanitorial: 82 kg82 kgChemicals: 19 kg19 kgCatering Hygiene: 14 kg14 kgWashroom & Paper: 8 kg8 kgPPEMachinesWorkwearJanitorialChemicalsCatering HygieneWashroom & Paper
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
PPE499408222%60.2%
Machines1241125%15%
Workwear833937%10.1%
Janitorial8220136%9.9%
Chemicals194811%2.3%
Catering Hygiene1417143%1.6%
Washroom & Paper820217%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.