DumbBambi
Hospitality

Actual vs Theoretical GP Calculator

Compare actual GP against theoretical GP after stocktake. Spot unexplained variance, waste, over-portioning, comps and margin leakage — and see the annualised cost if it continues.

Advertisement
Actual cost of sales£18,060.00
Actual GP£43,940.00 · 70.9%
Theoretical GP£44,500.00 · 71.8%
GP variance-0.9% pts
Unexplained stock variance£560.00
Variance as % of sales0.90%
Recorded waste %0.52%
Gap vs target GP0.9% pts
Annualised margin leakage£6,720.00
Small GP variance. Worth reviewing waste logs and portion control before it grows.

Target vs theoretical vs actual GP

Target GP
70.0%
Theoretical GP
71.8%
Actual GP
70.9%

Variance can come from over-portioning, incorrect recipes, unrecorded waste, supplier price changes, complimentary items, stock-counting errors, unrecorded staff consumption or stock loss.

Save these numbers before you close the tab

Email yourself a copy, save it for later, or print a branded summary to share with your team or accountant.

Email me these results

We’ll send this calculation plus one short hospitality tips email a month.

No spam. One-tap unsubscribe. We never share your email.

Branded A4 PDF · saved costings sync across all your devices.

Advertisement

About this calculator

Actual GP is what your stocktake proves you made. Theoretical GP is what your recipes and till say you should have made. When the two drift apart, money is leaking somewhere between purchase and till.

Formula: Actual COS = Opening + Purchases + Transfers in − Closing − Transfers out. Actual GP % = (Net sales − Actual COS) ÷ Net sales × 100. Variance = Actual GP % − Theoretical GP %.

Use it after every stocktake. A 1–2 point variance is normal noise; anything larger points to portioning, recipe accuracy, unrecorded waste, comps, supplier price changes or stock loss.

Advertisement

Frequently asked questions

What is a healthy GP variance?+

Under 1 percentage point is well controlled. 1–2 points is normal for a busy operation. Above 3 points is worth a proper investigation.

Why is my actual GP lower than theoretical?+

The usual suspects are over-portioning, incorrect recipes on the till, unrecorded waste, missed comps and staff drinks, supplier price rises since the recipe was costed, and stock-count errors.

How often should I stocktake?+

Weekly for wet stock, monthly for food. The more frequent the count, the smaller the variance you can act on.

Does this replace an EPOS stock module?+

No — it's a fast operator view. If your EPOS gives you both numbers, use this to interpret them and drive action.

Related calculators

Advertisement