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

PACKAGED BEER

BECKS BIER BUDWEISER

NRB 275 11.80 38.40 3.20 63.1 NRB 330 11.37 38.40 3.20 64.5

4:11

3:11

1:0 1:6 0:4 1:0 0:6 1:9 1:8

38.40 114 57.60 102 14.00 44 42.00 5 19.20 82 58.80 22 70.00 107

6:9

5:3 0:6 0:2 1:4 1:5 1:4 6:2

CHARNWOOD SALVATION 500 22.50 42.00 3.50 35.7

0:10

CHARNWOOD VIXEN

500 22.50 42.00 3.50 35.7 330 16.02 37.20 3.10 48.3 330 11.59 38.40 3.20 63.8 500 12.99 33.60 2.80 53.6 NRB 330 13.05 42.00 3.50 62.7

1:2 4:2

CORONA

2:10 105.40 14

DAURADAMM

1:11

ERDINGER FREE PERONI NASTRO

3:1

7:10

30:8

20:1

10:7 SALES AT SELLING 405.40 CLOSING AT COST 256.48 SALES AT COST 154.52

CIDERS & PERRIES

THATCHERS GOLD

GAL 8.73 31.20 3.90 66.4 500 19.46 58.80 4.90 60.3

18:0

22:0

17:0

23:0

717.60 21

RECORDALIG

6:10

1:3

5:2

2:11 171.50 51

24:10

23:3

22:2

25:11 SALES AT SELLING 889.10 CLOSING AT COST 248.90 SALES AT COST 257.49

MINERALS

COCA COLA

LTR 10.00 63.00 5.25 81.0 1.2 10.00 68.16 5.68 82.4 1.5 11.94 94.44 7.87 84.8 NRB 275 7.35 33.60 2.80 73.8 NRB 275 8.90 36.00 3.00 70.4 200 4.99 24.00 2.00 75.1 200 5.52 24.00 2.00 72.4 200 4.95 24.00 2.00 75.3 200 4.95 24.00 2.00 75.3 200 4.38 22.80 1.90 77.0 200 4.95 22.80 1.90 73.9 NRB 300 8.61 28.80 2.40 64.1 CAN 330 5.90 15.60 1.30 54.6 330 4.95 15.60 1.30 61.9 250 9.27 37.20 3.10 70.1 LTR 1.30 10.00 0.50 84.4 5-1 LTR 3.90 31.50 1.50 85.1 5-1 LTR 6.12 31.50 1.50 76.7 5-1 LTR 4.64 27.30 1.30 79.6 NRB 330 4.20 19.20 1.60 73.8 NRB 750 8.40 43.20 3.60 76.7 200 7.29 34.80 2.90 74.9

0:4 0:3 1:0 5:5 5:7 4:2 3:0 3:1 4:0

0:3 0:3 0:6 2:5 4:6 3:4

0:1

5.25 87

DIET COCA COLA

300+

LEMONADE BRITVIC J2O APPLETISE

0:6 3:6 3:0 3:1

47.22 29 117.60 88 108.00 23 74.00 42 52.00 38 -10.00 300+ 40.60 70 455.30 29 -49.30 300+ 129.20 50 -24.70 300+ 9.10 300+ 20.80 189 43.40 157 355.83 24 598.50 31 787.50 12 409.50 27

14:1

10:7

BRITVIC FRUIT JUICE BRITVIC CRANBERRY BRITVIC PINEAPPLE

2:0

0:10 20.00 116

2:0

2:10

2:2

BRITVIC TOMATO

3:6

-0:5

FEVERTREE GINGERBER 200 8.77 34.80 2.90 69.8

2:10

1:2

FEVER TREE MIXERS

14:0

12:0

12:11 13:1

FEVERTREE LEMON TON 200 7.46 34.80 2.90 74.3

1:7

3:0

-1:5

BRITVIC LOW CAL BRITVIC GINGER ALE

11:6

4:0

9:10

5:8

3:6 4:0

4:7 2:1 9:3 8:8 6:4

-1:1

FRUIT SHOOTS

1:11 55.20 32

PEPSI COLA PEPSI DIET

9:10

0:7 1:4 1:2

10:0

RED BULL CANS

5:6

2:0

CORDIAL

35:0 25:0 21:0 22:0

30:0 14:0 14:0

29:5 20:0 10:0 14:0

35:7 19:0 25:0 15:0

PST LEMONADE

PST PEPSI

PST PEPSI DIET MINERAL WATER MINERAL WATER

7:0

7:11

4:1 2:7

3:10 73.60 31

3:8

1:1

46.80 69

215:5

87:0

167:9 134:8

SALES AT SELLING 3365.40 CLOSING AT COST 844.72 SALES AT COST 607.66

CRISPS,NUTS & SNACKS

CRISPS REAL

DOZ 3.24* 12.00 1.00 67.6

10:9 10:9

16:0 16:0

9:7 9:7

17:2

206.00 16

17:2 SALES AT SELLING 206.00 CLOSING AT COST 31.07 SALES AT COST 55.65

Ref:073

* New Cost or Selling Price

LOSS Non-profit item GP% excludes 20.0% VAT

Page 3