Beverage Stock Take Template

Document Sample
Beverage Stock Take Template Powered By Docstoc
					Beverage Stock Take
For more small business templates visit: © 2008 Spreadsheet123.com

Inventory Settings
Unit Spirits
Teachers Bells Bells Glenfiddich Glenmorangie Jack Daniels Jack Daniels Jim Beam Jameson's Irish Jameson's Irish Southern Comfort Southern Comfort Gordons' Gin Gordons' Gin Bombay Sapphire Smirnoff Red Smirnoff Red Absolut Captain Morgan Bacardi Bacardi Martell *** Martell *** Remy Martin Baileys Baileys Cointreau Drambuie Malibu Malibu Archers Archers Tequila Luxardo Sambuca Tia Maria Tia Maria Bottle 70cl 70cl 1.5ltr 70cl 70cl 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 1.5ltr 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 70cl 70cl 1.5Ltr 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 70cl 70cl 1.5Ltr 70cl 70cl 70cl 70cl 70cl 1.5ltr

UOM
25ml Shots 28.0 28.0 60.0 28.0 28.0 28.0 60.0 28.0 28.0 60.0 28.0 60.0 28.0 60.0 28.0 28.0 60.0 28.0 28.0 28.0 60.0 28.0 60.0 28.0 28.0 60.0 28.0 28.0 28.0 60.0 28.0 28.0 28.0 28.0 28.0 60.0 £21.35 £9.97 £20.06 £14.45 £17.85 £12.06 £25.17 £11.39 £10.28 £20.77 £10.91 £22.57 £8.84 £18.23 £10.17 £8.96 £18.46 £9.46 £8.51 £9.42 £20.58 £11.58 £24.71 £18.36 £8.70 £17.84 £11.51 £12.92 £7.82 £16.23 £7.60 £15.01 £10.27 £8.97 £9.83 £20.71

Cost
Per Bottle Per Shot £0.76 £0.36 £0.33 £0.52 £0.64 £0.43 £0.42 £0.41 £0.37 £0.35 £0.39 £0.38 £0.32 £0.30 £0.36 £0.32 £0.31 £0.34 £0.30 £0.34 £0.34 £0.41 £0.41 £0.66 £0.31 £0.30 £0.41 £0.46 £0.28 £0.27 £0.27 £0.54 £0.37 £0.32 £0.35 £0.35

Fortified Wines
Cinzano Bianco Martini Dry Martini Rosso Campari Cockburns Ruby Bristol Cream Club Classic Harveys Dune

Bottle 75cl 75cl 75cl 75cl 75cl 75cl 75cl 75cl

50ml Shots 15.0 15.0 15.0 15.0 15.0 15.0 15.0 15.0

Per Bottle £3.44 £3.55 £3.46 £8.30 £5.50 £5.22 £4.42 £4.40

Per Shot £0.23 £0.24 £0.23 £0.55 £0.37 £0.35 £0.29 £0.29

Table Wines
35º South Red Lindemans' Chardonnay Arniston Bay Côtes du Rhône Jacobs Creek Louis Raymond Castletorre Muscadet Piesporter Piesporter (Small) Pinot Grigio Faustino Crianza 35º South White

Bottle Case 12Bt Case 6Bt Case 6Bt Case 12Bt Case 12Bt Sm. Case 12Bt Sm. Case 12Bt Sm. Case 6Bt Case 6Bt Case 6Bt Case 6Bt Case 12Bt Case 12Bt

Bottle Size 750ml 750ml 750ml 750ml 750ml 750ml 750ml 750ml 750ml 375ml 750ml 750ml 750ml

Each 12.0 6.0 6.0 12.0 12.0 12.0 12.0 6.0 6.0 6.0 6.0 12.0 12.0

Per Case £34.68 £3.21 £2.87 £2.47 £4.45 £7.82 £2.00 £2.36 £2.13 £1.15 £2.55 £3.59 £2.99

