Don’t take this process of setting up pars lightly. Setting pars can be a bit time-consuming, but it is a process that needs to be set-up if you want to run your place like a business and not just a bar.
Watch the video, and then I also have the steps written out below so you don’t have to rapidly scribble notes like a drunken chimpanzee.
4-STEPS TO SETTING UP YOUR PARS
STEP 1: VIEW HISTORICAL DATA
If you have a quality inventory management system, setting pars is easy, but even if you don’t, you can view the spreadsheets you use to take inventory to determine how much usage your bar goes through for each product.
If for some reason you don’t keep good inventory records (which you’d better start), you can go to your POS back-office and run a sales data report to see what has been selling the best.
This can be a bit trickier because you will have to figure out how many drinks per bottle and then divide to figure out how many bottles you went through. In order to figure how many bottles used based on drinks sold, use the following examples:
1L Bottle of Stoli = 33.81 oz.
Portion size = 1.5 oz.
Shots per bottle = 22.5
Sample sales data for Stoli for past 12 weeks = 983 sold
983 / 22.5 = 43.69 bottles sold
750 ml bottle of Kendall Jackson = 25.36 oz.
Portion size = 6 oz.
Glasses of wine per bottle = 4 (approximately)
Sample sales data for Kendall Jackson sold past 12 weeks = 228
228 / 4 = 57 bottles sold
15.5 Gallon keg of Coors Light
Portion size = 16 oz.
Pints per keg = 124
Sample sales data for Coors Light sold for past 12 weeks = 4,135
4,135 / 33.35 kegs sold
Figuring usage by POS sales data is more time consuming than using your inventory data, but as you can see, it is still possible.
STEP 2: DETERMINE USAGE PER WEEK
I recommend taking the past 12 weeks, as this allows you to go far enough back to get a big picture of what is being used while at the same time seeing recent trends.
Using the math in examples above, we simply need to divide by 12 to figure out how many containers per week are being used.
Stoli = 43.69 / 12 = 3.64 bottles per week
Kendall Jackson = 57 / 12 = 4.75 bottles per week
Coors Light = 33.35 / 12 = 2.80 kegs per week
STEP 3: MULTIPLY USAGE PER WEEK BY 1.5 – 2
This depends on your comfort zone.
My recommendation is to right down the middle and multiply your weekly usage of each product by 1.75, but let’s say you are a nervous Nelly and want to have plenty on hand, 2 times your weekly usage would be plenty, yet most bars have products with 10 times their weekly usage on-hand and it’s just plain unnecessary.
So again, based on the above examples, these would be your pars for Stoli, Kendall Jackson and Coors Light if you multiplied by 1.75:
Stoli: 3.64 x 1.75 = 6.37 bottles → Round to 6
Kendall Jackson: 4.75 x 1.75 = 8.31 bottles → Round to 8
Coors Light: 2.8 x 2 = 4.9 kegs → Round to 5
STEP 4: DETERMINE RE-ORDER POINTS
Setting the re-order point for your products is not detrimental, but it’s definitely helpful. What is a re-order point? This is the point your stock reaches that alerts you it’s time to order more product. Again, good inventory systems have this built in, but you can still do it manually and it will make your life easier.
Using Stoli from the above example, we have determined that the par for Stoli is 6. You might say that once the count for Stoli reaches below 3 that it is time to order more.
I used 3 here because this bar is going through 3.64 bottles per week, so you want to make sure the levels don’t get too low before you order. So here, 3 would be your re-order point for Stoli.
That’s it, now go get started on setting your pars. It’s time-consuming, but it’s your job, so take action. If you use Bar Patrol, we set it all up for you, because that’s our job. Either way, let’s do our jobs and run our bars lean and mean like successful businesses do.
Best of luck.
Cheers, until next time.