Liquor store inventory management
- Cases to order to be back at par on delivery
- 3
- Bottles on hand
- 144
- Weeks of cover on hand
- 4
- Par: bottles to hold for the lead time plus the safety weeks
- 108
Every figure on this page is computed from the inputs entered, by the method stated below it. Rollupvo publishes no tax rule, no accounting standard, no margin and no par: the lead times, the safety weeks, the margins and the ownership shares are yours, and the defaults are a worked example to replace with your own figures.
The figures above start from a worked example (3). Change any input and the answer updates as you type.
Download the Liquor store inventory management worked example (CSV)
This is a liquor store par sheet, the piece of liquor store inventory management that decides what to order this week. Cases on hand times bottles per case is the bottles on hand; over weekly bottles sold it is weeks of cover; weekly sales times your supplier's lead time plus your safety weeks is the par; and the cases that bring the line back to par when the next delivery lands, after another lead time of sales, is the order. Bottles on hand at cost per bottle is the stock value. Every figure is yours, including the cushion; the sheet publishes no rule. Free, on the page, no account; the paid plan keeps every line's par against the store.
Par, worked from your lead time and your cushion
36 bottles a week with a two-week lead time and one week of safety is a par of 108 bottles: what the shelf should hold the moment an order goes in. The lead time and the safety weeks are inputs, so a line with a slow distributor carries a bigger par without a different sheet.
Cover and the bottles above par
12 cases of 12 is 144 bottles, four weeks of cover at 36 a week, and 36 bottles above par on the worked example. Above par means the order can wait; below it means the next delivery lands after the shelf runs dry. The sheet shows both so the decision is a number.
The order, in cases
To be back at par when the next delivery arrives, order par plus another lead time of sales, less what is on hand: 108 plus 72 less 144 is 36 bottles, three cases of 12. The sheet works it in cases because that is how the distributor sells, and it publishes no minimum order.
Liquor store inventory management: common questions
How do I set a par level for a liquor store?
Weekly bottles sold times the supplier's lead time in weeks, plus the weeks of safety stock you keep. That is the bottles the line should hold when an order is placed. The free sheet on this site works par, cover and the order in cases from six figures with no account, and publishes no rule about the cushion.
Why does the sheet order more than the shortfall to par?
Because the delivery takes the lead time to arrive and the line keeps selling meanwhile. Ordering only the gap to par means landing below par on delivery day. The sheet adds a lead time of sales to par, subtracts what is on hand, and returns the cases.
Can I run this for every line in the store?
One line per sheet, free, as many times as you like. Rollupvo Pro keeps every line with its par, cost and on-hand against the store, so the order for the week is a list rather than a stack of sheets, and emails a reorder reminder when a line falls to par.