Bar Beverage Inv Recon Sheet.xls 5k5348

INSTRUCTION :

Liquor

This form automatically calculates what your bar sales should be, calculates a bottle variance against ideal sales. This working forms consist of two parts: Liquor invento

Enter data only in the blue highlighted cells. All other ce 1

NAME:

1. Enter Facility's Name

BAR INVENTORY

2. Enter Date

PG 2-1

3. Enter Bartender's Name

4 Tare WT

4. Tare Weight = empty bottle weight of the bottles. * The easiest way to determine the tare weight of any brand is to weight an empty bottle. The tare weights need to check periodically. Green graduations indicate "distilled spirites and Red graduations indicate "liqueurs" and "cordials".

8

7

25.6g

6

5 Size OZ

DESCRIPTION

33.5 Liquer Amaretto

18.5g

Blue Curacao

21g

Liquer Kahlua

15g

Martini & Rossi

22g

Midori

18g

Peach Schnapps

20g

Paul Masson Brandy

20g

Raspberry Rush

Liter = 33.8 oz, 1.5 Liter = 50.7 oz

22r

Vodka Absolut

1.75 Liter = 59.2 oz. 6. Name of item (brand)

19r

Baccardi

20r

Baccardi Limo

7. Beginning Inventory (physical inventory)

20r

Captain Morgan

5. Number of ounces per the bottle size. 750 ml (Fifth) = 25.4 oz, Quart = 32.0 oz,

BEG Inventory BT

OZ

9

UNIT Reciv END Inventory BT

BT

OZ

8. Unit Receiving = Warehouse issued + Transfer In - Transfer Out 9. Ending Inventory (physical inventory)

19r

Chivas Regal

21.5r

Courvoisier

22r

Blend Crown Royal

10. Actual Consumption will be calculated based on 16r the inventory for each item. 30r 11. Actual selling price in your bar. 24r 12. Ideal Sales will be calculated based on the actual consumption. (= Potential Revenue)

Cuervo Gold Vodla Grey Goose Hennessy

21r

Hornito's

16r

Jack Daniels

20r

Jameson Irish Whiskey

15r

Jim Beam

13. Enter your purchasing price per oz for each item 20r

Jonnie Walker

14. Total cost will be calculated based on the actual 20.5r consumption. 19r 15. Enter Actual Sales data from your POS system. 26.5r

Makers Mark

16.5r

JB Red Stag

19r

Seagram's Gin

17r

Seagram's VO

19r

Smirnoff Vodka

15r

Southern Comfort

16r

Wild Turkey

16. Overagae / Shortage will be calculated against ideal sales.

17. List of items;

Malibu Patron Silver

Complimentary Drinks Waste & Spillage PG 1 TOTALS

18. Total amount of waste for the day. Complimentary Drink Waste & Spillage

ITEM

17

17

d be, calculates a bottle per bottle variances, and calculates cash wo parts: Liquor inventory and Beer/Wine inventory.

ted cells. All other cells are calculating fields. 1

BAR:

2

DATE:

3

BARTEND:

10 Ideal Cons

11 Sales PRICE

12

13

IDEAL SALES

14

COST OZ TOTAL

16

15 ACTUAL SALES

OVER/ SHORT

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

EM

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

0

$0.00 $

-

$ -

$

-

$

-

$

-

$

-

$

-

$

-

$

-

AMOUNT $

-

ITEM

AMOUNT $

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

TOTAL

18

INSTRUCTION :

Beer / Wine

This is the second part of the Bar Inventory work sh

Enter data only in the blue highlighted cell oth 1

NAME:

All yellow highlighted cells are linked to the Liquor Work Sheet.

BAR INVENTORY 19. Beer items you serve

PG 2-2 BEG Inventory

20. Wine items you serve

Tare WT

Size OZ

DESCRIPTION Bud Ice

21. Enter the amount of sales for Draft Beer

0

Bud Light Budweiser

22. Enter the amount of sales for Sodas

Bud Light Lim Bud Select

23. Inventory overage / Shortage: between Ideal sales and Actual Sales.

19

Bud Select S5 Coors Light Miller GD

24. Enter the amount of drop made by the Bartender

Miller Lite Michelob Ultra Corona Corona Light

25. Cash overage/shortage = Cash Drop - the amount of Ideal Sales

Heineken Sam Adams Guinness Killians, Red Smirnoff Ice St. Pauli Grout Stort Amber Rock O'Doules-G TL Chardonnay (GL) TL Merlot

