Par level calculator
Enter how much of an item you use, how often it is delivered and how much spare you want. The calculator gives you the par level, the reorder point and the size of the next order.
- Par level
- 11
- Usage between deliveries
- 8
- Reorder point
- 6
- Order to get back to par
- 7
The shelf is at or below the reorder point. Order now.
Key takeaways
- Par level is what you use between two deliveries, plus your safety stock.
- The reorder point is what you use while you wait for a delivery, plus the same safety stock.
- The order is the par level minus what is on the shelf, rounded up to the case size.
- Take the usage from your stock takes, not from memory, and leave out weeks that were not normal.
How the calculator works
A par level is the amount of an item you want on hand right after a delivery. The calculator works it out for one item at a time from three sums:
Par level = usage between deliveries + safety stock
Reorder point = usage during the supplier's lead time + safety stock
Order = par level − stock on the shelf, rounded up to the case size
Usage is taken from your average week and scaled to the number of days. Part units are rounded up, because you cannot hold or order a third of a bottle.
Where the numbers come from
- Usage in an average week
- From your stock takes over the last four to eight weeks: the opening count, plus everything received, minus the closing count, divided by the number of weeks. Leave out weeks that were not normal.
- Days between deliveries
- How often this supplier delivers. Seven for a weekly delivery, three or four for twice a week.
- Supplier lead time
- The days between placing the order and the delivery arriving.
- Safety stock
- How far your busiest weeks run above an average one. Keep it small for expensive bottles and anything with a short date.
- Case size
- How many units come in one case, if the supplier only sells whole cases. Leave it at 1 to order single units.
A worked example
A cocktail bar uses 8 bottles of gin in an average week. The supplier delivers once a week and needs the order two days ahead. A busy weekend can take 3 bottles more than an average week, so 3 is the safety stock. On order day there are 4 bottles on the shelf.
| Step | Bottles |
|---|---|
| Usage between deliveries | 8 |
| Safety stock | 3 |
| Par level | 11 |
| Usage during the two-day lead time, rounded up | 3 |
| Reorder point | 6 |
| Order: 11 − 4 on the shelf | 7 |
These are the values the calculator starts with. If the gin only comes in cases of six, set the case size to 6 and the order becomes 12.
Keep the par right
A par is only as good as the usage behind it. Check it after every stock take: an item that is always well above zero when the delivery arrives has too much safety stock, and an item that runs out has too little. Raise pars before events and the high season, and bring them back down before the season ends.
The full method, with pars for premium bottles, perishables and slow movers, is in par levels for bars.
Par levels in Firetable
In Firetable each item can have a par level and a reorder point, or a fixed quantity if you always order the same amount. The reorder suggestions list every item below its reorder point, grouped by supplier, with the quantity that brings it back to par. A consumption view shows how fast each item has sold over the last 7, 30 or 90 days, which is the usage figure this calculator asks for.