Per Bottle £2.89 £0.54 £0.48 £0.21 £0.37 £0.65 £0.17 £0.39 £0.36 £0.19 £0.43 £0.30 £0.25

Draught Beer
Boddingtons Murphy's

Keg 22 Gallon 10 Gallon

Size in Pints 176 80

Per Keg £95.38 £53.25

Per Pint £0.54 £0.67

Draught Lager
Hoegaarden Stella Artois Stella Artois

Keg 7.1 Gallon 22 Gallon 10 Gallon

Size in Pints 56.8 176 80

Per Keg £35.00 £95.46 £55.40

Per Pint £0.62 £0.54 £0.69

Bottled Beer
Labatt Ice Stella Artois Budweiser Becks Old Speckled Hen Bacardi Breezer WKD Blue/Iron Brew Smirnoff Ice/Black Ice

Bottle/Can Case 24Bt Case 24Bt Case 24Bt Case 24Bt Case 12Bt Case 24Bt Case 24Bt Case 24Bt

Bottle Size 330ml 330ml 330ml 275ml 500ml 275ml 275ml 275ml

Each 24.0 24.0 24.0 24.0 12.0 24.0 24.0 24.0

Per Case £13.32 £10.56 £17.22 £14.10 £26.34 £19.20 £19.44 £21.86

Per Bottle £0.56 £0.44 £0.72 £0.59 £2.20 £0.80 £0.81 £0.91

Cider
Strongbow Woodpecker

Bottle/Can Case 24Bt Case 24Bt

Bottle Size 275ml 275ml

Each 24.0 24.0

Per Case £10.92 £11.16

Per Bottle £0.46 £0.47

Minerals
Britvic J20 Coke/Diet Coke Fruit Juices Fruit Juices Minerals Minerals Tango Diet Strathmore Strathmore Red Bull Squash/Cordial Lime Cordial Coke/Diet Coke (Cans)

Bottle/Can Case 24Bt Case 36Bt Case 36Bt Case 48Bt Case 36Bt Case 48Bt Case 36Bt Case 12Bt Case 24Bt Case 24Bt Case 12Bt Case 12Bt Case 24Bt

Bottle Size 275ml 330ml 180ml 113ml 180ml 113ml 180ml 1Ltr 330ml 250ml 1Ltr 1Ltr 330ml

Each 24.0 36.0 36.0 48.0 36.0 48.0 36.0 12.0 24.0 24.0 12.0 12.0 24.0

Per Case £10.08 £19.08 £2.40 £1.82 £1.84 £1.38 £2.12 £4.91 £2.54 £7.67 £0.77 £0.77 £12.22

Per Bottle £0.42 £0.53 £0.07 £0.04 £0.05 £0.03 £0.06 £0.41 £0.11 £0.32 £0.06 £0.06 £0.51

Post-Mix Drinks
Post-Mix Pepsi/Diet Post-Mix Lemonade Post-Mix Tango Sprite

Cartons 10Ltr 10Ltr 10Ltr 5Ltr

Portion Size in ml 20 20 20 25

Portions 500.0 500.0 500.0 200.0

Per Carton £15.25 £14.43 £12.30 £15.53

Per Portion £0.03 £0.03 £0.02 £0.08

Containers
Cases Bottles - Small Suregas B Suremix 30/50 Each Each Each Each 1.0 1.0 1.0 1.0 £1.00 £0.04 £15.75 £28.30

e

plates visit: Spreadsheet123.com © 2008 Spreadsheet123.com