BT

(GL)

20

TL White Zin

(GL)

TL Chardonnay TL Merlot TL White Zin PAGE TOTALS TOTALS: IDEAL SALES ADJUSTMENT

21 22

INVENTORY CASH

24

DRAFT BEER SOFT DRINK TOTAL IDEAL SALES ACTUAL SALES ADJUSTMENT DRAFT BEER SOFT DRINK TOTAL ACTUAL SALES 23 OVER/SHORT OVER / SHORT TOTAL SALES CASH DROP OVER / SHORT INVENTORIED BY:

Bar Inventory work sheet and shows cash overage / shortage against ideal sales.

ue highlighted cells. All yellow highlighted cells are linked to the Liquor work sheet. All other cells are calculating fields. 1

1

0 BAR:

0

2

DATE:

0-Jan

3

BARTEND: BEG Inventory OZ

UNIT Reciv BT

END Inventory BT

0

OZ 0

Ideal Cons

0

COST SALES PRICE

IDEAL SALES

Bt/OZ

OVER/

TOTAL

ACTUAL SALES

SHORT

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$ $

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

26

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

0

$

-

$

-

$ -

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$ $ $ $ $ $

-

$ $ $ $ $ $

-

$ $ $

-

COGS $ COGS %

MTD REG MTD INV MTD (-/+) #DIV/0! MTD COG

25

$ #DIV/0!

NAME:

Tare WT 25.6g

BAR:

Size OZ

BAR INVENTORY

DATE:

PG 2-1

BARTEND:

DESCRIPTION

BEG Inventory BT

OZ

UNIT Reciv BT

33.5 Liquer Amaretto

END Inventory BT

Actual SALES Cons PRICE

IDEAL SALES

COST OZ

OZ 0

$0.00 $

-

$ -

18.5g

Blue Curacao

0

$0.00 $

-

$ -

21g

Liquer Kahlua

0

$0.00 $

-

$ -

15g

Martini & Rossi

0

$0.00 $

-

$ -

22g

Midori

0

$0.00 $

-

$ -

18g

Peach Schnapps

0

$0.00 $

-

$ -

Paul Masson Brandy

0

$0.00 $

-

$ -

Raspberry Rush

0

$0.00 $

-

$ -

0

$0.00 $

-

$ -

0

$0.00 $

-

$ -

0

$0.00 $

-

$ -

20g

22r

Vodka Absolut

0

$0.00 $

-

$ -

19r

Baccardi

0

$0.00 $

-

$ -

Baccardi Limo

0

$0.00 $

-

$ -

20r

Captain Morgan

0

$0.00 $

-

$ -

19r

Chivas Regal

0

$0.00 $

-

$ -

21.5r

Courvoisier

0

$0.00 $

-

$ -

22r

Blend Crown Royal

0

$0.00 $

-

$ -

16r

Cuervo Gold

0

$0.00 $

-

$ -

30r

Vodla Grey Goose

0

$0.00 $

-

$ -

24r

Hennessy

0

$0.00 $

-

$ -

21r

Hornito's

0

$0.00 $

-

$ -

16r

Jack Daniels

0

$0.00 $

-

$ -

20r

Jameson Irish Whiskey

0

$0.00 $

-

$ -

15r

Jim Beam

0

$0.00 $

-

$ -

Jonnie Walker

0

$0.00 $

-

$ -

20.5r

Makers Mark

0

$0.00 $

-

$ -

19r

Malibu

0

$0.00 $

-

$ -

26.5r

Patron Silver

0

$0.00 $

-

$ -

16.5r

JB Red Stag

0

$0.00 $

-

$ -

19r

Seagram's Gin

0

$0.00 $

-

$ -

17r

Seagram's VO

0

$0.00 $

-

$ -

19r

Smirnoff Vodka

0

$0.00 $

$ Encl. 3-1

10

15r

Southern Comfort

0

$0.00 $

-

$ -

16r

Wild Turkey

0

$0.00 $

-

$ -

$

-

PG 1 TOTALS

SPILLAGE:

ITEM

10

AMOUNT $

-

$

-

$

-

$

-

$

-

$

-

$

-

Encl. 3-1

ITEM

TOTA

COST TOTAL

ACTUAL SALES

OVER/ SHORT

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

10

Encl. 3-1

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

ITEM

TOTAL

AMOUNT $

