FarmDB Workbench — Grant 4-D Farms (Mockup B)

Planned Acres

36,412

+312 vs Build 1

Peak Borrowing (proj.)

$71.4M

line $86.5M · headroom $15.1M

Net Cash-Flow Margin

$8.9M

Build 3 · ±$3.2M price band

Open AR (crops)

$41.2M

$5.6M due this month

BC Reconciliation

✓ May

June closes in 3 days

Alerts

7

3 moisture · 2 certs · 2 variance

Monthly cash position — 2027 actuals ▮ / forecast ▯

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

The grid rule: everything here works like Excel — click column headers to sort, use the filter row, tick rows (or the header box), then change crop, variety, yield or dates for the whole selection at once. The status bar below sums your selection.

Fields

642

36,412 ac assigned

Unassigned

3

212 ac

Rotation warnings

4

potato-on-potato < 3yr

Plan cost

$31.8M

$873/ac avg

Build 3 vs 1

+$412k

view diff →

fx— click a row to inspect —

Find Region 2027 crop sample of 642 · click a header to sort ▲▼

	Field	Area · Director	Acres	2025	2026	2027 Crop	Variety	Bgt Yield	Buyer intent	Storage	Plant window	Plan $/ac	Rot ✓

Plan Seed Fert Chem Water

EBITDA (Build 3)

$18.2M

Build 1: $17.8M

Peak Borrowing

$71.4M

July · 6.3% APR

Op. interest (proj.)

$3.94M

renewal: June

Carry-in AR + COH

$48.7M

auto from CY26 PMDR

Scenario

Base

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	—	—

Monthly Income Sch Loan model

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 →

Crop value (CY27 proj.)

$104.7M

all crops · G4DF share

Contracted

61%

$63.9M committed

Open AR

$41.2M

CY26: $12.3M · CY27: $28.9M

Crops on hand

$18.4M

unsold @ proj. price

June BC recon

−$41k

2 unexplained items

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	—

Click headers to sort — e.g. sort by AR to work the collections list top-down.

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.

Open work orders

63

planting 0 · spray 41 · cult 22

Due this week

17

2,214 ac

Label checks

✓ 61

2 warnings

Operator gaps

1

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 →

Field

24-1

MV 1 · Josh · Whitesides Land Ranch

Acres (operating)

124.5

FSA 121.9 · pivot + corners

2026 Crop

Norkotah TX 278

planted Apr 22 · budget 385 cwt

Root-zone moisture

62 cb

refill at 60 · irrigate soon

Lease

$385/ac

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) full matrix →

PWSBWCWWP → SBWPH

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 →

YTD hours

148,212

vs budget −2.1%

YTD employer cost

$4.61M

wages + taxes + WC

This week

6,842 h

318 people clocked

OT %

6.8%

MV harvest prep

H-2A share

41%

FICA/FUTA-exempt burden

Region	Bud hrs (wk 27)	Act hrs	Var	$/hr eff.	Cost (wk)
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.

GAP audit readiness

72%

91 of 126 questions evidenced

Field risk assessments

64 / 111

potato + onion fields

Corrective actions

3 CAN

0 IAR open

Training current

94%

WPS 12 renewals pending

Policy acks

96%

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 ✓

Leases

137

$16.24M / yr

Expiring ≤ 18 mo

14

4,212 ac

Fall installments

$8.15M

due Nov 1

Pipeline (CRM)

6

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) · sortable columns — try Term to see what expires first

Rotation matrix: every field, every year, one screen — 2019 actuals through the 2030 plan (hatched columns are plan years). Click a year header to sort by that year's crop and see its acreage mix below. Hover any cell for the year mix too.

Region Ever grew P potato · SB beet · W/B grain · C corn · H hay · O onion · F fallow

Hover a cell or click a year header for that year's acreage by crop.

One map, three questions: what's planted where (2027), which ground is ours vs leased vs about to expire, and who needs water today. Switch layers, hover for details, click a field to pin it.

Layer Magic Valley — T9S R17E area (stylized) · pivots + gravity rectangles · click a field to pin

Field card

Click a field on the map to pin its details here.

FarmDB Grant 4-D Farms