Retail
Per Shot £1.89 £1.94 £1.94 £2.56 £2.79 £2.06 £2.06 £2.06 £2.06 £2.06 £2.06 £2.06 £1.89 £1.89 £2.45 £1.89 £1.89 £2.45 £1.89 £1.89 £1.89 £2.56 £2.56 £3.12 £2.06 £2.06 £2.06 £2.06 £1.89 £1.89 £1.89 £1.89 £2.06 £2.06 £2.06 £2.06 Per Bottle £52.92 £54.32 £116.40 £71.68 £78.12 £57.68 £123.60 £57.68 £57.68 £123.60 £57.68 £123.60 £52.92 £113.40 £68.60 £52.92 £113.40 £68.60 £52.92 £52.92 £113.40 £71.68 £153.60 £87.36 £57.68 £123.60 £57.68 £57.68 £52.92 £113.40 £52.92 £52.92 £57.68 £57.68 £57.68 £123.60

Per Shot £1.89 £1.89 £1.89 £1.89 £2.34 £2.34 £2.27 £2.34

Per Bottle £28.35 £28.35 £28.35 £28.35 £35.10 £35.10 £34.05 £35.10

Per Bottle £10.75 £11.25 £10.75 £9.95 £15.40 £20.00 £9.95 £9.95 £10.25 £5.40 £11.25 £11.75 £10.75

Per Case £129.00 £67.50 £64.50 £119.40 £184.80 £240.00 £119.40 £59.70 £61.50 £32.40 £67.50 £141.00 £129.00

Per Pint £2.68 £2.92

Per Keg £471.68 £233.60

Per Pint £2.55 £2.92 £2.92

Per Keg £144.84 £513.92 £233.60

Bottle/Can £2.72 £2.64 £2.93 £2.72 £2.85 £2.85 £2.85 £2.98

Per Case £65.28 £63.36 £70.32 £65.28 £34.20 £68.40 £68.40 £71.52

Bottle/Can £1.99 £1.99

Per Case £47.76 £47.76

Bottle/Can £1.74 £1.65 £1.10 £1.02 £1.10 £1.02 £1.10 £3.15 £1.33 £2.53 £0.33 £4.83 £1.65

Per Case £41.76 £59.40 £39.60 £48.96 £39.60 £48.96 £39.60 £37.80 £31.92 £60.72 £3.96 £57.96 £39.60

Per Portion £1.65 £1.65 £1.10 £1.65

Per Carton £825.00 £825.00 £550.00 £330.00

Beverage Stock Take
For more small business templates visit: Spreadsheet123.com © 2008 Spreadsheet123.com

Budget Settings
Weeks in month Forecasted Monthly Revenue Forecasted Growth Profit % 74% 4

Budget
Week 1 Budgeted Revenue (Less Tax/VAT) Actual Revenue (Less Tax/VAT) Variance
£0.00 £0.00 £0.00

Week 2
£0.00 £0.00 £0.00

Week 3
£0.00 £0.00 £0.00

Week 4
£0.00 £0.00 £0.00

Week 5

Delivery Cost
Actual Delivery Cost Forecasted Spending Allowance Actual Spending Allowance Variance
£0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Growth Profit %
Budgeted GP % Actual GP % Variance
74.00% 74.00% 74.00% 74.00%

Spreadsheet123.com 008 Spreadsheet123.com

£0.00 £0.00 £0.00

£0.00 £0.00 £0.00 £0.00

74.00%

Beverage Stock Take
For more small business templates visit: Spreadsheet123.com © 2008 Spreadsheet123.com

