Expiry is not tracked by batch
Nobody sees which batch expires this week; a later, shorter-lived batch stays at the back and becomes waste.
Decision software for grocery chains
Industry
Mindpera measures shrinkage, count variance, expiry, on-shelf availability and supply cost in grocery chains by department, store and day. The same thing decides the result in national and regional chains, delis and gourmet stores: net margin is thin, and loss accumulates in small items.
Nobody sees which batch expires this week; a later, shorter-lived batch stays at the back and becomes waste.
When spoilage, trim, theft and recording errors share one line, the broken process in each store stays hidden.
When price-difference invoices, freight, customs and exchange differences stay out of cost, margin looks higher than it is.
In the gap the lower price applies, cutting margin and risking a Ministry of Trade fine.
Shrinkage gets a reason code, count variance is kept apart, and thresholds raise alerts.
Last purchase cost is tracked apart; freight, customs and exchange costs are allocated to imports.
The daily store scorecard, promotion scorecard and POS reconciliation come from the same data.
Replenishment follows the rate of sale, with shelf capacity as a constraint.
Shelf metres and category space are matched to the rate of sale.
Each cash variance record is matched with the camera event of the same moment.
With the line where loss builds up most. If shrinkage and count variance are not yet separated, the first step is Mind Stock: shrinkage is calculated with a reason code and count variance against a frozen balance, and the gap shows on the day it forms. Each product works on its own; the branch scorecard, cost and pricing come later.
Weighed goods are received by the kilogram as blocks or whole pieces and leave through the scale barcode at the till. The difference in between goes in under separate reason codes for trim, drying loss, spoilage and scale difference. The shrinkage rate is calculated by product, category and store; a line that crosses the threshold raises an alert and each loss can be traced to its process.
Freight, customs, insurance and exchange differences are added to the invoice price, and each cost is allocated to the product by value, weight or volume. Mind Cost shows average and last purchase cost on the same line; whether the gap comes from the purchase batch, a cost line or the exchange effect is visible line by line.