DC

Carbon Footprint by Category

LiveSustainability Report
Today: Business Central and spreadsheets
Silverbeck HospitalityAll sitesLast 12 weeks5 reports on this account
Replaces: carbon worked out by hand from BC exports and supplier PDFs
Carbon on orders207 kg3 orders in scope
Largest category52.8%Workwear
Units bought128every line counted once
Recycled content9%weighted by units actually bought
Carbon Footprint by CategoryAll sites - Last 12 weeks
0316394125kg CO2eWorkwear: 109 kg109 kgChemicals: 51 kg51 kgCatering Hygiene: 38 kg38 kgPPE: 9 kg9 kgWorkwearChemicalsCatering HygienePPE
Carbon per unit comes off the product record the PIM already feeds, so nobody keys a sustainability figure twice.
The figures4 rows, the same numbers the chart draws
CategoryCarbon (kg)UnitsLinesRecycledShare
Workwear1093722%52.8%
Chemicals5133215%24.5%
Catering Hygiene3840112%18.2%
PPE91829%4.5%
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.