DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Pennine Schools TrustAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders222 kg3 orders in scope
Largest category54.6%Chemicals
Units bought124every line counted once
Recycled content25%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0316394125kg CO2eChemicals: 121 kg121 kgJanitorial: 72 kg72 kgCatering Hygiene: 15 kg15 kgPPE: 10 kg10 kgNTRL Eco: 5 kg5 kgChemicalsJanitorialCatering HygienePPENTRL Eco
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures5 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
Chemicals12143329%54.6%
Janitorial7252328%32.3%
Catering Hygiene15611%6.6%
PPE102018%4.3%
NTRL Eco53172%2.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.