<aside>
🥜
At a glance
- Client / industry: Nutty Nirvana / Peanut butter manufacturer
- Reporting period: Jan 1, 2025 – Dec 31, 2025
- Inventory approach: Activity data + emissions factors calculated in a Google Sheet
- Scopes covered: Scope 1, Scope 2, and Scope 3 categories
- Outputs: CO2e totals by scope, key drivers, and a results dashboard
</aside>
<aside>
📌
Executive summary
- Total footprint: 6,721.25 tCO2e (Scopes 1–3)
- Primary hotspots: purchased goods (peanuts), electricity, and packaging plastics
- Recommended first moves: renewable electricity pathway + efficiency, LCA for peanuts and packaging, and logistics optimization
</aside>
Purpose
- Demonstrate an end-to-end corporate GHG inventory workflow using manual calculations in a Google Spreadsheet.
- Present results in a client-ready dashboard format suitable for portfolio review.
Deliverables
- GHG inventory workbook (data inputs, calculations, emissions factors)
- Summary outputs (CO2e by scope and category)
- Results dashboard visuals and key insights
- Recommendations and decarbonization opportunities (high-level)
Project approach (phases)
- Intake & data mapping: identify required data by scope/category and define units.
- Data cleaning & QA: check completeness, units, and reasonableness.
- Calculations: convert activity data to emissions using documented factors.
- Review: reconcile totals and perform spot checks.
- Reporting: summarize results, create dashboard, and draft recommendations.
Company information (case study)
