The Webtender
Forum and Chat

 Message 21642 of 22774 in Behind the Bar
 Share on Facebook |  Save to del.icio.us  
Subject: Weighing Bottles & Inventory
From: yahoointhecorner
Posted: Tue Feb 10. 2009, 20:14 UTC
I was wondering if anyone has a good formula (excel style) to use from shift 
to shift (week to week, etc) to see how much liquor your bar has gone through. 
I'm having a hell of a time using the scale system my owner wants to use, the 
ol' 1-10 scale isn't giving accurate enough numbers for him. If anyone has a 
good system with formulas it would be greatly appreciated as I can't seem to 
get anything to work. I'm weighing in Lbs/ounces and have the full vs. empty 
weights of all the products, I just can't seem to get the math to work when I 
put in a currently used bottle weight to get the variance from the previous 
weigh-in.

So just to re-cap (I'm extremely sick and not sure how much sense I'm making) 
I have the full and empty weights of bottles, with this I have the densities 
for each alcohol stocked. What I want is a xls sheet where I put in the number 
of full bottles from prior count, number of bottles added since prior count, 
the weight of the in use bottle from prior count, the current number of full 
bottles and the current weight of the in use bottle to give me a number in 
ounces that have been poured since last count...

If anyone has anything even remotely similar to this I would greatly 
appreciate taking a peak at it

Thanks


-- 
The problem with the world is that everyone is a few drinks behind.--Humphrey 
Bogart

http://www.myspace.com/yahoointhecorner


 Current thread (9 messages):
 Message options:
 

Talk about drinks and bartending in The Webtender Forum.
Ask your questions, chat or share your best tricks with other visitors.

Home · Drink Recipes · Bookstore · Barstore · Handbook · Web Index · Feedback

Copyright © The Webtender.
About | Disclaimer | Privacy policy