Stock - Wastage Percentage Drift
Updated Wed 28 Oct 2026
Running the report
Report options
Only show food cost items
Ticked by default. Ticked, only stock items that count towards food cost are checked. Untick it to check every stock item, including stock that is not food.
The report at a glance
The report has no date line because it does not look at a period. The page footer shows the brand, the report version, the page number and when and by whom the report was run, for example Run on 28 Oct 2026 at 15:05 by Sam.
- Selected parameters: what you chose.
- Items that drifted: one section per store, with the items whose wastage percentage differs from the brand's model.
If no store has a different wastage percentage, the report shows a no data picture instead of a list.
Selected parameters
A panel at the top of the report that repeats your choice, so a printed copy always says how it was run.
| FOOD COST ITEMS |
|---|
| Food cost items only |
It reads Food cost items only when the option is ticked and All stock items when it is not.
Items that drifted
One section per store, in alphabetical order of store name, with the store's name and its store number in brackets. Under the store, the items are grouped by stock type, and inside each group they are listed by category and then item name. Only items where the store's wastage percentage is different from the model are shown.
| Category | Stock item (Code) - UoM | Model bulk cost | Model wastage % | Model prepped cost | Store's wastage % | Store's prepped cost |
|---|---|---|---|---|---|---|
| Bob's Burgers Times Square (1001) | ||||||
| Food | ||||||
| Meat | Beef mince (BEEF01) - kg 1 | 89.00 | 10.0% | 98.89 | 15.0% 2 | 104.71 3 |
| Meat | Chicken fillets (CHI01) - kg | 64.00 | 12.0% | 72.73 | 20.0% | 80.00 |
| Bob's Burgers Wharf (1002) | ||||||
| Food | ||||||
| Meat | Beef mince (BEEF01) - kg | 89.00 | 10.0% | 98.89 | 8.0% | 96.74 |
| Produce | Lettuce (LET01) - kg | 28.00 | 25.0% | 37.33 | 30.0% | 40.00 |
1 One line per item and store
The line shows the item's category, its name with its code in brackets (when it has one) and the unit it is counted in. An item appears once for every store that has a different wastage percentage, so the same item can be listed under several stores.
2 Store's wastage %
The wastage percentage the store uses for the item. Red means the store's percentage is higher than the model, so more is lost and the prepared item costs more. Green means it is lower than the model, so the prepared item costs less.
3 Store's prepped cost
What one usable unit of the item costs at that store: the model bulk cost divided by what is left after the store's wastage. In the example, beef mince costs R 89.00 a kg. With 15% lost, each usable kg costs R 89.00 divided by 0.85, which is R 104.71. Compare it with the Model prepped cost to see the effect of the store's change.
- Model bulk cost
- The brand's own cost for one unit of the item as it is bought.
- Model wastage %
- The wastage percentage the brand has set for the item.
- Model prepped cost
- The brand's prepped cost for the item, as saved against the item.
A cost that is empty or zero is shown as a grey dash.
Frequently asked questions
An item I expected to see is not listed. Why?
An item is only listed for a store whose wastage percentage is different from the brand's model. It is not listed when the store uses the model percentage, when the item is archived, when it belongs to one store only, or when Only show food cost items is ticked and the item does not count towards food cost. Stores that are switched off are not checked at all.
What do the red and green percentages mean?
Red means the store's wastage percentage is higher than the model's, so the prepared item costs more at that store. Green means it is lower, so the item costs less. Lower is not always better: a percentage that is too low can mean wastage is not being recorded.
How is the store's prepped cost worked out?
The model bulk cost divided by one minus the store's wastage percentage. With a bulk cost of R 64.00 and 20% wastage, one usable unit costs R 64.00 divided by 0.80, which is R 80.00.
Why does the model prepped cost not match the model bulk cost and model wastage %?
The report shows the prepped cost that is saved against the item at brand level. It is not worked out again when you run the report, so it can differ if the item's cost or wastage was changed and the prepped cost has not been updated yet.
Why is a store's prepped cost a grey dash?
The prepped cost cannot be worked out when the item has no model bulk cost, or when the store's wastage percentage is 100% or more, because nothing usable is left. The row is still listed so you can correct the percentage.
A whole store is missing from the report. Why?
Either the store uses the brand's model percentages for every item, or the store is switched off. Only enabled stores are checked.
Can two stores have the same name?
Yes. Each store gets its own section, and the store number in brackets tells them apart.
Glossary
- Bulk cost
- The cost of one unit of a stock item as it is bought, for example one kilogram of beef mince.
- Drift
- A store using a wastage percentage that is different from the brand's model for the same item.
- Food cost item
- A stock item that counts towards your food cost, as opposed to other kinds of stock.
- Model
- The brand's own setting for a stock item, used as the benchmark for every store.
- Prepped cost
- The cost of one usable unit of an item after wastage has been taken into account.
- Stock type
- The kind of stock an item is, used to group the items under each store.
- UoM (unit of measure)
- The unit an item is counted in, such as kg, litre or each.
- Wastage percentage
- The share of an item that is lost before it can be used, for example in trimming, peeling or cooking.