Africa Coffee Park — Executive Analytics
Inspire Africa Group · Rwashameire, Ntungamo, Uganda
🔔 0
Notifications
No new notifications
← ERP Hub
CEO: Nelson Tugume  |  Analytics Oversight: Kubariho Venture (Project Manager) — kubariho@africacoffeepark.com
Cross-Module KPIs — Live from ERP
Production Output (Last 7 Runs)
Programme of Works Progress
Quality Snapshot
Inventory Alerts
Open Issues Across ERP
All Department Scorecards
Production Runs — Output (kg)
Line Utilisation
Waste by Type (kg)
Downtime Events
Budget vs Actual (by Category)
Invoice Status
Recent Ledger Transactions
Staff by Department
Leave Status Today
Training Completion
Performance Ratings
QC Check Pass/Fail Rate
Cupping Scores
Active Certifications
Zone Progress
Equipment Status
Snag List by Priority
Active Contractors
Period Comparison — Month vs Month
Trend Charts
Production Output (kg)
Export Orders
System-wide Activity Log
Export Reports: Download CSV files from ERP data or generate print-ready PDF reports. CSV exports use current localStorage data.
How to Use — Executive Analytics
Step-by-step guidance for Management, Department Heads, and Data Coordinators
Overview Dashboard

The Overview tab aggregates live KPIs from all ERP modules including Revenue YTD, Employees, Production Output, Export Orders, Asset Value, Farm Harvest, Tourism Bookings, and Open Purchase Orders.

Tip: The Overview should be the first screen Nelson Tugume and Kubariho Venture check each morning. Data is pulled from localStorage in real time from all ERP modules.
  1. KPI cards at the top show headline numbers from all modules simultaneously.
  2. Charts show the most recent 7 days of production data and POW phase progress.
  3. The cross-module grid gives a single-screen CEO summary without navigating modules.
🏢 Department Analytics

The Departments tab shows per-department performance summaries: headcount, budget utilisation, open tasks, and risk indicators.

Tip: Use this view in the weekly management meeting. Departments showing amber or red status need a verbal update from their head before the meeting closes.
  1. Each department card shows live KPIs pulled from that module's localStorage.
  2. Click a department card to drill into that department's ERP module.
  3. Department heads should ensure their module data is current before Monday management reviews.
Production & Quality Analytics

The Production and Quality tabs visualise trends in coffee processing output, rejection rates, cupping scores, and batch yield.

Tip: Track cupping score trends weekly. If the rolling average drops below 78, initiate a process review with the Quality and Production teams immediately.
  1. Charts auto-populate from the Production and Quality ERP modules.
  2. Use the Export Reports tab to generate a CSV or print-ready summary.
  3. Waste and downtime charts identify the highest-impact problem categories.
📈 Period Comparison

The Comparison tab lets you select two months (Jan–Mar 2026) and compare KPIs side by side including production output, export orders, staff count, revenue, and harvest volumes.

Tip: Use the Comparison tab for board-level reporting to show month-on-month growth. Green arrows indicate improvement; red arrows indicate decline.
  1. Select Month 1 and Month 2 from the dropdowns.
  2. Click Compare to generate the side-by-side table with change percentage and trend arrows.
  3. Trend charts below show bar visualisations for each period.
📄 Export Reports

The Export Reports tab provides ready-made data exports for all key operational datasets. Each report can be downloaded as a CSV or printed as a formal PDF report.

Tip: Run the Payroll Summary and Asset Register monthly for Finance and Audit. Export orders CSV is required for UCDA compliance reporting.
  1. Click Export CSV to download a comma-separated file of the dataset.
  2. Click Print Report to open a formatted print view with the IACP letterhead.
  3. All CSV exports use current localStorage data — ensure modules are up to date before exporting.
👤 People Analytics & Activity Feed

The People tab shows workforce metrics: headcount by department, attendance, leave, and training. The Activity Feed provides a unified audit log across all modules including payroll runs, new hires, harvest records, export orders, work orders, and procurement approvals.

Tip: Filter the Activity Feed by module to trace specific events. The feed pulls from payroll, HR, harvest, export, maintenance, and procurement localStorage keys.
  1. Use the module filter dropdown to narrow the feed to a specific department.
  2. Each feed item shows a module badge, user avatar, description, and timestamp.
  3. Export activity logs monthly for compliance archiving using the Export Reports tab.