A few years ago I was pursuing aquaponics as a hobby over the summer. It was clear then that economies of scale were rapidly driving down the costs of indoor horticulture. My aquaponics project failed, but the basic economics of grocery-attached farms make a lot of sense. I built a business model to determine the economics of running a farm in a shipping container that could be deployed to an underutilized Whole Foods parking lot.
The model accounted for a 81m3 shipping container being filled top-to-bottom with fruiting plants, like tomatoes, but it's easily adjustable to other plants, like lettuces. The model is pretty sensitive to things like the productive life of the plant, lead time to productivity, and sale price.
Selling heads of lettuce for $3 each yields around $6000/yr in gross revenue per container per year.
This was $17k net less $720 in labor, $6k in equipment, $3k in real estate and $1k in electricity. Lots of room for optimizations that could push this business over the $1B mark.
The model, in case anyone's interested: https://docs.google.com/spreadsheets/d/1DkjOIs7hXyxIiN_iWXK0...