How to Build a Fulfillment Calendar That Prevents Stockouts

Twelve weeks is my working number for how far in advance a small operation should be planning its packaging and hardware orders and that came about in one very bad February when a supplier delay turned a simple restock into a two week standstill. You don’t need any forecasting software to avoid that. You just need a calendar with dates on it and a rule as to what happens on each date.

Here’s the promise: by the end of this you’ll have a repeatable schedule that you can set up in an afternoon. It turns reordering from a panic moment into a routine. It works whether you’re moving 50 units a month or 5000 units a month. It works because it removes the decision from the time when you’re least able to make it well. People who buy carts in bulk will quickly work out this principle as a missed reorder on a case of hardware is more expensive than a missed reorder on a box of labels.

Next is the calendar itself, the trigger points that feed it and the very few mistakes that will break it.

Why the Schedule Beats the Spreadsheet

Most small buyers already use a spreadsheet. What they lack is a sense of rhythm. The spreadsheet shows you what else you have. The calendar informs you when to care.

I’d go for a plain old paper wall calendar over a sophisticated inventory tool for this job (at least for the first 6 months). You look at a wall every day. You only open a dashboard when something’s already gone wrong and by that stage it’s typically too late. Just stick the calendar where you’re filling the orders and write the reorder dates in marker.

Three things feed those dates:

●    Lead time. The actual number of days from order placed to boxes on your shelf (not the number that’s on the supplier’s homepage).

●    Burn rate. The actual number of units you go through per week, measured over a period of at least two months.

●     Buffer. The cushion you keep for the week in case everything goes tits up (because it will).

Add those three together and you get a reorder point. Take the date back from the calendar and you get a reorder day. That’s the whole system. The rest is just discipline.

Set the Trigger Points Before You Need Them

The trap is that the shelf looks thin. Looking at a shelf is a bad idea really as the one that looks half full might be three days of stock and the one that looks full might be two weeks. Count instead on a fixed day each week.

I use what I call the two bin rule. You split each fast moving item into two bins. When the first bin is empty that’s your reorder signal (not a crisis, just a signal). You’re now running off the second bin whilst the order is in transit. If the order arrives before the second bin is empty then your buffer is correct. If it doesn’t then you increase your buffer for the next cycle.

The SBA guidance on inventory and cash flow makes exactly the same point in rather more pedestrian terms: there is a cost to carrying too little inventory and that cost is typically one that small businesses don’t fully appreciate.

Here’s the bit that most people get absolutely wrong. They set the trigger and then they never look at it again. Your burn rate will change with the season, it will change with a new product line, it will change with a single big customer. Recalculate the burn rate on the first Monday of every quarter and adjust your trigger if the numbers have changed.

Map the Year in Four Blocks

A 12 month calendar is too much to remember in your head so break it into quarters and assign each quarter a job.

One change per quarter not four. I’ve seen operators go away and completely rewrite their entire ordering system in a weekend only to abandon it by Wednesday. Slow wins over clever in this case.

Peak prep is the area that really deserves the attention as it’s where the calendar really comes into its own. If your peak is from late fall through the new year then your Q3 orders need to be in before the shipping networks get all congested. The Census Bureau retail trade data shows that the final months of the year account for a disproportionate amount of total retail activity and carriers feel that very much. Lead times get stretched as a result. Order earlier than the maths would suggest. The maths is based on a normal month.

The Three Mistakes That Break the Calendar

●   Go with the published lead time (it’s an average and averages hide the bad weeks). Track your own arrival dates over three cycles and use the worst of those as your planning number.

●    Order everything on the same day. It’s neater and it creates a single point of failure. Spread your reorder dates across the month so you never have two shipments dependent on the same week being successful.

●   Let storage decide the buffer. If your shelf space is the reason your buffer is small then the shelf is the problem not the maths. Fix the shelf space or cut a slow SKU to make room.

There’s a wider pattern running through all three of those. The BLS tracks the movement in wholesale trade employment over time and the trend has been towards leaner teams managing greater volumes. Lean teams don’t have the spare hours to cover for an emergency reorder. A calendar is how a small team buys back the hours that a stockout has eaten.

Run the First Cycle This Week

Pick your 5 fastest moving items. For each of those, record the last 3 arrival dates and the burn rate you’ve seen over the last two months. Set your reorder day and put it on the wall calendar in marker.

Don’t go and do all 50 SKUs. Five will tell you where the system pinches and the pinches are invariably in the same two or three places. Add on the rest once you’ve done two clean cycles.

And keep one thing in your back pocket: a supplier with stock in a domestic warehouse and clear pack size pricing. If a lead time goes off the rails the quickest fix is a short hop to a domestic warehouse rather than a call to a freight forwarder. That one backup supplier contact has saved more schedules than any planning tool I’ve ever used.