FREE WORKBOOK
Weekly GP Tracker
Food and drink gross profit by week, earned from stock counts rather than hoped: opening plus purchases less closing, against ex-VAT sales.
Join dozens who use this
Who this workbook is for
Anyone whose GP comes from purchases alone
Purchases-only GP swings with the delivery day: order heavy on Thursday and the week looks terrible, run the freezer down and it looks brilliant. Cost of sales is opening stock plus purchases less closing stock, and a GP without the counts is a guess wearing a percentage. The demo week earns its 68 on food and 72 on drink properly.
Anyone who found out about a bad month at the month end
Weekly is the frequency at which a GP problem is still cheap: one point of food GP on the demo venue is £7,523 a year, and the tracker shows the gap to target in points and pounds while the week that caused it is still warm. A falling GP with steady prices means portions, waste or shrinkage, in that order of likelihood.
Anyone whose counts flatter the figure
The commonest quiet error is an overstated closing count, which shifts cost into next week and flatters this one — the tracker’s design makes the two weeks share an opening figure so the borrowing shows up. Feed it from the Stock Count and Valuation Workbook, and let the Wastage Cost Calculator name the gap it finds.
