Promotion Profitability Evaluator

Promotion Profitability Evaluator

Promotions can grow traffic and awareness — but some that look successful on sales actually destroy margin. Use this evaluator to turn your promotion idea into a simple, evidence-based profit estimate so you can decide whether to run the offer, tweak the design, or test it carefully.

When to use this

Use this before launching discounts, bundles, BOGOs, or time-limited offers. It’s useful for quick decisions (will this promo likely be accretive?) and for designing A/B tests or limited pilots.

Inputs (what you need)

• Baseline units (B) — typical units sold for the promoted item over your measurement period (e.g., per week).
• Original price (P_orig) — your normal selling price per unit.
• Promotional price (P_promo) — price during the promotion (after discount or bundle allocation).
• Expected uplift (U) — percent increase in units sold for the promoted item while the promo runs (enter as % or decimal).
• Cost per item (Cost) — variable cost per promoted unit (food, packaging, promo-specific extras).
• Cannibalization (C) — percent of the promotion-driven sales that would have been other menu sales (estimate 0–100%).
• Average contribution margin of cannibalized items (M_cann) — average per-unit contribution margin (price minus cost) for items likely to be cannibalized.
• Labor impact (Labor) — estimated change in labor cost for the promotion period (can be negative if promo saves labor, otherwise positive). Enter as currency for the period.
• Other promotion costs (Other) — marketing, packaging, signage, platform fees for the promotion for the period.

Step-by-step calculation

Use these formulas to estimate incremental profit for the promotion period:

1. Incremental units driven by the promo: Incremental_units = B × (U as decimal)
2. Incremental revenue from promo sales: Incremental_revenue = Incremental_units × P_promo
3. Incremental gross margin from promo sales: Promo_margin = Incremental_units × (P_promo − Cost)
4. Estimated margin lost to cannibalization: Cannibalization_loss = Incremental_units × C × M_cann
5. Net incremental gross profit before fixed promo costs: Net_margin_before_fixed = Promo_margin − Cannibalization_loss
6. Subtract labor and other promo costs to find final incremental profit: Incremental_profit = Net_margin_before_fixed − Labor − Other

Worked example

Assumptions for a 1-week test:

• B = 200 units/week
• P_orig = $10.00, P_promo = $8.00
• U = 25% (0.25)
• Cost = $3.00 per unit
• C = 20% (0.20)
• M_cann = $4.00 (average contribution margin of items likely cannibalized)
• Labor = $50 (extra prep & service cost for the week)
• Other = $30 (signage, digital promotion)

Calculations:

1. Incremental_units = 200 × 0.25 = 50 units
2. Promo_margin = 50 × (8 − 3) = 50 × 5 = $250
3. Cannibalization_loss = 50 × 0.2 × 4 = $40
4. Net_margin_before_fixed = 250 − 40 = $210
5. Incremental_profit = 210 − 50 − 30 = $130

Interpretation: this promotion is likely accretive in the short term: an extra $130 profit for the week. But if uplift or cannibalization estimates change, the result can flip quickly.

Quick decision guide

• If Incremental_profit > 0 — the promotion is likely accretive in the chosen measurement window. Consider testing at small scale and tracking closely.
• If Incremental_profit ≈ 0 — marginal benefit. Consider narrowing the offer, improving targeting, or running a short A/B test to learn actual uplift and cannibalization.
• If Incremental_profit < 0 — the promotion likely reduces profit. Avoid or redesign unless the goal is non-financial (acquisition, awareness) and you can measure longer-term value.

Rules of thumb

• Small discounts that produce large uplifts and low cannibalization are best.
• Bundles can work when the combined margin remains strong even after discounts.
• BOGOs tend to increase cost per serving dramatically; only use when volume lift, ancillary sales, or repeat visits offset the cost.
• If most uplift replaces existing sales (high cannibalization), the promotion mainly shifts demand and rarely adds margin.

Design & test checklist

• Define the measurement window and metric (e.g., weekly incremental profit).
• Set a clear hypothesis: “This 20% discount will increase item units by 30% and add net profit.”
• Tag promo sales in POS (or use a unique item code) so you can separate promo transactions.
• Measure new vs. repeat customers if acquisition is a goal.
• Run a short pilot or A/B test where possible to measure real uplift and cannibalization before full roll-out.
• Record all promo costs (staffing, marketing, platform fees) and apply them to the period in your calculation.

Limitations & what else to consider

The model is short-term and direct-margin focused. It doesn't capture longer-term customer lifetime value (CLV), brand impact, or changes in average check from cross-selling. If your goal is customer acquisition, estimate future visits and CLV to judge whether a short-term loss could be acceptable for long-term gain.

Next steps — practical actions

1. Run the worksheet with your numbers and perform the sensitivity test: vary uplift and cannibalization to see break-even points.
2. Do a small pilot and use POS tagging to measure real uplift and cannibalization.
3. If the pilot validates the hypothesis, scale while monitoring key metrics: incremental profit, redemption rate, new vs returning guests, and average check.

Capability opportunities

This static evaluator would become more powerful if turned into an interactive calculator that:

• Accepts the inputs and immediately computes Incremental_profit and break-even uplift and cannibalization thresholds.
• Allows sensitivity analysis (sliders for uplift and cannibalization) so you can see how results change visually.
• Stores past runs (using the platform's data submission capability) so you can compare promotions over time and learn what actually works.

See Capability Enhancement Notes below for a suggested implementation approach.

Short checklist before you launch

• Have a tagged POS code for promo transactions.
• Agree measurement window (e.g., 7 days) and target KPIs.
• Estimate costs conservatively and assume higher cannibalization during planning.
• Plan a short pilot whenever possible.