Operations & Database Overview
Live status across all farming cycles, central warehouse stock, and buyer trade fulfillment.
Active Farmers
2
2 Registered Ponds
Farming Cycles
2
1 In Progress, 1 Closed
Feed in Warehouse
4,825 kg
From 6,000 kg purchased
Harvested Fish in Stock
50 kg
Available for new buyer sales
Total Buyer Revenue
$2,675.00
From 1,050 kg fish sold
🐟 Active Pond Cycles
Loading cycles...
📦 Warehouse Stock Status (Doc 04)
Loading stock summary...
Team 1: Farmer Profiles, Membership Applications & Ponds
Handles farmer registration, application review with rejection reasons, decision audit history, and registered ponds.
📋 Membership Applications & Decision History
0 Pending
Key Learning Rule: Administrator reviews applications. A rejection requires a documented reason. A rejected application can be updated & resubmitted while strictly retaining all previous decision audit records.
| App # | Applicant Name | Phone | Address / Pond Location | Experience | Status | Decisions Count | Submitted Date | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading applications... | ||||||||
👨🌾 Approved Farmers Directory
| ID | Name | Phone | Address | Ponds |
|---|---|---|---|---|
| Loading farmers... | ||||
🏞️ Registered Ponds (1 Farmer ── many Ponds)
| Pond Code | Owner | Location | Size (m²) | Status |
|---|---|---|---|---|
| Loading ponds... | ||||
Team 2: Farming-Period Requests, Feed Plans & Daily Reports
Manages cycle approvals, feed delivery batches, farmer receipt confirmation, and daily pond observations.
🐟 Farming Periods (Cycles)
💡 Validation Integrity: A farmer may only request a period for a pond they own. The system validates that a pond cannot have overlapping active or requested periods.
| Cycle # | Pond | Farmer | Fish Species | Seed Qty | Start Date | Harvest Date | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading periods... | ||||||||
Central Warehouse Inventory Tracking (Doc 04 Standard)
Tracks receipts from suppliers, deliveries to farming periods, adjustments for damage/loss, and calculated remaining stock.
🌾 Operational Realism (FAO Standard): "Feed delivered to a farmer is not the same event as feed given to fish." Feed issued is stored at the farm; the farmer records daily amounts fed to fish separately. The central warehouse balance equals:
Purchased + Adjustments - Issued to Ponds.
📦 Central Warehouse Stock Balances
| Item Name | Category | Total Received | Adjustments (Loss/Count) | Issued to Ponds | Current Stock In Warehouse | Stock Level Status |
|---|---|---|---|---|---|---|
| Loading inventory... | ||||||
📥 Recent Supplier Purchases
| Date | Supplier | Item | Qty | Total Cost |
|---|---|---|---|---|
| Loading purchases... | ||||
⚠️ Stock Adjustments (Damage / Count Discrepancies)
| Date | Item | Qty Change | Reason | Auditor |
|---|---|---|---|---|
| Loading adjustments... | ||||
Team 3: Harvest Purchases, Buyer Orders & Sales Fulfillment
Records administrator harvest purchases from farmers, tracks available fish to prevent overselling, and fulfills future buyer orders.
🐟 Harvest Purchases & Available Fish (Cannot Sell More Than Available)
| Harvest # | Pond / Farmer | Date | Species | Total Harvested | Bought by Admin | Sold to Buyers | Available to Sell | Settlement Status | Action |
|---|---|---|---|---|---|---|---|---|---|
| Loading harvests... | |||||||||
📋 Future Buyer Orders (Partial & Full Fulfillment)
| Order # | Buyer | Needed Date | Req Qty | Fulfilled | Remaining | Status |
|---|---|---|---|---|---|---|
| Loading buyer orders... | ||||||
🚚 Fish Sales & Deliveries
| Sale # | Date | Buyer | Qty (kg) | Revenue | Payment | Delivery Ref |
|---|---|---|---|---|---|---|
| Loading sales... | ||||||
Financial Reports & Cycle Settlements
Transparent ledger accounting by farming period, farmer net earnings, and administrator consolidated trading margins.
🏦 Administrator Trading Ledger Summary
SUPPLIER INVENTORY EXPENSES
$4,950.00
Seed fish & feed stock purchases
FARMER PAYMENTS RECEIVED
$1,050.00
Installment cash inflows from farmers
HARVEST PAYOUT DISBURSED
$1,980.00
Paid to farmers for harvested fish
BUYER SALES REVENUE
$2,675.00
Cash & receivables from fish trading
📊 Period-Level P&L Statements (Farmer Income & Expenses)
| Period # | Pond | Farmer | Supplies Charged | Farmer Payments Made | Supply Balance Due | Harvest Purchased ($) | Net Farmer Position | Status |
|---|---|---|---|---|---|---|---|---|
| Loading period financials... | ||||||||
Suggested Sample Story: Dara Meas Demo Journey
Live, traceable walkthrough of Dara Meas's complete journey exactly as outlined in the course brief.
1
Dara Applies & Receives Rejection with Documented Reason
Dara Meas submitted application #1. The administrator rejected it with the documented reason: "Pond location is missing. Please specify district and commune." The rejection is permanently preserved in the decision history table.
Database: membership_applications (#1, Status: Approved) ── application_decisions (2 records: Rejected, then Approved)
2
Dara Updates, Resubmits, and Administrator Approves
Dara updated her location to Prek Russei, Kandal Stung, Kandal Province and resubmitted. The administrator approved it. Farmer profile #1 was automatically established without losing earlier decision logs.
Database: farmers (#1, Dara Meas, Active) ── membership_applications (linked to farmer #1)
3
Dara Registers Pond P-01 in Kandal
Dara registers Pond P-01 (600 m² surface area, irrigation canal water source) in Kandal Stung.
Database: ponds (pond_id: 1, pond_code: 'P-01', farmer_id: 1, size_sqm: 600)
4
Dara Requests Cycle; Admin Reviews & Assigns Tilapia Seed & Feed Plan
Dara requests a farming period. Administrator checks location, size, and timing, approves the cycle (#1), assigns 3,000 Nile Tilapia fingerlings, sets the start/harvest dates, and establishes the 3-stage feed plan.
Database: farming_periods (#1, fish_type_id: 1, seed_quantity: 3000) ── period_decisions (Approved)
5
Administrator Delivers Feed in Batches; Dara Confirms Receipts
Admin issues seed and delivers feed in 3 batches: Batch 1 (100kg Starter), Batch 2 (400kg Grower), and Batch 3 (300kg Finisher). Dara signs and confirms each receipt into farm storage.
Database: period_supplies (4 delivery records, total $880.00 charged, farmer_confirmed: 1)
6
Dara Enters Daily Reports (Distinct from Deliveries!)
Dara logs daily feedings (3kg - 15kg/day), water temperature (28°C - 30°C), fish mortality, and pond conditions across the 120-day cycle. Feed delivery to farm is kept completely distinct from daily feed consumed by fish.
Database: daily_reports (Unique per period & date, total 77.2 kg logged in sample snapshots)
7
Dara Makes Installment Payments Over Time
Dara pays multiple installments: $250.00 deposit (June), $300.00 installment (July), and $200.00 pre-harvest payment (September), totaling $750.00 paid towards her $880.00 supply charges.
Database: payments (3 separate dated installment records, total $750.00)
8
Future Buyer Order Placed by Olympic Market
Third-party wholesaler Olympic Central Market notifies administrator they will need 800 kg of Tilapia next month. Administrator logs Buyer Order #1.
Database: buyer_orders (order_id: 1, buyer_id: 1, requested_quantity_kg: 800, needed_by: '2026-09-30')
9
Harvest Purchase & Order Fulfillment Sale
Dara harvests 1,150 kg; Administrator purchases 1,100 kg @ $1.80/kg ($1,980.00 payable to Dara). The administrator matches 800 kg to fulfill Olympic Market's order @ $2.50/kg ($2,000.00) and sells 250 kg to a restaurant ($675.00). 50 kg remains in stock.
Database: harvest_purchases (#1, 1100 kg) ── fish_sales (Order #1 Fulfilled, 50 kg available)
10
Full Reconciliation & Period Closure
Administrator transfers $1,980.00 full harvest settlement to Dara's ABA account. The period is formally audited and closed: Supplies Charged ($880) - Payments Made ($750) = $130 net supply liability; Net Farmer Earnings = $1,850.00.
Database: period_closures (#1, net_farmer_earnings: $1,850.00, status: Closed)