DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Pilgrim Bay Holiday ParksAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders1,534 kg5 orders in scope
Largest category47.1%Janitorial
Units bought651every line counted once
Recycled content16%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0188375563750kg CO2eJanitorial: 723 kg723 kgWashroom & Paper: 315 kg315 kgPPE: 285 kg285 kgMachines: 137 kg137 kgChemicals: 42 kg42 kgWorkwear: 19 kg19 kgCatering Hygiene: 13 kg13 kgJanitorialWashroom & PaperPPEMachinesChemicalsWorkwearCatering 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
Janitorial723387614%47.1%
Washroom & Paper315101624%20.5%
PPE28591311%18.6%
Machines1372217%8.9%
Chemicals4222118%2.8%
Workwear1914237%1.2%
Catering Hygiene1334322%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.