-

$

-

$

-

$

-

$

-

$

-

$

-

10

Encl. 3-1

NAME:

0 BAR:

BAR INVENTORY

DATE:

PG 2-2

BARTEND: BEG Inventory

Tare WT

Size OZ

DESCRIPTION Bud Ice

BT

OZ

UNIT Reciv BT

BT 0

OZ

Cons

COST SALES PRICE

IDEAL SALES

Bt/OZ

$

-

$

-

$ -

Bud Light

0

$

-

$

-

$ -

Budweiser

0

$

-

$

-

$ -

Bud Light Lim

0

$

-

$

-

$ -

Bud Select

0

$

-

$

-

$ -

Bud Select S5

0

$

-

$

-

$ -

Coors Light

0

$

-

$

-

$ -

Miller GD

0

$

-

$

-

$ -

Miller Lite

0

$

-

$

-

$ -

Michelob Ultra

0

$

-

$

-

$ -

Corona

0

$

-

$

-

$ -

Corona Light

0

$

-

$

-

$ -

Heineken

0

$

-

$

-

$ -

Sam Adams

0

$

-

$

-

$ -

Guinness

0

$

-

$

-

$ -

Killians, Red

0

$

-

$

-

$ -

Smirnoff Ice

0

$

-

$

-

$ -

St. Pauli

0

$

-

$

-

$ -

Grout Stort

0

$

-

$

-

$ -

Amber Rock

0

$

-

$

-

$ -

O'Doules-G

0

$

-

$

-

$ -

TL Chardonnay (GL)

0

$

-

$

-

$ -

TL Merlot

(GL)

0

$

-

$

-

$ -

TL White Zin

(GL)

0

$

-

$

-

$ -

TL Chardonnay

0

$

-

$

-

$ -

TL Merlot

0

$

-

$

-

$ -

TL White Zin

0

$

-

$

-

$ -

PAGE TOTALS

$

-

TOTALS:

$

-

11

0

Actual

0

IDEAL SALES

0

END Inventory

$

- 3-1 Encl.

ADJUSTMENT

$ $

-

DRAFT BEER SOFT DRINK TOTAL IDEAL SALES

$

-

ACTUAL SALES ADJUSTMENT DRAFT BEER SOFT DRINK TOTAL ACTUAL SALES OVER/SHORT

$ $ $ $ $ $

-

$ $ $

-

CASH OVER / SHORT TOTAL SALES CASH DROP OVER / SHORT

#DIV/0!

INVENTORIED BY:

11

Encl. 3-1

0 0-Jan 0

COST

OVER/

TOTAL

ACTUAL SALES

SHORT

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$ $

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

COGS $

11

Encl. 3-1

COGS %

#DIV/0!

MTD REG MTD INV MTD (-/+) MTD COG

11

Encl. 3-1

Function Name:

Date Bartender:

ITEM

Selling Price

Tare WT

Size oz.

Beginning BT OZ

Unit REC BT

Ending BT OZ

Actual Cons

SELL PRICE

IDEAL SALES

Actual $ Sold

$ Variance

BEER Beer Heineken

$

-

0

$

-

$

-

$

-

$

-

Beer Guinness

$

-

0

$

-

$

-

$

-

$

-

Beer Corona

$

-

0

$

-

$

-

$

-

$

-

Beer Sam Adams

$

-

0

$

-

$

-

$

-

$

-

Beer Coors Light

$

-

0

$

-

$

-

$

-

$

-

Beer Budweiser

$

-

0

$

-

$

-

$

-

$

-

Beer Miller Lite

$

-

0

$

-

$

-

$

-

$

-

Beer O'Doul's

$

-

0

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Total Beer

LIQUOR Bourbon Jim Beam

$

-

0

$

-

$

-

$

-

$

-

Blend Seagrams VO

$

-

0

$

-

$

-

$

-

$

-

Bourbon Jack Daniels

$

-

0

$

-

$

-

$

-

$

-

Gin Tanqueray

$

-

0

$

-

$

-

$

-

$

-

Rum Bacardi Silver

$

-

0

$

-

$

-

$

-

$

-

Tequila Cuervo Gold

$

-

0

$

-

$

-

$

-

$

-

Vodka Absolut

$

-

0

$

-

$

-

$

-

$

-

Liquer Amaretto

$

-

0

$

-

$

-

$

-

$

-

Liquer Kahlua

$

-

0

$

-

$

