Free pack preview
Review the assumptions before you buy
Read this first: the decision boundary
This pack is built for Kenyan produce aggregators, collection-centre operators, market traders and small distributors handling short-shelf-life crops.
Its practical outcome is: See true gross margin by lot and order after rejects, shrinkage, route cost and unpaid customer balances.
It is a recordkeeping and decision-support system. It does not replace a current official requirement, a signed contract, a lender's terms, or advice from a qualified professional. Prices, eligibility, rules and market access can change. Every material figure should be supported by a dated quotation, transaction record or authoritative source in the workbook's Sources tab.
The operating workflow
- Assign every intake a unique lot ID
- Record supplier, gross weight and buy price at receipt
- Grade promptly and document rejects or other disposition
- Reserve traceable quantities against orders
- Cost each collection and delivery route
- Close the day by reconciling quantities, cash and customer balances
Work in this order. A dashboard result without the underlying records is not evidence. If a step does not apply, mark it not applicable and explain why rather than deleting the control.
Research used in this guide
- Horticulture regulation and compliance — Agriculture and Food Authority
- National Horticulture Traceability System — Agriculture and Food Authority
- Pesticide regulation and safety information — Pest Control Products Board
- eTIMS onboarding — Kenya Revenue Authority