re: Liquor/Bar inventory... Need a little help plz.

quote:

---

If you want high accuracy, just weigh the bottles

---

There in lies the problem... if someone sold 3 liter bottles, that is 66 sales... simple. Based on each shot is 1 1/2 oz.

But if you sold 3 pounds of liquor. How many sales is that? 16 oz in a pound? 48 oz total.

So 48 oz by weight is how many 1 1/2 shots?

I am missing something somewhere..

quote:

---

Your employees are stealing.

---

They are skimming from the till. Consider it severance pay. take the train.

quote:

---

Guy goes into bar and orders a pound of whiskey.

---

Was making a weight point... but it was exspressed by 48 oz...

So does 48oz equal 22 sales?

quote:

---

I dont even know what youre asking but I will attempt to answer

---

I guess trying to figure out the least complicated liquor inventory system.

quote:

---

There in lies the problem... if someone sold 3 liter bottles, that is 66 sales... simple. Based on each shot is 1 1/2 oz.

But if you sold 3 pounds of liquor. How many sales is that? 16 oz in a pound? 48 oz total.

So 48 oz by weight is how many 1 1/2 shots?

I am missing something somewhere..

---

Maybe I wasn't clear enough. When you weigh the bottles you have to know what it is you're weighing, and from that the # of sales (and/or fluid oz sold) can be calculated.

If it was me, I would find (or build, because I like doing this stuff) a liquor bottle scale system that uses cheap RFID stickers in combination with the barcode on the bottle. It would work like this:

Whenever I put a new bottle on the shelf, I will put an RFID sticker on the bottom (which has a unique ID# on it), scan the barcode and put it on my scale which weighs and reads the RFID sticker. If I have scanned a bottle of this before, my system will already know the brand/type and volume of the bottle. If I haven't scanned it before, I would have to enter that info this first time. The system will now also know the full weight of the bottle and it will have a unique ID number to track that exact bottle's weight.

Whenever I do inventory, I will just place each bottle on the scale and it will record the bottle ID and weight. If a bottle is empty and I have not yet ever weighed that brand/type (based on bottle barcode) empty yet, I will weigh it and mark it as an empty bottle. Now my system knows everything it needs to know about that liquor. It knows the full and empty weight of the bottle, as well as the fluid ounces, so it knows how many weight ounces equals one fluid ounce of that liquor. It can then calculate exactly how many fluid ounces are in that bottle based on weight alone.

If my system does not yet know the empty weight of a particular bottle, it will just have to estimate fluid ounces based on weight ounces missing until I get an empty weight. This will probably be +/- 10% anyway.


Now stocking is as simple as putting a sticker on the bottom of the bottle, scan, weigh, place on shelf. Inventory is as simple as placing the bottle on the scale and then returning it to the shelf. After the initial stock there will be only occasional manual data entry for new stuff.

Paging jmarto

quote:

---

Posted on 6/23/22 at 1:50 pm

Paging jmarto

---

quote:

---

jmarto1 Posted on 6/23/22 at 1:51 pm

---

This is all readily available information, but we're it not it's abundantly simple

1. Weigh full bottle
2. Weight empty bottle
3. You now know the weight of the volume inside. Divide weight by number of pours. You know weight of each pour.

Now if you have 4 sales out of that bottle you should know the remaining weight.

Are you retarded?

quote:

---

by WWII Collector

---

Never mind, don't answer that.

I want to thank everyone that has replied... You have given me something to think about.

quote:

---

Now, in order to find how much liquor is missing from a bottle that's been opened... Weigh the bottle, say it comes out to 30 oz (weight). Subtract the 17.2oz (weight) to account for the weight of the empty bottle to get 12.8 oz (weight). Since we know that 1.5 oz (volume) is 1.4 oz (weight), divide 12.8 by 1.4 = 9.14 drinks left in the bottle. Multiply 9.14 by 1.5 oz (volume) per drink, which gives you a total of 13.7 oz (volume) of liquor in the opened bottle.

---

or

quote:

---

22 drinks per bottle.

---

Therefore
1/2 (.5) bottle is 11 drinks
1/4 (.25) bottle is 6.5 drinks
1/8 (.125) bottle is 3 drinks

Then if you purchases of 6 bottles a week of 1 product... Say fireball... That means that you should have had 6 x 22 = 132 sales....

That just seems so much easier to me that weighing... Especially if you run a tight ship and daily inventory is an issue.

There is something in the weighting that is not making sense... There has to be something simple trick to it... Something is not clicking...

BUt thnk you.. I just got home and will reread and study...

and to those that said Partender... The App)... I Understand and note it's mention. But its working on a priciple and that is what I am trying to understand first... But I am in search a better way that I see now.

quote:

---

Then if you purchases of 6 bottles a week of 1 product... Say fireball... That means that you should have had 6 x 22 = 132 sales....

That just seems so much easier to me that weighing... Especially if you run a tight ship and daily inventory is an issue.

---

Well now you've zoomed out to just counting bottles. Yeah that's easy, but that doesn't sound very "tight" and what's the point of taking inventory of partial bottles?

quote:

---

That just seems so much easier to me that weighing... Especially if you run a tight ship and daily inventory is an issue.

---

If you want to run a tight ship then weighing will be more accurate than eyeballing.

quote:

---

There is something in the weighting that is not making sense... There has to be something simple trick to it... Something is not clicking...

---

Let me try to break it down.

If you weigh a full and empty bottle of a particular liquor, then subtract, the answer is how much the liquor itself weighed. Right? Right.

Now since we know how much it weighed, and we know how many fluid ounces it was, we can divide to figure out how much each fluid ounce of that particular liquor weighs (this number will almost always be between 0.8 and 1.2 oz per fluid oz, depending on the liquor). Right? Right.

And that's all you need to know in order to weigh a bottle and know exactly how many fluid ounces (or how many drinks or pours or whatever metric you want) are left inside. It's just a simple percentage. If the bottle weighs 40 oz empty (0% full) and 80 oz full (100%), and right now it weighs 60 oz, then it is 50% full. There's your 11 drinks (or ~17 fl oz).

And I'm not suggesting that you do all this math every time. I'm saying you should be able to automate this with a scan and weigh system.

quote:

---

and to those that said Partender... The App)... I Understand and note it's mention. But its working on a priciple and that is what I am trying to understand first

---

Looks to me that Partender is just eyeballing using an app using "landmarks" on the bottle to guide you. I don't know how that data gets integrated into whatever the rest of your system is.