Working out how many trays to sow is one division, and the division is where it goes wrong. Trays = ounces wanted ÷ your yield a tray, and then one more step most growers skip: ÷ (1 − the share of trays you lose), rounded up. An order for 96 oz of sunflower at 14.5 oz a tray is 6.6 trays, which looks like seven. With one tray in ten lost to mold or poor germination, it's 7.4, which is eight. From the trays come the seed to weigh out, the rack space the variety takes when it's sown every week, and the seed cost against what the harvest sells for. Below is a week for a made-up grower, each sum, and the calculator. The yields, losses and prices are this grower's own, from its tray log. Yours are the ones to type.
The short version
- Trays to sow = ounces wanted ÷ yield a tray ÷ (1 − share lost), rounded up.
- Use your own yield, from weighed harvests.
- Count your losses. A lost tray is a tray you sowed.
- Seed needed = trays × seed a tray.
- Rack places = trays × days to harvest ÷ 7, for a variety sown weekly.
- Count back from the delivery day by the days to harvest.
- TaroStack records each harvest as a lot and what it used. More below.
A week's orders
| Variety | Wanted a week | Yield a tray | Trays lost | Trays to sow | Seed a tray | Seed needed | Seed price a lb | Seed cost | Days | Rack places | Price an oz | Sales | Seed, of sales |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sunflower | 96 oz | 14.5 oz | 10% | 8 | 150 g | 1,200 g | $4.50 | $11.90 | 10 | 12 | $1.50 | $144.00 | 8.3% |
| Pea shoots | 64 oz | 16.0 oz | 10% | 5 | 220 g | 1,100 g | $3.20 | $7.76 | 11 | 8 | $1.25 | $80.00 | 9.7% |
| Radish | 40 oz | 9.0 oz | 20% | 6 | 35 g | 210 g | $14.00 | $6.48 | 8 | 7 | $1.75 | $70.00 | 9.3% |
| Broccoli | 24 oz | 6.5 oz | 10% | 5 | 20 g | 100 g | $22.00 | $4.85 | 10 | 8 | $2.00 | $48.00 | 10.1% |
Twenty-four trays a week, 2,610 g of seed costing $31.00, for $342.00 of sales.
The sums
Trays. Sunflower: 96 ÷ 14.5 = 6.6 trays if every tray works. This grower loses about one in ten, so 6.6 ÷ 0.9 = 7.4, and it sows 8. Seven would have been enough only if nothing went wrong, and in most of this grower's weeks something does.
Losses change the answer most where they're highest. Radish yields 9.0 oz from a good tray here, and one tray in five is lost, most of them to mold under the dome. 40 ÷ 9.0 = 4.4 trays. With the losses it's 5.6, so six. Counting losses at 10% like the others would have said five, and five radish trays at this grower's real loss rate give about 36 oz for a 40 oz order.
Seed. Eight trays of sunflower at 150 g each is 1,200 g. Weigh it. At $4.50 a pound that's 1,200 ÷ 453.6 × $4.50 = $11.90.
Rack places. A tray of sunflower is on the rack for 10 days. Sown every week, eight trays need 8 × 10 ÷ 7 = 11.4 places, so 12. All four varieties together need 35 places. That number, not the 24 trays, is what the rack has to hold.
Seed against sales. Seed is between 8% and 10% of what each variety sells for here. The column is for spotting the variety where an expensive seed or a poor yield has pushed that share up.
When to sow
Count back from the day it's wanted. For a Thursday delivery, this grower sows sunflower and broccoli 10 days before, on a Monday, pea shoots 11 days before and radish 8 days before. A variety that's sown a day late is harvested a day short, and a short tray weighs less.
Where the yield comes from
From your own harvests, weighed, tray by tray: see microgreens log sheet. A yield from a chart or a seed catalog was grown in someone else's room. Use the average of your trays that were harvested, and count the ones that weren't as losses. Don't blend the two into one low average, or you can't see which problem you have: trays that yield poorly, or trays that fail.
What an ounce should sell for is in how to price microgreens. Seed, trays and clamshells on hand are in microgreens inventory spreadsheet, and the margin on a tray in microgreens profit margin.
Get the calculator
Download the microgreens yield calculator. One sheet and a read-me: type the ounces wanted, your yield a tray, the share of trays lost, the seed a tray and its price, the days to harvest and the price an ounce. It works out the trays to sow, the seed needed and its cost, the rack places, the sales and seed's share of them. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator is as good as two numbers, the yield and the loss, and it has no way to keep them current. A new lot of radish seed germinates worse, the room is colder in January, and the 9.0 oz that was true in October is 7.5 by winter. The sheet goes on dividing by 9.0. Orders come up short, and the grower sows an extra tray "to be safe" without knowing which number moved.
How TaroStack does it
TaroStack keeps the yield from the harvests themselves.
Receiving records each bag of seed as a lot, with the supplier's lot number and what you paid.
A sowing of trays is a batch. Record it and the seed comes off stock, by lot.
Each harvest is a lot with a date, and the batch records what went in and what came out.
Recipe truth, from your own batch history: whether a variety yields what its recipe says.
What ships is recorded by lot, so a restaurant's box leads back to the trays and the seed lot.
| The question | Calculator | In TaroStack |
|---|---|---|
| What radish really yields this month | The number typed in October | From your batches |
| Whether the new seed lot is worse | A feeling | Batches by seed lot |
| Seed left for next week's sowing | Weigh the bag | Stock on hand |
| Which trays went to which restaurant | Unknown | The lot on the delivery |
TaroStack doesn't schedule sowing days or control the grow room. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
