Furrow-Irrigated Tomato Profit Planner (Excel + PDF Guide) — Cost per Crate, Break-even, Irrigation Schedule & Season Records

Know your cost per crate and break-even BEFORE you transplant. Tomatoes can be the most profitable crop on a small farm, or the fastest way to lose money. This bundle gives you an Excel planner for a furrow-irrigated tomato plot (default half an acre) plus a short, practical PDF guide so you plan the season with real numbers.

1) Tomato Profit Planner (Excel, 9 sheets, Arial, yellow cells = type here, grey cells = automatic):

• Start Here – 5-step guide.
• Settings – farm name, season start, area, plants per acre, kg per plant, crate size, low/expected/high prices, loss %.
• Cost Plan – 22 example activities across land prep, seedlings, manure & fertiliser, crop protection, furrow irrigation (pump fuel, furrow making, canal cleaning), labour, staking, harvest crates, transport; cost by category, total and per acre.
• Profit Check – crates expected after losses, cost per crate, break-even crates and break-even price, profit at 3 prices, return per KES 1 spent, and a 3 x 3 yield-by-price scenario grid.
• Irrigation Schedule – 16-week furrow-irrigation planner by crop stage with pump hours, fuel litres and fuel cost per week (flows into the Cost Plan automatically).
• Expense Log (250 rows) and Sales Log (200 rows) for the real season.
• Monthly Summary – money out, money in, balance and cumulative for 12 months.
• Season Report – plan vs actual by category, revenue and profit.

2) Furrow-Irrigated Tomatoes: a Short Profit Guide (PDF, 7 pages): why plan before you plant; choosing the site and making ridges and furrows; transplanting and spacing; furrow irrigation basics (when to irrigate, signs of over- and under-watering, water-saving tips); feeding, staking and pruning; common problems to watch; harvest, grading and selling (brokers vs markets); how to use the planner; and a worked example.

Example built in: 0.5 acre, 5,000 plants, 3 kg per plant, 15% losses = about 199 crates (64 kg). Cost KES 190,250, cost per crate KES 955, break-even 63 crates at KES 3,000, profit KES 407,406. Edit every number to match your farm.

Works in: Microsoft Excel 2010+, WPS Office, LibreOffice and Google Sheets (upload). Phone-friendly. No macros, zero formula errors. Files come as one ZIP (Excel + PDF).

Prices and yields are editable typical values, not advice. For pesticides, fertiliser rates and water schedules, consult your agronomist or extension officer.

Made by Alphonce Kirui, a working farmer in Bomet. Instant download after payment. Questions? WhatsApp 0728 801 352 or visit www.alphoncekirui.com.