Food truck break even analysis: sales per trading day

Food truck break even analysis divides the costs that must be covered by the contribution earned on each order. Calculate an event threshold and a full operating threshold, because a day can pay its own crew and venue bill while contributing too little toward the truck's monthly costs.

Start with trading-day records

Export sales by business date and event, including completed orders, discounts, refunds and net food and beverage sales. Add ingredient usage, packaging, processor charges, venue contracts, crew costs, fuel and the monthly expense ledger. Give each event the same identifier across the files so a booking fee cannot drift into another day's result.

Use revenue before fees when the fees are listed separately as costs. Exclude taxes collected on behalf of the government: IRS Publication 334 distinguishes buyer-imposed sales tax collections from business income. Keep tips passed to staff separate from the truck's sales and reconcile them to payouts.

The general break-even method supplies the formula. The extra work for a truck is assigning costs to an order, an operating day or the month, and recognizing that only scheduled trading days earn contribution.

Separate three kinds of cost

For this hypothetical US food truck, food, packaging and payment charges vary with orders. The venue takes 10% of pretax sales plus a fixed booking fee. That contract assumption matters: another venue might charge a minimum instead of an additional fee.

Crew and operating fuel are treated as fixed within the day's stated service capacity. Monthly overhead includes the commissary, insurance, fixed administration and depreciation. The example measures operating profit before financing and income taxes. It excludes startup cash outlays and debt principal.

The SBA explains fixed, variable and mixed costs and recommends separating the fixed and variable portions of mixed expenses. A truck's fuel or labor classification can change with the route and schedule, so document it rather than copying an industry percentage.

Put the assumptions into a worksheet

Place labels in column A and inputs in B. All costs below are positive amounts; the percentage fee is entered as 10%.

The venue commission per order is $16 × 10% = $1.60. Contribution is $16 minus $4.80, $0.80, $0.40 and $1.60, leaving $8.40 per order.

Enter these formulas in the indicated cells:

B14: =B2-SUM(B3:B5)-B2*B6
B15: =SUM(B7:B9)
B16: =B10/B11
B17: =ROUNDUP((B15+B16)/B14,0)
B18: =ROUNDUP(B15/B14,0)

B14 is contribution per order, B15 the $400 daily commitment, and B16 the $200 share of monthly overhead. B17 returns 72 orders for full operating break-even. B18 returns 48 orders to cover only the day's costs. If contribution is not positive or there are no trading days, stop and correct the assumptions before dividing.

Work one event all the way through

At the expected 80 orders, the day's result is:

Check both identities: sales less the order-driven costs must equal orders multiplied by $8.40, and contribution less daily costs and allocated overhead must equal profit. At the rounded full threshold of 72 orders, revenue is $1,152 and operating profit is $4.80. The exact threshold is 71.43 orders, displayed to two decimals; round upward because an order cannot be sold fractionally.

At 48 orders, the day covers its own costs with $3.20 left over. That can support a tactical decision to attend when monthly costs are already committed. It is not a sustainable monthly target. Compare sites using locational break-even analysis, with the same treatment of ongoing costs at each venue.

Change one assumption: fewer selling days

Keep every daily input unchanged, including 80 orders. Reduce trading days from 20 to 16 because the calendar has fewer bookable dates. The monthly overhead remains $4,000.

For the shorter schedule, required orders are (400+250)/8.40 = 77.38, rounded upward to 78. Monthly profit checks as 10,752-6,400-4,000 = 352. The per-order economics did not change; the calendar reduced the contribution available to cover the same overhead.

Where it goes wrong

• Counting calendar days as selling days. Weather, maintenance and unavailable pitches can reduce the dates that generate sales.
• Double-counting processor or venue fees. A net settlement and a separate fee deduction can charge the same cost twice.
• Ignoring contract minimums. A minimum guarantee may replace a percentage charge or apply above it. Read the contract before building the formula.
• Assuming unlimited service capacity. A higher target may require extra crew, longer service or more stock than the truck can handle.
• Confusing operating profit with available cash. Equipment payments and debt principal require a separate cash schedule; the cash-flow break-even template addresses that boundary.

Compare your trading days in Covirage

Bring sales by event and the matching food, venue and operating-cost exports to Covirage. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for hospitality teams for the supporting industry context.