ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
0-Inputs — Central Assumptions — Tweak Here — All Other Tabs Link Here
2
HOW TO USE: Change YELLOW cells (Col B) only. Other tabs = formulas to this tab. Low/High = sensitivity. Col D = source link.
3
Category / AssumptionValue (tweak)UnitSource / LinkPlain Note
4
FARM SCALE — 5641 Kahiliholo Rd
5
Ulu trees planted40treesDoc Step 5 — 30ft triangular (Honua 8465)40 x 30ft triangular
6
Spacing30ft triangularDoc Overall Layout — HonuaAvoid Easement A, 15ft setbacks
7
Mature fresh yield (mid plan)400lb/tree/yr
Doc Y6 — research 300-500 mid, guide 546, conservative 250
40x400=16,000 lb/yr Y6-Y10
8
Field-verify biennialTRUEReminder flag
9
FLOUR — Commodity Proven
10
Fresh to flour ratio0.2ratioDoc para 085-086 — 16k fresh -> 3.2k flour20% = 3200 lb flour
11
Flour price low16.5$/lb flourDoc Cash Flow — $16.50 lowFarmers-market
12
Flour price high18$/lb flourDoc Cash Flow — $18 highRetail $35 upside $112k
13
Flour price point (plan)17.25$/lb flourAverage low/highMid-low used for Base
14
→ Flour revenue Y6 mid moved to Tab 4 (B13) & Tab 3 (C11) as derived — see formulas
15
INTERCROP — Bridging Only
16
Base intercrop Y12500USD/yrDoc Cash Flow Y1 — pea/turmeric$2.5k bridging
17
Base intercrop Y23500USD/yrDoc Y2$3.5k Y2
18
Base intercrop Y3-Y102500USD/yrDoc Y3-Y10Steady $2.5k base
19
Full intercrop upside add (Tab9)25540USD/yrTab9-Intercrop Detail — if sell allNot in base; FULL only
20
INPUTS & LABOR — Field Ops
21
Annual inputs Y1750USD/yrDoc CF Y1 — cinder/compostY1 750
22
Annual inputs Y2600USD/yrDoc Y2
23
Annual inputs Y3-Y4600USD/yrDoc Y3-Y4
24
Annual inputs Y5650USD/yrDoc Y5
25
Annual inputs Y6-Y10700USD/yrDoc Y6-Y10700 mature
26
Labor cost35$/hrDoc Labor — 56hr Y0 base = $1,960$35 all years
27
Y0 labor total56hrTab2-Labor — 14+44+18=56 base; 76 full56hr=$1,960; 76hr=$2,660
28
Y1 labor hrs62hrTab2 — 2+60$2,170
29
Y2 labor hrs52hrTab2$1,820
30
Y3-Y4 labor hrs74hrTab2$2,590
31
Y5 labor hrs78hrTab2$2,730
32
Y6-Y10 labor hrs96hrTab2 — 90+6$3,360
33
Power $100-200/mo — EXCLUDED0
USD/yr — excluded
Doc footnote — exclude until meteredIntentionally 0
34
UPFRONT CORE — Y0 One-Time
35
Greenhouse 30x48 mid15000USDDoc Table — 10x30 $5-8k -> 30x48 $15-25kNursery
36
Ghost Container 40ft $40k — REMOVED0
USD — REMOVED 2026-10-13
Was $40k/$70k — replaced by detailed $24.2k — deletedNo longer counted
37
Processing (flour core) — dryer+mill+pack+freezers12000USDDoc Table — $12k-18kNo fryer
38
Orchard — 40 Ulu + cinder + drip + seed3000USDDoc Step 5 — Tab1 B$1.4k trees + $0.8k soil + $0.5k drip + $0.3k seed
39
Detailed Container Facility (replaces ghost)24200USDTab1 detailed sum — 10 lines51.2k total facilities
40
Core Facilities total51200USDGreenhouse+detailed+processing15k+24.2k+12k
41
Core A+B (Facilities+Orchard)54200USD51.2k+3k$54.2k materials
42
Contingency 10% Core only5420USD10% not midpoint$5.42k
43
TOTAL Core + Contingency (materials)59620USDCore+contingency$59.6k / $95.6k high
44
Upfront point used in Cash Flow Y085000USDWeighted low + labor buffer — Doc 015-017Y0 -$87,460 = $85k + $1,960 labor
45
PILOTS — Optional (not base break-even)
46
Vanilla 0.5ac — 350 vines + shade + mist31000USDTab7 — $25.2k-39.3k$31k point — gate Y3
47
Matcha 0.25ac + stone mill 10-micron15000USDTab8 — $12k-20k$15k point — bridge Y1-5
48
Total with pilots (if all Y0)123000USD59.6k+46k$123k; base $59.6k
49
VANILLA INPUTS (Tab7 links here)
50
Vines350vinesTab7 — Tahitian 350 @ $12-180.5ac
51
Cured yield low28kg cured lowTab7 — 140-280kg green -> 28-56kg20% cure
52
Cured yield high56kg cured highTab7
53
Cured price low170$/kg lowHawaii Vanilla Co $190/lb=$419/kgWholesale
54
Cured price point300$/kg pointMid Kauai direct
55
Cured price high419$/kg highRetail
56
Annual care (labor+cure)6600USD/yrTab7 — $4.2k field + $1.4k cure + $1k inputsY1-Y10
57
MATCHA INPUTS (Tab8 links here)
58
Tea bushes1000bushesTab8 — Yabukita/Uji 0.25ac~1000 @ $8 + bark
59
Stone mill target10micronsMarukyu Koyamaen <10μ — Tab8<10μ
60
Bridge tencha buy Y1-520kg/yr @ ~$50/kgMarukyu $38-68 wholesale$1k cost -> $1.7k net
61
Own leaf Y515kg Y5Tab8 — 15kg Y5@ $120-300/kg
62
Own leaf Y625kg Y6Tab8
63
Own leaf Y7+ mature35kg/yrTab8 — 35-50kg Y7+
64
Own matcha price point171$/kgTsuji Midori $299 bench — conservative$6k rev -> $3k net
65
CASH FLOW LOGIC (Tab3 reads these)
66
Total Base Income = Flour + Base IntercropTab3 formulaDerived: see Tab 4 B13 (flour mid) + B18 (intercrop)
67
Base Net = Income - Inputs - LaborTab3
68
Base Cum = prior Cum + NetTab3Y0 -$87,460 incl upfront
69
MANAGER SCENARIOS (Tab10 — not in base)
70
Contractor -> full-time87000USD/yr if factoryTab10 — $3.36k -> $43.7k -> $87.5kOnly if factory proven
71
Last updated2026-10-13
by Atlas — doc rev 2026-10-13
GSheet 1_Ts3cv2FE7I2-gc5SMdk4d3pAvxY3hWs2jRyDJWScYo — yellow = named inp_*
72
73
74
INTERCROP DETAIL — independent inputs for +$25.5k build (all yellow, feed Tab 9 formulas)
75
Pigeon pea — marketable yield, point1000lb/acTab 9 — 700 low / 1200 high — 1.0 ac hedgerowCTAHR 2.5 T/ac × 50 lb N/T
76
Pigeon pea — price, point5$/lb driedTab 9 — $5 low / $7 highFarmLink $5-7
77
Turmeric — fresh yield on 0.8ac shoulders, point6400lb fresh0.8ac × 8000 lb/ac — 5120 low / 7680 highKirk 2022; mdpi 11.3-57 t/ha
78
Turmeric — price, point3.6$/lb freshTab 9 — $3 low / $5 highFarmLink $3-5
79
Base intercrop Y3 (first ulu — light)660USD/yrCash Flow Y3 — light harvest while roots establishDerived: see Base Y3 note
80
Full intercrop gross, point (if all sold)28040USD/yr#ERROR!#ERROR!
81
Intercrop inputs live: change yellow and Tab 9 + Cash Flow update via formulas — no typed $ in formula tabs
82
83
Vanilla — point cured yield (mature)40kg curedMid of 28 low / 56 high — 350 vines × 0.11 kgNot low/high — point for model
84
Vanilla inputs feed Tab 7 — change yellow → Tab 7 C15 etc. update → Tab 3 J pulls from Tab 7 H21:H30 via formula
85
PROCESSING FACTORY — independent inputs (all yellow, feed Tab 11 formulas) — change here, Tabs 11-12-14 update
86
Ulu purchased (Line A)4000lb/yrprocessing_plan.md A — 10k raw = 4k purchased + 6k ownCost = price × qty
87
Ulu purchase price0.9$/lbprocessing_plan.md A — sensitivity $0.90→$1.20 testableTab 11 D8 =B86*C86
88
Avocado oil net consumption60gal/yrprocessing_plan.md A — Pitco SG14 40-50lb oilTab 11 D9 =B87*C87
89
Avocado oil price24$/galprocessing_plan.md A — $24/gal
90
Oil filtration/disposal560USD/yrP18 filtration — Pitco P18 $5,006-$5,661
91
Pouch + label unit cost0.95$/unitprocessing_plan.md A — 13,200 pouchesTest $0.95→$1.20
92
Carton/insert unit cost0.2$/unitprocessing_plan.md A — 13,200 cartons
93
Chips blended price (13,200 bags = $131,600) → $9.97/bag9.97$/bag$131,600/13,200Revenue = qty × price
94
Banana (Line B)4000lbprocessing_plan.md B — own+purchase
95
Banana price0.3$/lbprocessing_plan.md B
96
Ginger+turmeric1200lbprocessing_plan.md B
97
Ginger/turmeric price0.4$/lbprocessing_plan.md B
98
Mac nuts in-shell2200lbprocessing_plan.md B
99
Mac price0.5$/lbprocessing_plan.md B
100
Dried packs unit cost0.8$/unitprocessing_plan.md B — 3,200 packs