-

$

-

$

-

Blend Crown Royal

$

-

0

$

-

$

-

$

-

$

-

Cognac Hennessey VS

$

-

0

$

-

$

-

$

-

$

-

Scotch Chivas Regal

$

-

0

$

-

$

-

$

-

$

-

Vodka Grey Goose

$

-

0

$

-

$

-

$

-

$

-

Cognac Remy Martin

$

-

0

$

-

$

-

$

-

$

-

Tequila Patron

$

-

0

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Total Liquor

WINE Cab Sauv Peter Villa

$

-

0

$

-

$

-

$

-

$

-

Chardonnay Peter Villa

$

-

0

$

-

$

-

$

-

$

-

White Zinfan Peter Villa

$

-

0

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Total Wine

Sodas & Mixers Coke

$

-

0

$

-

$

-

$

-

$

-

Diet Coke

$

-

0

$

-

$

-

$

-

$

-

Sprite

$

-

0

$

-

$

-

$

-

$

-

Water

$

-

0

$

-

$

-

$

-

$

-

Red Bull Energy Drink

$

-

0

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Total Non-Alcoholic

Soda Shortage as Mixer Gingerale

0

Club Soda

0

Tonic Water

0

Coke

0

Sprite

0

Orange Juice

0

Total Mixer

TOTAL IDEAL SALES

$

-

TOTAL ACTUAL SALES

$

-

INVENTORY VARIANCE

$

-

TOTAL ACTUAL SALES

$

-

CASH DROP

$

-

CASH VARIANCE

$

-

Total Cost

Unit Cost

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

LIQUOR DAILY INVENTORY DATE: ITEM

BAR: TARE

Absolut Vodka

R 22

Almaden Brandy

R 20

Apple Korn

R 21

Bacardi

R19

Bacardi Limon

R22

Candian Club

R 18

Chivas Regal

R19

Christian Brothers

R24

T Morgan Rum

R20

Crown Royal

R22

Grey Goose Vodka

R 30

Hennessy

R24

Hornito's

R21

Jack Daniels

R16

Jameson Irish W

R20

Jim Beam

R15

Jonnie Walkers (Black)

R

Jose Cuervo Tequila

R 16

Markers Mark

R20.5

Malibu Rum

R19

Military Spec Gin

R 19

Military Spec Tequila

R 19

Military Spec Vodka

R 19

Patron Silver

R 29

Paul Masson Brandy

R 17

Red Stag JB

R16.5

Seagram's 7

R19

Seagram's Gin

R19

Seagram's VO 750ml

R17

Smirnoff Vodka

R19

Tanqueray Gin

R20.5

Wild Turkey

R16

Amaretto

G15

BY: BEGINNING

RECEIVING

TRANSFER IN OUT

WASTE

Apple Pucker

G19

Island Pucker

G 18.5

Watermelon Pucker

G 19

Baileys Irish Cream

G 20

B&B Benedictine

G 23.5

Cointreau

G 24

Cream de Banana

G 16

DK Butter Shots Drambuie

G 19.5 G 19

Dry Vermouth Vermouth Gold Schlaeger

G 23

Grand Marnier

G 21.5

Hot Damn

G 19

Jaegermeister

G 20

Kahlua

G 17

Midori

G22

Peach Schnapps

G 18.5

Raspberry Rush

G 18.5

Rumple Mintz Sambuca

G 17 G 22.5

Southern Comfort

G 14

Tequila Rose

G 24

Tuaca

ENDING

BEER DATE: DESCRIPTION:

DAILY INVENTORY

BAR: PAR MIN/MAX

BEGINNING INVENTORY

BY: RECEIVED

TRANSFER IN

AMBER BOCK

0/12

BECKS BUD LIGHT

6/24

BUD LIGHT LIME BUDWEISER

6/24

BUDW SELECT

0/6

COORS LIGHT

6/24

CORONA

6/24

GUINNESS DRGHT

0/6

HEINEKEN

6/18

KILLIANS, RED

0/12

LOEWENBRAU MICHELOB ULTRA

0/6

MILLER GD

6/18

MILLER LITE

6/24

MOOSE DROOL MONSTER O'DOULS

0/12

RED BULL

0/6

SAM ADAMS

6/18

SMIRNOFF ICE

0/6

ST. PAULI GIRL

LAND SHARK BOULEVARD BLUE MOON

OUT

SPILAGE

ENDING INVENTORY