The Webtender
Forum and Chat

 Message 21875 of 22774 in Behind the Bar
 Share on Facebook |  Save to del.icio.us  
Subject: Re: Weighing Bottles & Inventory
From: Hyddyn Mavurik
Posted: Sat Jun 6. 2009, 01:09 UTC
Followup to: "Weighing Bottles & Inventory"  by yahoointhecorner  (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

Work only in ounces not pounds.

From what you've written it seems that you are putting too much information in 
one spreadsheet. If you are doing inventory, if you are counting stock--make a 
stock inventory sheet. If you are tracking volume depletions from the behind 
the bar showcase, then you simply account for what is there behind the bar and 
start creating your spreadsheet from what is there. 

Create a spreadsheet like this:

                              Week  Jun 12 to Jun 18    .
                              Bar location: Front bar at Mickey's
                              Inventory by Yahoo

Product     Day 1     Variance   Day 2    Variance   Day 3   Variance  Day 4 
============================================================================
Stoli       23           -3         20      -10       10       -6       4
Absolut     25           -5         20       -5       15       -10      5


NOTE: I know that there are seven days in a week. I only used four days in 
this example to give a brief example of how he could create a spreadsheet for 
accounting for the behind the bar showcased liquor.
-- 
The IN box is always full.


 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