Dashboard
vs Build 1 Mockup C — Ledger TG36,412
Planned acres
+312 vs Build 1
$71.4M
Peak borrowing (proj.)
line $86.5M · headroom $15.1M
$8.9M
Net cash-flow margin
Build 3 · ±$3.2M price band
$41.2M
Open AR (crops)
$5.6M due this month
May ✓
BC reconciliation
June closes in 3 days
7
Alerts
3 moisture · 2 certs · 2 variance
Monthly cash position — 2027 actuals solid · forecast light
Exception queue view all →
| Moisture | 24-3 root zone past refill 14h — no irrigation event detected | → Josh |
| Variance | Fert spend MV +$212k vs Build 3 (June) | → Taylor |
| Cert | 2 applicator licenses expire in 30 days | → HR |
| Loads | Acuitus: 3 tickets missing seq. #s, field Chandler | → review |
| PMDR | McCain contract 27-114: over-delivered 2.1% | → Ag |
| Lease | Mohlman lease renewal window opens Aug 1 | → Taylor |
Planned acres by crop (Build 3)
| Potato | 9,221 | 25.3% | |
| Sugarbeet | 7,644 | 21.0% | |
| Wheat / Barley | 9,010 | 24.7% | |
| Corn (silage/HM) | 4,868 | 13.4% | |
| Hay / Triticale | 3,912 | 10.7% | |
| Onion | 1,757 | 4.8% |
Live feeds last sync
| Business Central GL (14 companies) | synced | 02:10 |
| FieldClix timecards | synced | 05:00 |
| Verus soil moisture (136 devices) | synced | 06:00 |
| Stukenholtz lab results | synced | 04:30 |
| Truck Load Tracker | live | — |
| Acuitus potato tickets | 3 QA holds | 05:15 |
Field detail
Hover a field for a summary. Click to pin it here.
Stylized layout — not to scale. Live version renders FSA CLU boundaries on MapLibre (see lease-tool POC). Half & quarter pivots shown where wheel lines were converted.
The grid rule: everything here works like Excel — sort any column, filter, click rows (or select several), then change crop, variety, yield, or dates for the whole selection at once.
642
Fields
36,412 ac assigned
3
Unassigned
212 ac
4
Rotation warnings
potato-on-potato < 3yr
$31.8M
Plan cost
$873/ac avg
| Field | Area · Director | Acres | 2025 | 2026 | 2027 Crop | Variety | Bgt Yield | Buyer intent | Storage | Plant window | Rot | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24-1 | MV 1 · Josh | 124.5 | Wheat | Potato | Sugarbeet | — | 42 t | SRCOOP | — | Apr 10–18 | ✓ | |
| 24-3 | MV 1 · Josh | 121.5 | Wheat | Potato | Sugarbeet | — | 42 t | SRCOOP | — | Apr 10–18 | ✓ | |
| 24-4 | MV 1 · Josh | 121.0 | Sugarbeet | Potato | Wheat | Brundage | 135 bu | open | Bin 12 | Apr 2–8 | ✓ | |
| Chandler | MV 2 · Pete | 72.0 | Potato | Corn 7P9496 | Barley | AB Voyager | 142 bu | Anheuser-Busch | Bag 3 | Mar 28–Apr 5 | ✓ | |
| KR-63 | LSR · Dean | 125.5 | Silage | Potato | Potato | Rus. Norkotah TX 278 | 385 cwt | McCain | Cellar K2 | Apr 14–22 | 2yr | |
| KR-64 | LSR · Dean | 125.5 | Potato | Wheat | Onion | Vaquero | 620 cwt | open | Shed 2 | Mar 25–Apr 2 | ✓ | |
| C Crane Home | MV 4 · W-4 | 133.0 | Ranger | Wheat | Potato | Ranger Russet | 372 cwt | Lamb | Cellar C1 | Apr 16–24 | ✓ | |
| Schell East N | MV 3 · Mendez | 122.9 | Barley | Burbank | Sugarbeet | — | 41 t | SRCOOP | — | Apr 8–15 | ✓ | |
| Hruza Home | MV 2 · Josh | 230.0 | Sugarbeet | Burbank | Wheat | UI Magic | 128 bu | open | Bag 1–2 | Apr 1–9 | ✓ | |
| Tate | MV 1 · Gerardo | 89.1 | Norkotah | Wheat | Triticale | — | 5.2 t | dairy dir. | — | Sep (fall) | ✓ | |
| Barendregt E | MV 3 · Mendez | 121.0 | Onion | Wheat | Potato | Clearwater | 368 cwt | Mart | Cellar B4 | Apr 12–20 | ✓ | |
| Shigihara Pivot | MV 1 · Gerardo | 95.0 | Wheat | Norkotah | HM Corn | P9998 | 31 t | feedlot | Pit 1 | Apr 20–28 | ✓ |
PotatoBeetGrainCornHayOnionselect rows to open the bulk-action bar
The rotation columns from the Excel cropplan — one row per field, one column per year. 2019–2026 are as-planted; 2027–2030 (hatched) are plan. Click a year header to sort fields by that year's crop; hover any year to read its acreage mix below.
$18.2M
EBITDA (Build 3)
Build 1: $17.8M
$71.4M
Peak borrowing
July · 6.3% APR
$3.94M
Op. interest (proj.)
renewal: June
$48.7M
Carry-in AR + COH
auto from CY26 PMDR
Base
Scenario
price −10% → peak $76.8M
| Account (BC GL) | FY Budget | Jan | Feb | Mar | Apr | May | Jun | Jul | …Dec | Actual YTD | Var |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Seed (5210) | 4,812k | 120k | 385k | 1,270k | 2,140k | 720k | 95k | 40k | 42k | 4,655k | −3.2% |
| Fertilizer (5220) | 6,105k | 85k | 310k | 1,480k | 1,730k | 880k | 640k | 505k | 475k | 5,020k | +4.4% |
| Chemical (5230) | 4,470k | 25k | 60k | 410k | 660k | 905k | 830k | 640k | 940k | 2,890k | −1.1% |
| Rent (5410) | 16,240k | 150k | 210k | 6,850k | 420k | 180k | 160k | 120k | 8,150k | 7,810k | 0.0% |
| Labor (5510) | 10,890k | 720k | 705k | 860k | 1,010k | 1,050k | 1,015k | 990k | 880k | 5,360k | +2.8% |
| Water & Power (5610) | 3,180k | 45k | 48k | 120k | 290k | 420k | 520k | 585k | 95k | 1,443k | −0.8% |
| Crop Ins (5710) | 1,410k | — | — | 705k | — | — | — | 705k | — | 705k | 0.0% |
| Total cash expense | 62,410k | 2,010k | 2,480k | 13,910k | 8,120k | 5,690k | 4,480k | 4,010k | 11,660k | 31,180k | +1.9% |
| Crop receipts | 78,940k | 6,210k | 4,180k | 2,910k | 1,850k | 1,540k | 2,220k | 3,180k | 14,820k | 21,470k | +2.4% |
| Operating loan balance | — | 54,210k | 55,930k | 64,120k | 67,400k | 69,210k | 70,860k | 71,420k | 52,110k | — | — |
Closed months (Jan–May) show BC actuals; open months show Build 3 forecast · payment-timing curves: edit reference data → · push CY2027-B3 to Business Central →
$104.7M
Crop value (CY27 proj.)
all crops · G4DF share
61%
Contracted
$63.9M committed
$41.2M
Open AR
CY26: $12.3M · CY27: $28.9M
$18.4M
Crops on hand
unsold @ proj. price
−$41k
June BC recon
2 unexplained items
Contracts click headers to sort
| Contract | Crop · Class | Buyer | Qty | Price | Delivered | Status | AR | Next pmt |
|---|---|---|---|---|---|---|---|---|
| 27-114 | Potato Norkotah | McCain | 610k cwt | $9.85 | 0% | committed | — | Oct 15 |
| 27-102 | Potato Burbank | Lamb Weston | 480k cwt | $10.40 | 0% | committed | — | Nov 1 |
| 26-088 | Potato Burbank | Mart | 390k cwt | $9.10 | 84% | delivering | $3.41M | Jul 20 |
| 27-201 | Sugarbeet | SRCOOP (shares) | 7,644 ac | est $42/t | — | share | $8.9M | 45% Dec |
| 27-310 | Barley Voyager | Anheuser-Busch | 520k bu | $7.15 | 0% | committed | — | Sep 30 |
| 26-071 | Wheat HRW | Scoular | 310k bu | $6.20 | 100% | settling | $0.94M | Jul 8 |
| — | Onion Vaquero | unsold (NPE) | 1.02M cwt | proj $8.25 | — | open | COH $8.4M | — |
Monthly reconciliation — disposition vs BC income
| Mar | $6.21M / $6.21M | ✓ |
| Apr | $4.83M / $4.83M | ✓ |
| May | $3.92M / $3.92M | ✓ |
| Jun | $4.46M / $4.50M | −$41k · 2 items |
Dimensions: Growing Cycle · Crop · Location · Entity. Invoice-from-contract enforced; post-invoice contract edits route to Finance approval.
Position at control date (12/31 snapshot)
| AR carry to CY28 | $36.2M proj. |
| COH carry | $14.1M proj. |
| Auto-opens CY28 plan | no rekeying |
The AgWorld fix: one operation, many fields — edit the parent once. Select rows and use the bulk bar: shift all dates, swap a product everywhere, reassign an operator — one action, preview, undo.
63
Open work orders
planting 0 · spray 41 · cult 22
17
Due this week
2,214 ac
61 ✓
Label checks
2 warnings
1
Operator gaps
WPS lapsed — J. Rios
| Operation | Field | Ac | Products | Method | Due | Operator | Label | Status | |
|---|---|---|---|---|---|---|---|---|---|
| Spider mite spray op #227 | Chandler | 72.0 | Oberon 4 SC 8 floz + Masterlock 4 floz | Aerial | Jul 15 | Valley Air | REI 12h · PHI 5d ✓ | todo | |
| Spider mite spray op #227 | Childs 1 & 2 | 64.0 | Oberon 4 SC 8 floz + Masterlock 4 floz | Aerial | Jul 15 | Valley Air | ✓ | todo | |
| Spider mite spray op #227 | DG-1 | 150.0 | Oberon 4 SC 8 floz + Masterlock 4 floz | Aerial | Jul 15 | Valley Air | ✓ | todo | |
| Spider mite spray op #227 | Eden | 142.0 | Oberon 4 SC 8 floz + Masterlock 4 floz | Aerial | Jul 15 | Valley Air | wind > label max fcst | todo | |
| Fungicide chemigation op #231 | 24-1 | 124.5 | Tetraban 9.5 floz + Regent 4 SC 3.2 floz | Chemigation | Jul 12 | J. Rios | ✓ | blocked — WPS lapsed | |
| Fungicide chemigation op #231 | 24-3 | 121.5 | Tetraban 9.5 floz + Regent 4 SC 3.2 floz | Chemigation | Jul 12 | M. Silva | ✓ | scheduled | |
| Cultivate beets G2 op #218 | Schell East N | 122.9 | — | Cultivator | Jul 9 | Crew 2 | — | in progress 60% | |
| Kill vines — early dig op #240 | KR-63 | 125.5 | shredder + desiccant TBD | Shredder | Aug 20 | Crew 5 | pending plan | todo |
Spray sheet prints bilingual with mix math, map, REI/PHI + signature · operators without current WPS/applicator cert cannot be assigned · send to WhatsApp →
24-1
Field
MV 1 · Josh · Whitesides Land Ranch
124.5
Acres (operating)
FSA 121.9 · pivot + corners
Norkotah TX 278
2026 crop
planted Apr 22 · budget 385 cwt
62 cb
Root-zone moisture
refill at 60 · irrigate soon
$385/ac
Lease
expires 2028 · fall inst. unpaid
Soil moisture — Verus DIRTdot B40TVN946YHAR8P 7 days
Sawtooth = irrigation sets · rain Jul 1: 0.32" · WhatsApp alert sent to Josh 06:10
Fertility (petiole) & agronomy
| Soil sample 3/14 | N 46 · P 18 · K 310 · pH 7.9 | lab pdf |
| Lab rec N total | 240 lbs/ac | Stukenholtz |
| Applied to date | 198 lbs/ac | |
| Petiole NO₃ 6/24 | 17,800 ppm | on curve |
| Next tissue pull | Jul 8 | weekly cadence |
Rotation (2019 → plan 2030)
PWSBPCWWP → SBWPH full matrix →
This year's records
| Apr 22 | Planted — Norkotah TX 278, 34" rows, Group 2 | planter monitor |
| May 30 | Hilled + Dual Magnum layby | WO #188 ✓ |
| Jun 12 | Fungicide chemigation #1 | WO #204 ✓ |
| Jun 29 | Fert order 2.1t 28-0-0 approved | petiole → |
| Jul 12 | Fungicide chemigation #2 | WO #231 scheduled |
Economics (Build 3)
| Budget cost | $837.80/ac | $104,306 |
| Actual to date | $602.10/ac | $74,961 |
| Proj. revenue @ 385 cwt × $9.85 | $3,792/ac | $472,082 |
| Contribution margin proj. | $1,822/ac | $226,839 |
| GAP field risk assessment | 9/15 | finish → |
148,212
YTD hours
vs budget −2.1%
$4.61M
YTD employer cost
wages + taxes + WC
6,842 h
This week
318 people clocked
6.8%
OT %
MV harvest prep
41%
H-2A share
FICA/FUTA-exempt burden
Hours vs budget — week 27
| Region | Bud hrs | Act hrs | Var | $/hr eff. | Cost (wk) | Trend |
|---|---|---|---|---|---|---|
| Magic Valley | 4,610 | 4,388 | −4.8% | 21.40 | $93.9k | |
| Lower Snake River | 1,240 | 1,371 | +10.6% | 22.10 | $30.3k | |
| Baker City | 720 | 695 | −3.5% | 20.80 | $14.5k | |
| Admin | 310 | 311 | +0.3% | 46.60 | $14.5k | |
| Shop / Mechanics | 480 | 522 | +8.8% | 28.30 | $14.8k |
Skills & placement 2027 review cycle
| Assessments complete | 214 / 341 | |
| Question-bank tests taken | 96 | avg 71% · EN 58 / ES 38 |
| Reviewer normalization | 9 managers | factors 0.85–1.10 |
| Placement recs ready | 88 | review queue → |
| Pending WPS renewals | 12 | alerts sent |
Wage decisions entered in Paylocity; FarmDB stores the rationale (test %, matrix score, band position). Timecards: FieldClix, synced 05:00 daily.
72%
GAP audit readiness
91 of 126 questions evidenced
64 / 111
Field risk assessments
potato + onion fields
3 CAN
Corrective actions
0 IAR open
94%
Training current
WPS 12 renewals pending
96%
Policy acks
2026 handbook v3
Harmonized GAP — evidence auto-filled from FarmDB
| G-4 Worker education & training | auto ✓ | SafetyTracker records |
| G-6 Traceability | auto ✓ | load tracker + lots (1-up/1-back) |
| G-11 Ag & cleaning chemicals | auto ✓ | spray records, REI/PHI |
| F-4 Water management plan | 2 tests due | upload July samples |
| F-6 Soil amendments | auto ✓ | application ledger |
| G-7 Recall program | mock recall due Aug | schedule → |
Certifications & training queue
| J. Rios — WPS handler | lapsed 6/28 | blocks WO #231 |
| 2 × applicator license | 30 days | renewal booked |
| CDL — 3 drivers | current | med cards 2027 |
| Forklift refresher (cellar crew) | Sep | before harvest |
| New-hire safety orientation | 6 this wk | bilingual ✓ |
137
Leases
$16.24M / yr
14
Expiring ≤ 18 mo
4,212 ac
$8.15M
Fall installments
due Nov 1
6
Pipeline (CRM)
2 proposals out
| Lease | Landlord | Farmed ac | Rent/ac | Basis | Annual | Term | Spring | Fall | |
|---|---|---|---|---|---|---|---|---|---|
| Whitesides Land Ranch | R. Whitesides | 1,412 | $385 | rotation-weighted | $543,620 | 2028 | paid #4471 | unpaid | calc → |
| Mohlman | D. Mohlman | 618 | $402 | rotation-weighted | $248,436 | 2027 | paid #4468 | unpaid | renew → |
| Ron Holton | R. Holton | 947 | $371 | rotation-weighted −wheel line | $351,337 | 2029 | paid | unpaid | calc → |
| University of Idaho | UI Foundation | 263 | $340 | fixed + CPI | $89,420 | 2031 | paid | paid | |
| RLDR LLC (Honsinger) | RLDR LLC | 53 | $355 | fixed | $18,815 | 2027 | paid | unpaid | renew → |
Rent engine: regional baselines → per-farm adjustments → rotation-weighted, term-discounted (from the 2027 Rent Pricing model) · proposals → lease docs → e-sign (existing pipeline) · payments post to Rent Exp (5410)