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.

Published , updated

Count in the unit you order: bottles, kegs or cases. Use the same unit in every field.

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.

Gin, one delivery a week
StepBottles
Usage between deliveries8
Safety stock3
Par level11
Usage during the two-day lead time, rounded up3
Reorder point6
Order: 11 − 4 on the shelf7

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.

Set a par on every item.Order from one list per supplier.

One month free with every feature, inventory included. Cancel any time.