One service in each channel from sales to contribution per crew hour, food cost per ticket and prime cost, the year by channel with a P&L, break-even in services a week, the four quarters and the cash floor, adjusted EBITDA, SDE and two offers for the business.
The file follows Quillfennel Street Kitchen, a fictional business with 2 food trucks, one rented commissary and four channels. Revenue is $974,900 from 500 services, adjusted EBITDA $78,299 (8.0%), and the business breaks even at about 8.0 services a week. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Food_Truck_Business_Model_Quillfennel.xlsx (21 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is the worked case of The Food Truck Owner. The book explains every assumption and every tab: why the crew is paid for the whole shift, why a price is tested against the contribution per crew hour and not the food alone, what a festival's fees take, why catering deposits are the customers' money, and how two buyers would value the business.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Eight tabs. Blue cells are inputs; every other cell is a formula.
Raise the street ticket. Type $17.00 for the street stop's average ticket and watch its contribution per crew hour. On 2026 volumes, the book puts the change at $24,681 a year after card fees and tax on tips.
Weigh a festival day. A festival day keeps $2,157.06 after its crew in the case, $1,464 more than two street stops. Raise the organizer's share or the booth fee and see where the day stops paying.
Reshape the seasons. Lower the first quarter's share of revenue on the Inputs tab and watch the Cash Floor tab, where the first quarter closed at -$18,788 of EBITDA in the case.
Yes. In the case, a street stop keeps $14.43 per crew hour after the crew, a partner venue evening $28.05, a festival day $41.48 and a catering event $50.62.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input, starting with services, tickets per service and the average ticket of each channel. Quillfennel and every figure in it are fictional case assumptions, not market data.