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