DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Fenwick Marine ServicesAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders2,168 kg6 orders in scope
Largest category42.3%PPE
Units bought758every line counted once
Recycled content20%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
02505007501kkg CO2ePPE: 917 kg917 kgWashroom & Paper: 583 kg583 kgMachines: 273 kg273 kgChemicals: 165 kg165 kgJanitorial: 110 kg110 kgNTRL Eco: 75 kg75 kgCatering Hygiene: 38 kg38 kgWorkwear: 7 kg7 kgPPEWashroom & PaperMachinesChemicalsJanitorialNTRL EcoCatering HygieneWorkwear
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures8 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
PPE917304314%42.3%
Washroom & Paper583235310%26.9%
Machines2733229%12.6%
Chemicals16575531%7.6%
Janitorial11045620%5.1%
NTRL Eco7550278%3.5%
Catering Hygiene3843228%1.8%
Workwear7310%0.3%
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.