Break-even & target sales calculator

Why this calculator matters

Managers need simple, defensible targets so every shift knows what to sell to cover costs and hit profit goals. This resource turns messy cost and POS data into clear break-even revenue, contribution margins by item or channel, and daily covers targets you can act on.

What this tool does

Use the calculator to:

• Calculate contribution margin per item and contribution margin ratio for the business or a channel.
• Compute break-even revenue and the revenue needed to hit a target profit.
• Turn revenue targets into covers or average-check targets by service or channel.
• Run simple sensitivity scenarios (e.g., what if food cost rises 2 percentage points?).

Key terms (plain language)

• Fixed costs: Costs that don’t change with sales in the short run (rent, salaried managers, insurance, some utilities).
• Variable costs: Costs that change with sales/volume (food ingredients, hourly labor tied to covers, disposable packaging for delivery).
• Contribution margin (CM): Price minus variable cost. It’s the amount from each sale that contributes toward fixed costs and profit.
• Contribution margin ratio (CMR): CM divided by Price (or 1 − variable cost ratio for aggregate calculations).
• Break-even revenue: Sales needed to cover fixed costs (no profit, no loss).
• Target revenue: Sales required to cover fixed costs plus a chosen profit target.

Core formulas (use these in spreadsheets)

1. Contribution margin per unit = Price − Variable cost per unit
2. Contribution margin ratio = Contribution margin per unit / Price
   Alternatively for aggregate: CMR = 1 − (Total variable costs / Total revenue)
3. Break-even revenue = Fixed costs / Contribution margin ratio
4. Target revenue = (Fixed costs + Target profit) / Contribution margin ratio
5. Target covers (per day) = Target revenue / Average check / Number of days in period
   (Adjust denominator for shifts or services as needed.)

Worked example (monthly)

Assume:

• Fixed costs = $50,000 / month
• Total monthly revenue = $120,000
• Total variable costs = $42,000 (35% of revenue)
• Average check = $20
• Goal profit = $10,000 / month

Compute:

• CMR = 1 − 0.35 = 0.65
• Break-even revenue = 50,000 / 0.65 = $76,923
• Target revenue = (50,000 + 10,000) / 0.65 = 60,000 / 0.65 = $92,308
• Target covers per day (30-day month) = 92,308 / 20 / 30 ≈ 154 covers/day

Spreadsheet-ready formulas (Excel / Google Sheets)

Place input values in cells like this: A1 FixedCosts, A2 TotalRevenue, A3 TotalVariableCosts, A4 AverageCheck, A5 TargetProfit, A6 DaysInPeriod.

• CMR: =1 - (A3 / A2)
• Break-even revenue: =A1 / (1 - (A3 / A2))
• Target revenue: =(A1 + A5) / (1 - (A3 / A2))
• Target covers per day: =((A1 + A5) / (1 - (A3 / A2))) / A4 / A6

How to build an item-level calculator

1. Export menu-level POS data: item name, price, quantity sold, revenue by item.
2. Map recipe/COGS per item (ingredient cost per portion). For aggregated variable cost ratio, you can derive weighted variable cost = SUM(item_qty * item_cost) / total_revenue.
3. Compute item CM = price − item_cost; item CMR = item CM / price.
4. Use item-level CMRs to simulate menu changes or to prioritize high-CM items in promotions.

POS export fields to pull (recommended)

• Sales date/time
• Item name / SKU
• Quantity sold
• Extended revenue (price × qty)
• Check/transaction ID (to compute average check and covers)
• Channel (dine-in, takeout, delivery, catering)

Sensitivity scenarios (quick tests)

Run simple scenarios to see the impact of cost changes:

• Increase variable cost ratio by +2 percentage points: new CMR = 1 − (old variable ratio + 0.02)
• Calculate new break-even and target revenue using the formulas above.
• Repeat for labor increases by modeling portion of labor as variable and adding to variable costs.

Practical tips

• Use channel-specific CMR if delivery packaging or platform fees materially change variable costs.
• Recompute monthly or when you change the menu, pricing, or staffing model.
• If you have unreliable item-level costs, start with an aggregate variable-cost ratio and move toward item-level costing as recipes and inventory controls improve.
• Turn target revenue into simple, actionable shift goals (e.g., daily covers, average check uplift, or top-5 item push).

Sample scenarios to include in your workbook

• Base case (current costs and revenue)
• Food cost +2 points
• Delivery fees increase (per-order variable cost added)
• Promotional price drop with expected uplift in covers (test contribution effect)

Next steps and capabilities you may want

This HTML workbook explains the formulas and shows how to construct a spreadsheet calculator. Useful platform upgrades include:

• An interactive calculator form that accepts your inputs and returns computed results immediately.
• Itemized import from POS so the system computes weighted variable cost ratios automatically.
• Saved scenarios and historic submissions (so managers can compare actual to target over time).
• Dashboard widgets or alerts when actual sales fall below target by channel or shift.

Where to use this

Daily shift planning, weekly manager huddles, week-ahead staffing decisions, menu engineering sessions, and monthly financial close. Keep the calculations visible for managers so decisions are grounded in numbers, not guesswork.

Image search phrase: restaurant sales calculator spreadsheet