the formula for setting par levels, real-world examples for spirits, produce, and dry goods, and when to adjust them.
the basics
what par levels are and why they matter.
definition
par level = the minimum stock you need to get through to the next delivery.
a par level is the quantity of a given item you should always have on hand. when your stock drops to or below par, it's time to order.
par levels exist to solve two problems simultaneously: stockouts (running out of something during service) and overstock (tying up cash in inventory that sits on shelves). both are expensive. 86ing a popular cocktail loses revenue and frustrates guests. having $8,000 in excess spirits inventory is $8,000 not in your bank account.
good par levels hit the sweet spot — enough to never run out, not so much that you're sitting on dead stock.
the formula
par level = (average daily use × lead time) + safety stock
three numbers drive your par level:
average daily use: how much of this item you go through per day, averaged over the last 4–8 weeks. use actual usage data, not guesses.
lead time: the number of days between placing an order and receiving the delivery. if you order on Monday and receive on Wednesday, lead time is 2 days. if you order weekly, lead time is 7 days.
safety stock: a buffer for unexpected demand spikes or delivery delays. typically 20–30% of your average usage during lead time. higher for items with volatile demand or unreliable suppliers.
the formula ensures you always have enough stock to cover the gap between ordering and receiving, plus a cushion for surprises.
examples
par level calculations for real items.
spirits example
Tito's Handmade Vodka, 1L bottles.
average daily use: you go through 1.5 bottles per day (based on the last 6 weeks of data).
lead time: you order from your distributor on Monday, delivery arrives Wednesday. lead time = 2 days. but you only order once a week, so your effective lead time until the next order cycle is 7 days.
safety stock: 25% buffer for busy weekends and special events.
par level = (1.5 bottles/day × 7 days) + (1.5 × 7 × 0.25) = 10.5 + 2.6 = 13.1 → round up to 14 bottles
when your count drops to 14 bottles or below, it's time to order. your order quantity is par level minus current count: if you have 6 bottles, order 8.
produce example
limes — the most critical bar ingredient.
average daily use: 40 limes per day (juicing, garnishes, wedges).
lead time: you get produce deliveries 3 times per week (Monday, Wednesday, Friday), so your maximum gap between deliveries is 3 days.
safety stock: 30% — produce is perishable and quality varies, so you need a bigger buffer.
but here's the catch with produce: shelf life matters. limes last about 7–10 days refrigerated. you can't stock a month's worth. par levels for perishables must balance usage against spoilage — order more frequently in smaller quantities rather than stocking up.
dry goods example
cocktail napkins — 500-count packs.
average daily use: 0.5 packs per day (you go through about 250 napkins daily).
lead time: your bar supplies vendor delivers once a week. lead time = 7 days.
safety stock: 20% — dry goods have stable demand and long shelf life, so less buffer needed.
par level = (0.5 packs/day × 7 days) + (0.5 × 7 × 0.20) = 3.5 + 0.7 = 4.2 → round up to 5 packs
dry goods and non-perishables are the easiest category to set par levels for because demand is predictable and there's no spoilage risk. the main risk is running out because nobody checked the storage room.
kegs example
draft beer — half-barrel kegs.
average daily use: your IPA tap goes through a half-barrel (15.5 gallons / 124 pints) in about 5 days, so daily use is 0.2 kegs.
lead time: keg deliveries come twice a week. maximum gap = 4 days.
safety stock: 25% — kicking a keg during Friday night service is a real problem.
in practice, you'd always want at least 1 backup keg for your top-selling taps. for slower-moving taps, having one on-line and zero backup may be acceptable. the math says 1 keg — your experience during a packed Saturday might say 2.
adjustments
when to change your par levels.
triggers
six events that should prompt a par level review.
1. seasonal shifts. a rooftop bar in June uses 3x the vodka it uses in January. adjust par levels at the start of each season, or monthly if your business is highly seasonal.
2. menu changes. adding a new cocktail that uses mezcal? your mezcal par level needs to go up before the menu drops, not after you 86 it on opening night.
3. special events. a private party for 80 people will blow through your normal pars. create temporary par levels for event weeks based on the expected guest count and event menu.
4. supplier changes. if you switch distributors and your lead time goes from 2 days to 4, every par level based on that supplier needs to be recalculated.
5. consistent overstock. if you're always throwing away limes or pouring expired beer, your par levels are too high. reduce safety stock or shorten the ordering window.
6. consistent stockouts. if you're 86ing the same item every other week, par levels are too low. increase the safety stock percentage or recalculate average daily use with more recent data.
the spreadsheet problem
par levels only work if they're current.
the biggest challenge with par levels in a spreadsheet is that they go stale. you set them once, based on data from three months ago, and then nobody updates them as demand shifts.
effective par level management requires: • 4–8 weeks of usage data to establish a baseline • weekly review of items that consistently over- or under-stock • seasonal recalibration at least quarterly • automatic alerts when stock drops to par
in a spreadsheet, all of this is manual. you check the sheet, compare to your count, calculate the difference, and decide what to order. one missed check and you're running out of well bourbon on a Friday.
the right system watches your inventory against par levels continuously and tells you what to order before you have to think about it. that's not a luxury — it's how modern bar operations work.