Stock Opening
Bottles Spirits
Teachers Bells Bells Glenfiddich Glenmorangie Jack Daniels Jack Daniels Jim Beam Jameson's Irish Jameson's Irish Southern Comfort Southern Comfort Gordons' Gin Gordons' Gin Bombay Sapphire Smirnoff Red Smirnoff Red Absolut Captain Morgan Bacardi Bacardi Martell *** Martell *** Remy Martin Baileys Baileys Cointreau Drambuie Malibu Malibu Archers Archers Tequila Luxardo Sambuca Tia Maria Tia Maria Bottle 70cl 70cl 1.5ltr 70cl 70cl 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 1.5ltr 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 70cl 70cl 1.5Ltr 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 70cl 70cl 1.5Ltr 70cl 70cl 70cl 70cl 70cl 1.5ltr Cellar Front Opened Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Per Bottle £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Bottles Fortified Wines
Cinzano Bianco Martini Dry Martini Rosso Campari Cockburns Ruby Bristol Cream Club Classic Harveys Dune Bottle 75cl 75cl 75cl 75cl 75cl 75cl 75cl 75cl Cellar Front Opened Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Per Bottle £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Bottles Table Wines
35º South Red Lindemans' Chardonnay Arniston Bay Côtes du Rhône Jacobs Creek Louis Raymond Castletorre Muscadet Piesporter Piesporter (Small) Pinot Grigio Faustino Crianza 35º South White Bottle Case 12Bt Case 6Bt Case 6Bt Case 12Bt Case 12Bt Sm. Case 12Bt Sm. Case 12Bt Sm. Case 6Bt Case 6Bt Case 6Bt Case 6Bt Case 12Bt Case 12Bt Cellar Front Opened Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Per Case £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Kegs Draught Beer
Boddingtons Murphy's Keg 22 Gallon 10 Gallon Full Opened Cost Of Stock £0.00 £0.00 £0.00 £0.00

Kegs Draught Lager
Hoegaarden Stella Artois Stella Artois Keg 7.1 Gallon 22 Gallon 10 Gallon Full Opened Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Bottles (Each) Bottled Beer
Labatt Ice Stella Artois Budweiser Becks Old Speckled Hen Bacardi Breezer WKD Blue/Iron Brew Smirnoff Ice/Black Ice Bottle/Can Case 24Bt Case 24Bt Case 24Bt Case 24Bt Case 12Bt Case 24Bt Case 24Bt Case 24Bt Cellar Front Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Per Dozen £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Bottles (Each) Cider
Strongbow Woodpecker Bottle/Can Case 24Bt Case 24Bt Cellar Front Cost Of Stock £0.00 £0.00 Per Dozen £0.00 £0.00

Bottles (Each) Minerals
Britvic J20 Coke/Diet Coke Fruit Juices Fruit Juices Minerals Minerals Tango Diet Strathmore Strathmore Red Bull Squash/Cordial Lime Cordial Bottle/Can Case 24Bt Case 36Bt Case 36Bt Case 48Bt Case 36Bt Case 48Bt Case 36Bt Case 12Bt Case 24Bt Case 24Bt Case 12Bt Case 12Bt Cellar Front Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Per Dozen £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Coke/Diet Coke (Cans)

Case 24Bt

£0.00

£0.00

Cartons Post-Mix Drinks
Post-Mix Pepsi/Diet Post-Mix Lemonade Post-Mix Tango Sprite Cartons 10Ltr 10Ltr 10Ltr 5Ltr Cellar Opened Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Containers
Cases Bottles - Small Suregas B Suremix 30/50 Each Each Each Each

Cellar

Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Total Value of Opening Stock @ Cost Price Total Value of Opening Stock @ Retail Price

et123.com et123.com

Spirits £0.00 £0.00

Cost Value Retail Value

Fort. £0.00 £0.00

Cost Value Retail Value

Wine £0.00 £0.00

Cost Value Retail Value

Beer £0.00 £0.00

Cost Value Retail Value

Lager £0.00 £0.00

Cost Value Retail Value

Bottled £0.00 £0.00

Cost Value Retail Value

Cider £0.00 £0.00

Cost Value Retail Value

Mineral £0.00 £0.00

Cost Value Retail Value

Mix £0.00 £0.00

Cost Value Retail Value

Containers £0.00 Cost Value Retail Value

£0.00 £0.00

