Integrated Management System for Agrifood SMEs

Context

Many agrifood SMEs in Africa and elsewhere still rely on fragmented tools (Excel, paper), harming data reliability and operational visibility. This project, initially developed for the Cameroonian company Les Confiotes, was designed to be adaptable to other structures.

Problem

Scattered production tracking, inventory, invoicing and reporting → errors, wasted time, poor planning.

Solution

Deployment of a modular integrated system including:

• an automated Excel model (order entry, invoicing, delivery notes, cost calculation);
• an interactive dashboard (Tableau Public / Power BI) to visualize sales, seasonality, product/client performance;
• documented procedures and tailored training.

Technologies

• Advanced Excel (INDEX/MATCH/SUMIF, pivot tables, optional macros);
• Visualization tools (Tableau, Power BI);
• Custom documentation and training.

Impact

• Shift from fragmented to unified management;
• Improved commercial and operational steering;
• Key indicators: inventory turnover, profitability, forecast reliability.

Adaptability

The system can be adapted to other contexts: cooperatives, small processing units, distributors. We enrich it with demand forecasting modules to reduce overstock and stockouts, maximizing margins.