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

SPIRITS

COURVOISIER

70 17.95 103.60 3.70 79.2 70 26.18 114.80 4.10 72.6

1.1 1.7

1.0

1.1 1.0 1.1 0.6

103.60 32 68.88 53

COURVOISIER VSOP

JULES CLARION

70 11.06

LOSS

1.0

1.0

MARTELL VS

70 18.14 103.60 3.70 79.0 70 26.78 169.40 6.05 81.0 70 12.14 86.80 3.10 83.2 70 14.80 86.80 3.10 79.5 70 14.18 103.60 3.70 83.6 70 16.18 86.80 3.10 77.6 70 14.56 91.00 3.25 80.8 70 25.75 88.20 3.15 65.0 70 11.82 86.80 3.10 83.7 70 13.83 89.60 3.20 81.5 70 14.46 86.80 3.10 80.0 70 21.30 113.40 4.05 77.5 70 18.70 95.20 3.40 76.4 70 21.18 100.80 3.60 74.8 70 21.18 100.80 3.60 74.8 70 13.19 86.80 3.10 81.8 70 25.68 133.00 4.75 76.8 70 21.07 114.80 4.10 78.0 70 21.67 117.60 4.20 77.9 70 29.84 131.60 4.70 72.8 70 19.18 126.00 4.50 81.7 70 17.98 109.20 3.90 80.2 70 15.06 109.20 3.90 83.5 70 15.84 100.80 3.60 81.1 70 11.95 89.60 3.20 84.0 70 13.27 49.00 3.50 67.5 70 12.42 56.00 4.00 73.4 70 10.49 43.40 3.10 71.0 70 15.40 49.00 3.50 62.3 70 10.34 84.00 3.00 85.2 70 17.45 109.20 3.90 80.8 70 17.82 54.60 3.90 60.8 70 8.86 56.00 2.00 81.0 70 20.67 57.40 4.10 56.8 70 20.67* 54.60 3.90 54.6 70 15.29 75.60 2.70 75.7 70 11.84 84.00 3.00 83.1 70 13.79 78.40 2.80 78.9 70 19.68 78.40 2.80 69.9 70 11.97 106.40 3.80 86.5 70 13.64 56.00 4.00 70.8 70 3.94 70 5.10 70 5.10 70 7.12

2.0 0.9 2.1 3.0 1.9 4.1 2.4 1.7 6.6 6.1 1.6 1.9 1.7 1.9 3.8 2.1 1.2 0.9 1.7 1.5 1.4 4.4 0.3 2.2

0.9 1.1 0.8 0.1 2.0 0.1 2.8 0.2 1.2 0.7 3.5 0.6 1.7 0.7 0.6 1.1 3.6 4.0 2.7 3.4 1.2 0.4 0.5 1.4 1.0 0.7 1.9 1.0 2.9 0.9 1.7 0.4 1.1 0.1 0.6 0.3 1.0 0.7 1.1 0.4 0.9 0.5 3.5 1.9 0.7 0.6 1.8 0.4 2.3 0.1 7.3 3.5 0.5 0.5 0.5 0.5 0.4 0.6 1.5 1.4 0.5 0.4 1.1 1.7 0.2 1.1 1.9 1.0

113.96 24 16.94 232 8.68 300+ 17.36 300+ 72.52 50 52.08 169 63.70 70 97.02 16 347.20 26 304.64 23 34.72 87 158.76 10 66.64 41 100.80 55 90.72 93 34.72 123 13.30 300+ 34.44 58 82.32 41 52.64 80 63.00 52 207.48 53 65.52 34 40.32 131 3.08 300+ 313.60 60

REMY MARTIN VSOP LAMBS NAVY RUM

BACARDI

HAVANA ESPECIAL

SAILOR JERRY

BOMBAY SAPHIRE BURLEIGH DRY GIN

GORDONS

1.0

GORDONS PINK

GORDONS SLOE GIN

HENDRICKS GIN

OPIHR GIN

W/N BLOOD ORANGE WHITLEY NEILL RHUB FAMOUS GROUSE

1.0

GLENFIDDICH HAIG CLUBMAN

ISLE OF JURA 10YR

LAPHROAIG

MONKEY SHOULDER

JACK DANIELS JAMESONS IRISH

1.0 1.0

SOUTHERN COMFORT

GREY GOOSE SMIRNOFF CAMPARI PIMMS NO1 GRENADINE

70 26.14 30.80 1.10 LOSS 2.4

10.8

1.1 1.9

300+ 300+ 300+

LOSS 1.0 LOSS 1.0 LOSS 1.0 LOSS 1.0

CARAMEL SYRUP CHERRY SYRUP MONIN VANILLA

29 29 19

ADVOCAAT AMARETTO

0.2 1.9 0.9 1.8 1.9 0.9 3.8 2.0 0.2 2.0 2.1 1.8 2.0 3.8 1.3

8.68

1.0

68.60 31 33.60 36 95.20 19

ARCHERS PEACH

BAILEYS IRISH CREAM 70 12.87 56.00 4.00 72.4

1.0

CHAMBORD COINTREAU

1.9 0.9 3.8

300+ 300+ 300+

CORKYS

DRAMBUIE

1.9 0.1

5.74 300+

GRAND MARNIER JAGERMEISTER

1.0 1.0

1.2

300+

1.5 1.5 1.7 0.4 1.1 0.7

113.40 29 33.60 123 54.88 46

MALIBU

SAMBUCA

TEQUILA GOLD TEQUILA ROSE

2.0

300+

2.9 0.9 1.0 0.3 79.9 37.1

95.76 93 16.80 97

TIA MARIA

107.0 10.0

SALES AT SELLING 3154.90 CLOSING AT COST 1263.91 SALES AT COST 571.04

Ref:073

* New Cost or Selling Price

LOSS Non-profit item GP% excludes 20.0% VAT

Page 1