How do production, biological, capacity, and sales assumptions shape the operating plan?
Model profile
Mango Agri-business
Greenfield drip-irrigated mango orchard of grafted Kent, Keitt and Amelie trees with a tree-age yield curve and alternate bearing, a harvest calendar set by country (West, East or Southern Africa), managed water stress before flowering, outgrower fruit purchases on a regional sourcing calendar, a packhouse and processing plant built in two stages and sized on the peak month, class I export and class II local-market fresh fruit, dried mango slices, aseptic pulp and nectar sold through the year, with peel and stones as a byproduct, an editable recipe mix, financing, and returns, with Côte d'Ivoire as the default country.
Decision scope
Questions this model helps you examine
What working capital, asset, debt, and equity funding does the project require?
How do changes in yields, prices, costs, or timing affect returns and resilience?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- 1,500 ha greenfield grafted mango orchard planted in three phases, bearing from year four
- Yield set from trees per hectare and fruit per tree, with alternate bearing
- Harvest calendar and irrigation profile set by country: West, East or Southern Africa
- Class I export, class II local market, dried mango, pulp and nectar recipes with an editable mix
- Drip irrigation by tree age and month, with water stress before flowering
- Selectable country and planning horizon
- Base case and eight stress scenarios
- Risk analytics
- XLSX and PDF exports
Build the case
Inputs and workspaces
- AssumptionsCore model inputs
- FarmingLand, crops, water
- StorageCapacity and losses
- ManufacturingProducts and throughput
- CommercialSales and collections
- FundingDebt, equity, covenants
- Advanced schedulesSpecialist operations, staff, asset, and master-data tables
- Risk & analyticsScenarios and predictive models
Review the result
Outputs and analysis
- Project NPVUSD
- Project IRRPre-tax
- Minimum DSCRLowest period
- Output hashSHA-256
- FarmingDetailed schedules
- StorageDetailed schedules
- ManufacturingDetailed schedules
- CommercialDetailed schedules
- FinancialDetailed schedules
- Supporting schedulesDetailed schedules
- Risk & predictiveDetailed schedules
Designed for review
Who this model is for
- Farm and project owners
- Operating teams
- Financial advisers
- Investors and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?