> 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.