Hotel Directors Meeting March 2020

S30 QUORN GRANGE HOTEL QUORN

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

Description

Size Cost Price

Selling Price

Bar Price

Gross Profit%

Opening Stock

Purchases Credits Closing Stock

Sales

Sales at Selling

Days Stock

FORTIFIED WINE

MARTINI BIANCO

75 5.53 37.50 2.50 82.3 75 6.28 37.50 2.50 79.9 75 6.31 37.50 2.50 79.8 75 12.29 52.50 3.50 71.9 75 7.06 45.00 3.00 81.2 75 9.44 49.50 3.30 77.1 75 6.57 45.00 3.00 82.5 75 7.87 LOSS

1.4 0.9 1.4 0.9 0.9 2.1 0.8

1.1 0.3 0.6 0.3 1.3 0.1 1.1 1.8

11.25 106 11.25 58 3.75 300+ 94.50 18

MARTINI DRY

MARTINI ROSSO

COCKBURNS SPECIAL

2.0

CLUB PORT

2.0 2.0

BRISTOL CREAM CROFT ORIGINAL BARB MANZANILLA

0.9

300+

2.0 0.1

4.95 300+

0.8

300+

8.4 4.0 2.0 7.8 2.6

SALES AT SELLING 125.70 CLOSING AT COST 62.06 SALES AT COST 27.24

TABLE WINE

SANTA HELENA SAV B CHENIN BLANC FRANS

75 4.31 16.50 16.50 68.7 75 5.11 18.50 18.50 66.9

48.5 10.0 12.0 24.1 17.4 10.4 11.0 31.6 28.4 55.1 16.4 12.1 12.3 12.0 18.6 12.5 8.0 6.0

36.0

35.2 49.3 9.0 1.0 8.6 9.4 24.1 30.0 12.0 5.4 17.1 11.3 9.0 2.0 23.2 8.4 24.2 10.2 31.8 47.3 18.9 15.5 12.0 6.0 17.6 24.5 10.0 2.0 22.8 25.8 12.0 0.5 8.0

813.45 21 18.50 261 164.50 27 585.00 23 113.40 64 248.60 44 55.00 131 151.20 80 193.80 69 780.45 19 271.25 35 114.00 58 514.50 21 67.50 71 48.00 145 695.31 26 22.48 300+ 300+

WILDWOOD CHARDONNAY 75 4.70 17.50 17.50 67.8

6.0

PINOT GRIGIO CANALE VDP VIOGNIER PAT SOUTH LIGHTS SAV BL

75 5.00 19.50 19.50 69.2 75 5.21 21.00 21.00 70.2 75 5.71 22.00 22.00 68.9 75 6.93 24.50 24.50 66.0

30.0

18.0

PICPOUL DE PINET

DOM ROMY CHARD BLAN 75 7.90 27.50 27.50 65.5

PINOT ROSE TERRA

75 4.52 18.00 18.00 69.8

BURLESQUE ZINFANDEL 75 5.07 19.00 19.00 68.0 SANTA HELENA MERLOT 75 4.31 16.50 16.50 68.7

6.0

24.0 18.0 12.0 30.0

WILDWOOD SHIRAZ

75 4.70 17.50 17.50 67.8

FRANSCHHOEK CAB SAV 75 5.25 19.00 19.00 66.9

VISTAMAR MALBEC

75 5.64 21.00 21.00 67.8

VISTAMAR PINOT NOIR 75 5.64 22.50 22.50 69.9

2.0 7.3 3.0

VINA ALARDE RIOJA

75 6.22 24.00 24.00 68.9

PROSECCO CANALATTO 75 7.06 26.95 26.95 68.6

30.0

BERNARD REMY

75 17.12 44.95 44.95 54.3 75 36.79 79.50 79.50 44.5

MOET CHANDON ROSE

2.0 3.0 3.0 2.0

2.0 3.0 3.0 2.0

300+ 300+ 300+ 300+

LAURANT PERRIER BRU 75 26.92 59.50 59.50 45.7

L PERRIER ROSE

75 38.78 79.50 79.50 41.5 75 27.64 59.50 59.50 44.3 75 4.26 17.85 4.25 71.4 75 4.26 17.85 4.25 71.4 75 6.51 30.00 5.00 74.0 75 2.25 9.00 9.00 70.0

LOUIS ROEDERER NV TIER CHARDONNAY

6.0 6.0

1.4 4.6 5.7 1.3

82.11 9 23.21 127

TIER MERLOT

1.0

LA DELF PROSECCO

12.0

12.0

360.00

SCHLOER

14.0

14.0

300+

KITCHEN WINE

75 4.09*

LOSS

42.0 42.0 371.4 276.0 44.0 333.9 269.5

SALES AT SELLING 5322.26 CLOSING AT COST 2118.20 SALES AT COST 1379.20

DRAUGHT BEER

AMSTEL LAGER

GAL 10.63 36.80 4.60 65.3

45.0 24.0 20.0 47.0

22.0

33.0 34.0 1251.20 28

BOMBARDAIR SMOOTH GAL 8.70 32.00 4.00 67.4 CASK CUMBERLAND ALE GAL 10.48 32.80 4.10 61.6

12.0 12.0 17.0 30.0

384.00 29 984.00 16

27.0 22.0 26.4

ESTRELLA DAMM

GAL 11.08 38.40 4.80 65.4 GAL 12.49 38.40 4.80 61.0 GAL 8.02 31.20 3.90 69.2

10.0 59.0 2265.60 5

GUINNESS STELLA "4"

8.6

14.2 20.8

798.72 20

28.0

55.0 1.5 20.0 61.5 1918.80 9

172.6 152.4 1.5 106.2 217.3

SALES AT SELLING 7602.32 CLOSING AT COST 1081.88 SALES AT COST 2186.79

Ref:073

* New Cost or Selling Price

LOSS Non-profit item GP% excludes 20.0% VAT

Page 2