Beverage Stock Take
Week 1
Delivery Spirits
Teachers Bells Bells Glenfiddich Glenmorangie Jack Daniels Jack Daniels Jim Beam Jameson's Irish Jameson's Irish Southern Comfort Southern Comfort Gordons' Gin Gordons' Gin Bombay Sapphire Smirnoff Red Smirnoff Red Absolut Captain Morgan Bacardi Bacardi Martell *** Martell *** Remy Martin Baileys Baileys Cointreau Drambuie Malibu Malibu Archers Archers Tequila Luxardo Sambuca Tia Maria Tia Maria Bottle 70cl 70cl 1.5ltr 70cl 70cl 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 1.5ltr 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 70cl 70cl 1.5Ltr 70cl 1.5Ltr 70cl 70cl 1.5Ltr 70cl 70cl 70cl 1.5Ltr 70cl 70cl 70cl 70cl 70cl 1.5ltr Delivery Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

For more small busines

Total Stock
Cellar

Weekly Stock Count
Front

0.0 Fortified Wines
Cinzano Bianco Martini Dry Martini Rosso Campari Cockburns Ruby Bristol Cream Club Classic Harveys Dune Bottle 75cl 75cl 75cl 75cl 75cl 75cl 75cl 75cl 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cellar Front

0.0 Table Wines
35º South Red Lindemans' Chardonnay Arniston Bay Côtes du Rhône Jacobs Creek Louis Raymond Castletorre Muscadet Piesporter Piesporter (Small) Pinot Grigio Faustino Crianza 35º South White Bottle Case 12Bt Case 6Bt Case 6Bt Case 12Bt Case 12Bt Sm. Case 12Bt Sm. Case 12Bt Sm. Case 6Bt Case 6Bt Case 6Bt Case 6Bt Case 12Bt Case 12Bt 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cellar Front

0.0 Draught Beer
Boddingtons Murphy's Keg 22 Gallon 10 Gallon 0.0 0.0 Cellar Front

0.0 Draught Lager
Hoegaarden Stella Artois Stella Artois Keg 7.1 Gallon 22 Gallon 10 Gallon 0.0 0.0 0.0 Cellar Front

0.0 Bottled Beer
Labatt Ice Stella Artois Budweiser Becks Old Speckled Hen Bacardi Breezer WKD Blue/Iron Brew Smirnoff Ice/Black Ice Bottle/Can Case 24Bt Case 24Bt Case 24Bt Case 24Bt Case 12Bt Case 24Bt Case 24Bt Case 24Bt 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cellar Front

0.0 Cider
Strongbow Woodpecker Bottle/Can Case 24Bt Case 24Bt 0.0 0.0 Cellar Front

0.0 Minerals
Britvic J20 Coke/Diet Coke Fruit Juices Fruit Juices Minerals Minerals Tango Diet Strathmore Strathmore Red Bull Bottle/Can Case 24Bt Case 36Bt Case 36Bt Case 48Bt Case 36Bt Case 48Bt Case 36Bt Case 12Bt Case 24Bt Case 24Bt 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cellar Front

Squash/Cordial Lime Cordial Coke/Diet Coke (Cans)

Case 12Bt Case 12Bt Case 24Bt

0.0 0.0 0.0

0.0 Post-Mix Drinks
Post-Mix Pepsi/Diet Post-Mix Lemonade Post-Mix Tango Sprite Cartons 10Ltr 10Ltr 10Ltr 5Ltr 0.0 0.0 0.0 0.0 Cellar Front

0.0

Containers
Cases Bottles - Small Suregas B Suremix 30/50 Each Each Each Each 0.0 0.0 0.0 0.0 0.0

Cellar

Front

Total Value of Stock on

Total Value of Stock on W

Total Weekly Sales fro

ck Take
For more small business templates visit: Spreadsheet123.com © 2009 Spreadsheet123.com

Weekly Stock Count
Opened Variance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Retail
Value £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Value of
Variance £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Spirits

£0.00 £0.00 £0.00 Retail
Opened Variance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Value £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Value of
Variance £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Fort. £0.00 £0.00 £0.00 Retail
Opened Variance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Value £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Value of
Variance £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Wine £0.00 £0.00 £0.00 Retail
Opened Variance 0.0 0.0 Cost Of Stock £0.00 £0.00 Value £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Value of
Variance £0.00 £0.00

