cecilnii/Cocoa-yield-analysis

Farmer yield per hectare analysis for a cocoa cooperative in Ghana — Excel-based delivery consolidation and community performance dashboard. Cocoa Cooperative — Farmer Yield Analysis (2025/26 Season) Author: Cecil Nii Ayikai Tetteh Tools: Microsoft Excel Domain: Agricultural Data Analytics · Cooperative Management · Ghana Cocoa --- ## Project Overview This project analyses farmer-level cocoa delivery and yield performance for a cocoa cooperative in Ghana during the 2025/26 main crop season. The cooperative supplies cocoa to an international premium chocolate buyer under a fixed offtake agreement. The analysis was built to help cooperative management move beyond raw delivery totals and understand which farmers and communities are performing well, which are underperforming, and what the cooperative's true production capacity looks like. --- ## Problem Statement The cooperative holds biodata and spatial (GPS/geodata) records for 2,382 registered farmer members across 26 communities. Each season, delivery records are captured per community in separate spreadsheets. The core questions this project answers: What is each farmer's yield efficiency — kilograms of cocoa per hectare of farm? Which communities are the highest and lowest performers? How many registered members actually delivered this season, and what does the gap tell us? How does the cooperative's total supply capacity compare to the client's offtake requirement? --- ## Data Sources Dataset Description Farmer delivery records Season totals per farmer across 26 community sheets Cooperative spatial master GPS-surveyed farm boundaries with measured plot areas (hectares) Both datasets were anonymised for this portfolio. Farmer codes follow the cooperative's internal ID structure (e.g. `KCO/Z02/ABE/002`). --- ## Methodology Step 1 — Data consolidation 26 individual community delivery sheets were merged into a single flat table of 681 farmer records. Step 2 — Area matching Each farmer's delivery record was matched to their measured farm area from the spatial master using their unique farmer code. Where a farmer holds multiple plots, areas were summed to g …