You're halfway through a production run when you realise you're short on butter. Or you've over-ordered flour for the third week in a row and it's going stale. Or a customer calls to collect their order and you've already used the ingredient you needed for it.
These are stock management problems. And for most small food businesses, they're solved with a combination of memory, WhatsApp messages, and a rough mental tally — which works until it doesn't.
This guide covers what proper stock management looks like for a small food business, why it matters more than most owners realise, and how to set it up without a full warehouse management system.
Why stock management matters more than you think
Most small food business owners think of stock management as a "big business" problem. In reality, poor stock control is one of the most common causes of:
- Wasted ingredients — over-ordering perishables that expire before use
- Production delays — discovering a shortfall only when you're mid-batch
- Missed orders — not having enough of an ingredient to fulfil a customer order
- Cash tied up unnecessarily — holding more stock than you need because you're not sure what you have
The Food Standards Agency estimates that UK food businesses waste around 1.8 million tonnes of food per year. A significant portion of that is avoidable with better stock visibility.
The three things you actually need to track
You don't need a complex system. You need to know three things for each ingredient:
- Current quantity on hand — how much do you have right now?
- Reorder threshold — at what quantity should you order more?
- Usage rate — how quickly does this ingredient get used across your recipes?
With those three data points, you can answer the question that matters: "Do I have enough to get through this week's production without running out?"
The spreadsheet approach and where it breaks down
Many small food businesses track stock in a spreadsheet. It works — up to a point. The problems start when:
- You forget to update it after a production run
- Multiple people are using the same spreadsheet and it gets out of sync
- You're working from memory for some ingredients and the spreadsheet for others
- You have to manually calculate how much of each ingredient a batch of recipes will use
How to set reorder thresholds that actually work
A reorder threshold is the quantity at which you need to order more of an ingredient before you run out. Setting it correctly requires knowing two things:
- Lead time — how long does it take to get more from your supplier?
- Usage rate — how much do you use per week?
The formula is simple: Reorder threshold = (lead time in days × daily usage) + safety buffer
For example: if you use 2kg of butter per day and your supplier takes 2 days to deliver, your reorder threshold should be at least 4kg — plus whatever safety buffer you're comfortable with. Most small businesses add 20–30% as a buffer.
The mistake most businesses make is setting thresholds based on gut feel rather than actual usage data. If you're tracking your recipes properly, you already have the usage data — you just need to connect it to your stock levels.
Connecting production to stock
The most powerful thing you can do for stock management is make production runs automatically deduct from your stock levels. This means:
- When you complete a batch of 24 brownies, the butter, flour, eggs, and chocolate are deducted from stock automatically
- Your stock levels are always current without manual updates
- Low-stock alerts fire at the right time — before you run out, not after
This is how FoodCore's stock module works. You schedule a production run, assign it to a recipe, and when you mark it complete, the ingredient quantities are deducted based on the recipe's ingredient list. No separate stock-take required.
What to do when you discover a shortfall
Even with good stock management, you'll occasionally find yourself short. When that happens:
- Check your shopping list — if you're using software that generates shopping lists from your production plan, you may already have an order in progress that covers the shortfall
- Check substitutions — can you use a different ingredient without affecting the recipe or allergen profile?
- Adjust the production run — if you can't get more in time, reduce the batch size rather than compromising the recipe
- Communicate with the customer — if an order is affected, tell them early. Most customers are understanding if you're upfront.
Stock management for multi-site operations
If you operate from more than one kitchen or site, stock management gets more complex. You need to know not just how much you have in total, but where it is. This is where a centralised system becomes essential — a spreadsheet per site that someone has to manually consolidate is a recipe for errors.
FoodCore supports multi-site operations, with stock tracked per site and users assigned to specific sites or across all of them.
The connection between stock and cashflow
Stock is cash. Every kilogram of flour sitting in your storeroom is money you've spent but not yet converted into revenue. Over-stocking ties up cash you could use elsewhere. Under-stocking causes production delays that cost you revenue.
The goal is to hold the minimum stock needed to meet your production plan without running out. That requires knowing your production plan in advance — which is another reason why connecting your orders, production scheduling, and stock management in one system pays off.
Getting started: a practical approach
If you're starting from scratch, here's a simple process:
- Do a stock-take — count everything you have and record the quantities
- Set up your ingredient library — if you're using FoodCore, add each ingredient with its cost per unit and supplier
- Set reorder thresholds — use the formula above: (lead time × daily usage) + 20% buffer
- Run your first production batch through the system — watch the stock levels update automatically
- Review after two weeks — are your thresholds triggering at the right time? Adjust as needed
Stock management doesn't need to be complicated. It needs to be consistent. The right system makes consistency the default rather than something you have to remember to do.