Beer £0.00 £0.00

Cost Value Retail Value

£0.00 Retail
Opened Variance 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 Value £0.00 £0.00 £0.00

Retail Value of Variance

Value of
Variance £0.00 £0.00 £0.00

Lager £0.00 £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Retail
Opened Variance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Value £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Value of
Variance £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Bottled £0.00 £0.00 £0.00 Retail
Opened Variance 0.0 0.0 Cost Of Stock £0.00 £0.00 Value £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Value of
Variance £0.00 £0.00

Cider £0.00 £0.00 £0.00 Retail
Opened Variance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Value £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Value of
Variance £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

0.0 0.0 0.0

£0.00 £0.00 £0.00

£0.00 £0.00 £0.00

£0.00 £0.00 £0.00

Mineral £0.00 £0.00 £0.00 Retail
Opened Variance 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 Value £0.00 £0.00 £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Value of
Variance £0.00 £0.00 £0.00 £0.00

Mix £0.00 £0.00 £0.00

Cost Value Retail Value Retail Value of Variance

Retail
Opened Variance 0.0 0.0 0.0 0.0 Cost Of Stock £0.00 £0.00 £0.00 £0.00 Value

Value of
Variance £0.00 £0.00 £0.00 £0.00

Containers £0.00 Cost Value £0.00 Retail Value £0.00 Retail Value of Variance

Total Cost of Delivered Items Total Value of Stock on Week Closing @ Cost Price Total Value of Stock on Week Closing @ Retail Price Total Value of Variance @ Retail Price Total Weekly Sales from POS Including Tax/VAT Total Weekly Sales Excluding Tax/VAT Cost of Sale Margin Actual G.P.%

£0.00 £0.00 £0.00 £0.00 £0.00

Beverage Stock Take
Week 2
Delivery Spirits
Teachers Bells Bells Glenfiddich Glenmorangie Jack Daniels Jack Daniels Jim Beam Jameson's Irish Jameson's Irish Southern Comfort Southern Comfort Gordons' Gin Gordons' Gin Bombay Sapphire Smirnoff Red Smirnoff Red Absolut Captain Morgan Bacardi Bacardi Martell *** Martell *** Remy Martin Baileys Baileys Cointreau Drambuie Malibu Malibu Archers Archers Tequila Luxardo
				
DOCUMENT INFO
Shared By:
Stats:
views:3272
posted:8/3/2009
language:English
pages:86
Description: Running a business is not only about making profit, but also consistent control and monitoring of how this profit is being made, the amount of costs involved and so on. Small Businesses like Restaurants, Bars, Public Houses with beverage as their primary product usually have to concentrate on the stock and cost control as on the other hand on their budget and effective profitability. Controlling stock is a must for every restaurant that is serious about making a profit and not only at the end of the month, but at the end of each week. The Beverage Stock Take Template contains five Liquor Stock Take worksheet for every week of the month along with Beverage Key Line Check and Budget Forecasting Tool that can allocate your forecasted budget and calculate your weekly spending allowance for the set Beverage Growth Profit Margin. Beverage Key Line Check is a simple tool that follows your beverage line and can help to indentify the product that your restaurant may be loosing on. Beverage Growth Profit Margin is a share of the revenue generated by your product that runs at around 70% to 74% when the rest 26% to 30% is a cost of the product.
BUY THIS DOCUMENT NOW PRICE: $24.95 100% MONEY BACK GUARANTEED
PARTNER Spreadsheet123 Ltd
Spreadsheet123 is your ultimate guide to the world of Excel. Every template that you could need for business, real estate, budgeting, personal and corporate finance can be found on this site. In addition, there are Excel calculators, tutorials and links. Visit www.spreadsheet123.com for all of your spreadsheet needs.