Hotel Directors Meeting March 2020

Hotel Directors Meeting Papers March 2020

Hotel Directors Meeting

13 th March 2020

QUORN GRANGE HOTEL LEICESTERSHIRE

HOTEL DIRECTORS MEETING 13 th March 2020

Quorn Grange Hotel

.

Commence: 11:00

AGENDA:

Declaration of interest

Declaration of AOB

Minutes of previous meeting

Matters arising

Financial update-management accounts and financial reporting

Operational update

Staff pay structure

Risk management

Any Other Business

Conclude: 15:00

Update from Quorn Grange Hotel covering February 2020.

Hotel Leadership team The team met on the 10 th February and all team meeting dates confirmed (Minutes circulated by IR).

Site

Confirmation that all site recharges covering the following have been set up

(See attached document for full breakdown)

 Site Maintenance  ET rent  Finance and marketing, H/R support. ( includes Georgia marketing support)  Confirmation of daily rate for GFTU Classrooms

Hotel Trading

Trading for February is below budget with one of the main contributing factors the loss of the weekend booking of all the bedrooms and function areas weekend of the 21 st and 22nd of February. The booking was cancelled 2 weeks prior to the event and offers were immediately marketed throughout the movement and the general public and rates were flexed accordingly to mitigate the loss. The mix of business throughout the month continues to build covering all Market segments, Corporate accounts, affiliated unions, non-affiliated unions, weddings, local Food and beverage and Sunday Lunches, and Valentine evening both dinner and rooms. Total sales for the month were £141 k this figure is down against budget by £27 K. The average room rate came in behind budget at £63.00 compared to the budget of £67.00 per night. The average room rate is down as a direct result of flexing the rate and the special offer over the weekend of the cancellation. Occupancy for the month was 65% again down by 9% on budget. Attached Business mix of accommodation from Rezlynx.

The estimated loss of the weekend is at £23 K which would have meant the Hotel would have only missed budget by £4.K. Throughout the month expenses were well controlled and we are currently awaiting the confirmed profit and loss accounts for the month.

Health and safety Hotel

The accident book was signed of and no reportable accidents were reported at the Site health and Safety meeting. (H/S minutes to be distributed) Corona virus information updated on web site and notices on reception including advice to team members showing concerns. Further actions agenda item for next H/S site meeting. Letter issued for all team members regarding the Fire doors not being closed and the letter very clear that this is a serious disciplinary offence, letter individually signed and retained on personnel file. First aid Course undertaken by personnel to ensure correct number of first aiders on site during shifts.

Next 2 courses to be held in March

 Manual handling  Fire Marshall training

Staff Movements David Wall (Chef de Partie) leaves on the 3 rd March David has accepted Head Chef Position in the village. Suzanne Bielewilz transferring to position within the GFTU from Housekeeping Assistant (March 9 Th )

Completed Actions

 CSP Document Showing revenues  Pay scale document  Confirmation of Granite from Tarmac  Room 26 proposals

 Wedding costing sheet finalization  Preferred suppliers list for wedding accessories  Weekly forecasting Food and beverage part time team members  Cash Flow monitoring

Areas ongoing

 Hotel Union membership team meetings have taken place between Sarah Woolly (BFAWU) setting up a branch within the Hotel. The signs were very positive and a further meeting to be conducted with Sarah Woolly TM and IR  Conference costing sheet similar format to wedding analysis  Ongoing work with LPL following the introductory session 10 th February  Costing sheets for all HODs to monitor all expenses to ensure budgets are not exceeded Wendy Ledger assisting in place during March  Supervisions and PDP for all HODs to ensure retention and opportunities completion 1 st April  Individual employee meetings to be undertaken 16 th March. Timetable to follow.  The management of the site through the SMT to deliver the Budget

Tim Marshall 04.03.2020

(Actual) 01/Feb/2020 - 01/Mar/2020

Quorn Grange Hotel

Company Report

Sleepers

Rate Plan Rev

Avg Lead Time Avg Stay Length ARR APR ADR Lost

Company Ref

Arrivals Rm Nights

Accom Rev

F&B Rev

Other Rev Total Rev

Nights Lost Rev Last Arrival Last Booked Potential Rm Nights

Ad Ch

Quorn Grange Hotel BOOK0001

224 274 424 0 17158.23 181 279 279 0 23983.50

5390.20

-209.20 22339.23

19395.92 29429.50 3641.11 3180.00 11258.00 2968.60 1215.00 455.00 616.00 325.00 0.00

7.65

1.22 62.62 70.79 81.53

37

3250.87 31/Dec/2020 04/Mar/2020

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

CORP_RATES

11390.80 912.90 870.30 5053.60 1113.45 577.50 196.60 112.40 139.60

3209.75 38584.05

54.24

1.54 85.96 105.48 138.29 164 21256.00 08/Dec/2020 04/Mar/2020

EXPE0001 WEDDING

56 47

58 90 5 49 95 6

3305.26 2607.00 7867.00 2711.20 810.00 399.00 560.00 285.00 0.00

-161.15

4057.01 3477.30

6.64

1.04 56.99 62.78 69.95 1.04 53.20 64.90 70.97 2.36 74.22 106.21 127.67 1.96 0.00 0.00 2.54 1.83 64.55 70.68 83.88 1.00 90.00 135.00 160.17 1.00 49.88 56.88 119.45 1.00 80.00 88.00 96.06 1.00 57.00 65.00 65.00 2.20 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

4

271.91 29/Oct/2020 04/Mar/2020

0.00

143.00

38

3550.00 05/Dec/2021 03/Mar/2020 880.00 16/Nov/2020 20/Feb/2020 402.00 10/Nov/2020 04/Sep/2019 485.00 24/Nov/2020 05/Feb/2020 65.00 25/Sep/2020 18/Feb/2020 88.00 06/May/2020 02/Mar/2020 455.00 02/Sep/2020 13/Feb/2020 556.00 26/Feb/2020 08/Jan/2020 0.00 18/Dec/2020 03/Mar/2020

COMMUNITY

45 106 107 0

612.00 13532.60

83.87

8 3 0 4 1 1 7 4 0 0 0

CHART

28 23

55 55 0 42 55 0 9 9 0 8 8 0 7 7 0 5 5 0 11 11 0 0 0 0 0 0 0 0 0 0

0.00

139.60

279.89

ONLI0001

-301.60

3523.05 1441.50 955.60 672.40 325.00

15.83 67.00

NAUTILUS

9 8 7 5 5 0 0 0

54.00

GFTU

360.00

8.00

BRETT

0.00 0.00 0.00 0.00

15.86 13.00 48.00

BAKERS

40.00

GFTU_LEARNIN

0.00 0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00 0.00

DONALDSON LONGHURST

0.00 0.00 0.00

0.00 10/Feb/2020 31/Jan/2020

211.30

50.00

261.30

125.00 17/Feb/2020 06/Feb/2020

UNITEDER

2444.00

1014.00

156.00

3614.00

3614.00

0.00 13/Nov/2020 31/Oct/2019

Grand Total

638 903 1145 11 62130.19

27022.65

3769.80 92922.64

76098.13

49.53

1.41 68.80 84.27 102.90 271 31384.78

0

Page 1 of 1 at 09:20 on the 04/Mar/2020

TMARSHALL

QUORN GRANGE HOTEL QUORN 06/01/20 to 04/02/20 29 days

STOCK AUDIT by

S30 QUORN GRANGE HOTEL QUORN

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

CATEGORY

Days Stock

Sales Ratio

Gross Profit%

Consumption at Cost

Estimated Receipts

Purchase Barrelage

Stock on Hand at Cost

Purchases at Cost

Credits at Cost

SPIRITS

64 15.0 78.3 66 0.6 74.0 45 25.3 68.9 14 36.1 65.5 48 1.9 54.3 28 4.2 65.2 40 16.0 78.3 16 1.0 67.6

571.04

3154.90 * 125.70 * 5322.26 * 7602.32 * 405.40 * 889.10 * 3365.40 * 206.00 *

1263.91

159.28

FORTIFIED WINE

27.24

62.06

40.32 15.74

TABLE WINE

1379.20 2186.79 154.52 257.49 607.66

2118.20 1399.37 183.21

DRAUGHT BEER PACKAGED BEER CIDERS & PERRIES

4.19 1081.88 1531.28 12.03

256.48 248.90 844.72

0.66

216.34 355.05

MINERALS

CRISPS,NUTS & SNACKS

55.65 -80.00

31.07

51.87

SUNDRIES

0

80.00

33 100% 70.6

5159.60

21071.08 *

4.85 5907.22 3753.51 290.98

ADJUSTMENTS CORKAGE

ANALYSIS OF PURCHASES & CREDITS

0.00 *

MARSTONS

3701.64 80.00 51.87 210.98

KITCHEN

21071.08 *

ALLOWANCES PIPE CLEANING

14.6% OF TAKINGS

3753.51 290.98

233.00 * 479.60 * 264.30 * 221.40 * 824.70 * 622.40 *

NOTES AUDITOR - MEN CURRENCY - £ VAT @ 20.0% * INCLUDING VAT

ULLAGE

DISCOUNTED SALES CUMBERLAND OOD

£2 PINT

CHEAP DRINKS

GP% EXCLUDES VAT RATIO% AT SELLING

2645.40 *

18425.68 *

ESTIMATED RECEIPTS

EXCL. VAT

15354.73

CONSUMPTION AT COST

EXCL. VAT

5159.60

66.4% PROFIT

ESTIMATED GROSS PROFIT EXCL. VAT

10195.13

ACTUAL RECEIPTS

EXCL. VAT

15117.73

CONSUMPTION AT COST

EXCL. VAT

5159.60

YIELD 86.1% YTD YIELD 86.1%

65.9% PROFIT

ACTUAL GROSS PROFIT

EXCL. VAT

9958.13

YEAR TO DATE FROM 06/01/20

ACTUAL RECEIPTS

INCL. VAT

18141.27

TAKINGS Incl VAT 18141.27 TAKINGS Excl VAT 15117.73

ESTIMATED RECEIPTS

INCL. VAT

18425.68

GROSS PROFIT 9958.13 65.9% RESULT SHORTAGE 284.41 1.6%

1.6% OF SALES

RESULT SHORTAGE

INCL. VAT

284.41

ALL FIGURES ARE BASED UPON INFORMATION PRESENTED WHICH SHOULD BE VERIFIED BEFORE ACCEPTING THIS RESULT AS CORRECT

CERTIFICATE OF VALUATION

Stock Date :

4th February 2020

Our Ref :

S30/073

In the matter of :

QUORN GRANGE HOTEL, QUORN

According to instructions received we, the undersigned, having made a valuation of the stock-in-trade in and upon the above premises are of the opinion that the value of said stock as at close of business Friday 31st January 2020 was :

SPIRITS

1301.19

FORTIFIED WINE

63.84

TABLE WINE

2208.24 1224.65 266.57 265.71

DRAUGHT BEER PACKAGED BEER CIDERS & PERRIES

MINERALS 884.39 CRISPS,NUTS & SNACKS 34.70

TOTAL STOCK VALUE

6249.29

(At cost value and excluding VAT)

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

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

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

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

SUNDRIES

C02 DEPOSITS

EAC 10.00

LOSS

8.0 8.0

-8.0

-8.0 SALES AT SELLING 0.00 CLOSING AT COST 0.00 SALES AT COST -80.00

FINAL TOTALS

SALES AT SELLING 21071.08 CLOSING AT COST 5907.21 SALES AT COST 5159.60

LC 127

Ref:073

* New Cost or Selling Price

LOSS Non-profit item GP% excludes 20.0% VAT

Page 4

S30 QUORN GRANGE HOTEL QUORN

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

DELIVERY SUMMARY

Supplier Name

Delivery Date

Delivery Ref

Purchases at Cost

Credits at Cost

Total at Cost

KITCHEN

09/01/20 16/01/20 23/01/20 23/01/20 30/01/20 31/01/20

4327 4156 4264 6595 4471

48.66 31.66 57.61

-48.66 -31.66 -57.61 51.87 -49.74 -23.31

51.87

49.74 23.31

NONE

51.87

210.98

-159.11

MARSTONS

09/01/20 16/01/20 23/01/20 30/01/20

4327 4156 4264 4471

541.10 382.27 1561.93 1216.34

541.10 382.27 1481.93 1216.34

80.00

3701.64

80.00

3621.64

TOTALS

3753.51

290.98

3462.53

Page 1

LAST PAGE

Quorn Grange Quorn 06/01/20 to 04/02/20 29 days

STOCK AUDIT by

F30 Quorn Grange Quorn

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

FOOD TRADING ACCOUNT

Analysis of PURCHASES

OPENING STOCK 06/01/20 4185.87

Veg Factor Woodwards

4624.51 4036.82 2823.20 1134.56 585.36 465.02 240.00 210.98 201.10 183.57

PURCHASES 14575.92

Andrew Tebbutt Direct Seafoods Delice de France

18761.79

Bebida

CREDITS 203.01

A C Birkle

BAR

Olleco

18558.78

Price & Fretwell Ltd Continental Coffee

70.80

CLOSING STOCK 04/02/20 4535.58

14575.92

CONSUMPTION AT COST 14023.20

Analysis of CREDITS

TAKINGS (incl VAT)

48743.22

Woodwards

65.43 51.88 51.70 34.00

BAR

less VAT @ 20.0% 8123.87

Direct Seafoods Price & Fretwell Ltd

40619.35

203.01

CONSUMPTION AT COST 14023.20

Analysis of ALLOWANCES

65.48% GROSS PROFIT 26596.15 (before allowances)

Discount

137.02 @ retail 580.00 @ cost

Staff Feed £20day

67.00% GROSS PROFIT (after allowances)

STOCKHOLDING

9 days

YEAR to DATE FROM 06/01/20

TAKINGS Incl VAT 48743.22 TAKINGS Excl VAT 40619.35

GROSS PROFIT

26596.15 65.5%

ALL FIGURES ARE BASED UPON INFORMATION PRESENTED WHICH SHOULD BE VERIFIED BEFORE ACCEPTING THIS RESULT AS CORRECT

CERTIFICATE OF VALUATION

Stock Date :

4th February 2020

Our Ref :

F30/073

In the matter of :

Quorn Grange, Quorn

According to instructions received we, the undersigned, having made a valuation of the stock-in-trade in and upon the above premises are of the opinion that the value of said stock as at close of business Friday 31st January 2020 was :

MEAT FISH

552.58 374.92 499.32 727.22 213.90 309.93 380.71 995.44 74.89 281.65 125.02 -822.87 1227.31

DAIRY PRODUCTS

BAKERY

FRESH VEGETABLES FROZEN VEGETABLES

BEVEREGES DRY GOODS

TINNED GOODS

SAUCES SUNDRIES

PURCH ADJUSTMENT SALES ADJUSTMENT

TOTAL STOCK VALUE

4940.02

(At cost value and excluding VAT)

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

MEAT BACON

2.2 11.000 3.0 KGS 7.980 1.0 1KG 6.040 8.0 EAC 2.250 10.0 KGS 14.980 3.0 1.3 3.980 1.0 X48 21.820 1.0 KGS 0.750 5.0 5KG 21.490 1.4 KGS 3.970 2.0 EAC 1.980 6.0 KGS 8.990 2.0 1KG 6.970 4.0 EAC 3.860 1.0 EAC 3.458 3.0 KGS 22.000 1.0 EAC 20.000 6.0 KGS 7.980 2.0 EAC 1.980 4.0 KGS 5.450 3.0 KGS 5.480 2.0 STK 27.200 0.5 EAC 26.210 0.5 1KG 6.980 0.4 PKT 10.800 2.0 KGS 1.200 10.0 TIN 9.790 1.0 EAC 1.650 10.0 JAR 10.820 1.0 EAC 1.300 8.0 KGS 8.190 1.0 KGS 1.500 5.0 EAC 2.680 20.0 1KG 11.950 2.0 X20 40.100 0.5 3KG 20.910 1.0 X16 27.770 1.0 KGS 10.500 5.0 EAC 2.750 4.0 EAC 0.990 26.0 1.6 17.500 1.0 1KG 11.250 2.0 1KG 16.250 1.0 KGS 20.000 1.0

33.00 7.98 48.32 22.50 44.94

BEEF FEATHERBLADE

BEEF MINCE

BEEF STEAK RUMP

BEEF STRIPLOIN ROASTING

BLACKPUDDING

3.98

CHCKEN BACON MINI PIES

21.82

CHICKEN BONES CHICKEN FILLETS CHICKEN LIVERS CHICKEN SUPREMES

3.75

30.09

7.94

11.88 17.98 27.88

GAME MIX

GAMMON JOINT

HAGGIS

3.86

HAM HOCK HAM PARMA

10.37 22.00 120.00 15.96

LAMB LEG STEAK LAMB SHOULDER

PHEASANTS PORK BELLY PORK LOIN

7.92

16.35 10.96 13.60 13.11 2.79 21.60 12.00

SALAMI

SAUSAGE CHORIZO SAUSAGE MEAT

SAUSAGES VEAL BONES

552.58

FISH ANCHOVIES

9.79

BREAM

16.50 10.82 10.40

CAVIAR SALMON COD CHEEKS

COLEY

8.19 7.50

FISH BONES

HADDOCK FILLETS HADDOCK SMK FILLETS

53.60 23.90 20.05 20.91 27.77 52.50 11.00 25.74 17.50 22.50 16.25 20.00

HAKE

KIPPERS MACKERAL MONK FISH

PLAICE FILLETS POLLACK FILLETS PRAWNS ATLANTIC PRAWNS TIGER SALMON FILLETS SALMON SMOKED

374.92

Ref:073 LC 044

Page 1

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

DAIRY PRODUCTS BUTTER BUTTER PROTIONS CHEESE APPLEWOOD

250 1.360 28.0 120 4.990 2.0 1.5 16.500 0.8 KGS 6.100 0.9 1KG 4.550 5.0 KGS 17.240 0.3 KGS 9.950 1.5 1KG 7.600 0.8 2KG 6.850 2.0 1KG 12.350 1.6 250 2.650 3.0 EAC 1.490 5.0 KGS 16.950 0.4 KGS 16.880 1.2 KGS 11.850 1.7 1KG 8.890 1.8 KGS 8.250 1.0 2.2 9.000 1.0 2KG 6.950 1.0 DOZ 1.000 13.0 LTR 0.780 31.0 KGS 2.740 4.0 500 3.150 8.0 2.5 8.000 18.0 LTR 1.450 4.0 PER 8.600 2.0 100 4.870 0.1 125 0.420 5.0 5KG 8.950 0.5 X48 15.070 0.5 X6 11.490 0.8 X14 23.480 1.0 X14 21.840 0.5 X6 11.130 1.1 X12 35.690 0.3 X45 10.500 1.0 X30 13.830 0.5 108 13.300 0.5 X8 8.380 3.7 X8 8.610 2.5 X30 7.420 1.5 X20 19.120 0.5 X36 8.020 2.0 X6 16.640 1.5 X36 22.870 3.0 X64 12.650 1.3 120 29.880 1.0 IND 1.250 50.0 X72 11.650 1.0 X30 20.550 2.0 X4 1.030 12.0 X60 37.590 0.5

38.08 9.98 13.20

CHEESE BRIE

5.49

CHEESE CHEDDER

22.75

CHEESE CHESHIRE APPLEBY

5.17

CHEESE EMENTAL

14.93

CHEESE FETA

6.08

CHEESE FULL FAT CHEESE GOATS LOG CHEESE HALLOUMI CHEESE MORTZERELLA CHEESE PARMERSAN CHEESE POACHER CHEESE RUTLAND RED

13.70 19.76

7.95 7.45 6.78

20.26 20.15 16.00

CHEESE STILTON CREAM CLOTTED CREAM DOUBLE CREME FRAICHE

8.25 9.00 6.95

EGGS

13.00 24.18 10.96 25.20

FRUIT JUICE GNOCCHI GUCAMOLE

ICE CREAM ASSORTED FLAVOURS

144.00

MIL SOYA

5.80

MILK

17.20

SUNFLOWER SPREAD

0.49 2.10 4.48

YOUGHURT

YOUGURT GREEK

499.32

BAKERY BREAD BAGELS

7.54 9.19

BREAD BLOOMER MALT BREAD BLOOMER ORGANIC

23.48 10.92 12.24 10.71 10.50 31.01 21.53 11.13 9.56 16.04 24.96 68.61 16.45 29.88 62.50 11.65 41.10 12.36 18.80 6.92 6.65

BREAD BLOOMER ORGANIC BROWN

BREAD BLOOMER WHITE

BREAD BRIOCH

BREAD BRIOCHE ROLLS

BREAD CIABATTA

BREAD HOT DOG ROLLS

BREAD LOAVES

BREAD LOAVES WHOLEMEAL

BREAD NAAN

BREAD ROLLS G/F

BREAD SCOTTISH MORNING ROLLS

BREAD SLICED G/F CHRISTMAS PUDDINGS

CROISSANTS

DANISH PASTRIES MINI ASSORTED

DESERTS MINCE PIES

MUFFINS

MUFFINS ENGLISH MUFFINS G/F MINI

Ref:073 LC 096

Page 2

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

BAKERY Contd. PANCAKE PASTRY FILO PIZZA SLABS QUICHE SLABS

120 27.990 1.0 X8 25.940 0.5 X4 12.740 1.0 X4 23.770 1.5 X27 63.280 1.0 BOX 29.880 1.0 BOX 39.260 1.0 X4 11.810 1.2 X4 10.640 0.1 X4 11.740 0.5 BOX 10.640 1.0 EAC 0.200 7.0 EAC 1.510 1.0 PKT 0.830 2.0 KGS 0.940 1.0 EAC 1.440 1.0 EAC 0.920 1.0 10K 6.750 0.5 EAC 2.710 1.5 EAC 0.990 1.5 1KG 6.200 0.2 EAC 0.260 2.0 EAC 0.470 0.5 EAC 1.180 3.0 STR 4.750 0.5 EAC 0.690 3.0 BUN 5.010 0.3 50G 0.920 12.0 PUN 0.800 16.0 EAC 0.280 1.0 KGS 1.800 2.0 EAC 2.800 1.0 EAC 0.290 16.0 X2 1.140 2.5 EAC 2.130 1.0 EAC 1.420 1.0 EAC 1.350 1.0 EAC 2.690 1.0 1KG 4.500 2.0 EAC 0.210 8.0 EAC 2.270 2.0 EAC 3.690 1.8 TRY 5.950 2.0 500 5.540 1.0 KGS 1.150 1.0 KGS 1.820 1.0 KGS 0.480 15.0 BOX 20.250 1.0 EAC 0.410 2.0 EAC 0.450 7.0 EAC 0.430 7.0 EAC 4.060 2.5

27.99 12.97 12.74 35.66 63.28 29.88 39.26 14.17

TARTLET CASES RECTANGULAR TARTLET CASES SAVOURY

TARTLET CASES SWEET

TORTILLA TOMATOE WRAPS X18

TORTILLA WRAPS X18

1.06 5.87

TORTLLA SPINACH WRAPS X18

VOL E VENTS

10.64

727.22

FRESH VEGETABLES APPLES

1.40 1.51 1.66 0.94 1.44 0.92 3.38 4.07 1.49 1.24 0.52 0.24 3.54 2.38 2.07 1.50 0.28 3.60 2.80 4.64 2.85 2.13 1.42 1.35 2.69 9.00 1.68 4.54 6.64 5.54 1.15 1.82 7.20 0.82 3.15 3.01

AVACADO PEAR

BABY CORN

BEETROOT FRESH

CABBAGE

CABBAGE SAVOY

CARROTS CELERIAC CELERY CHILLIES

CLEMENTINES CUCUMBER

FENNEL GARLIC

GRAPEFRUIT PINK

GRAPES

HERBS VARIOUS JAM STRAWBERRY

11.04 12.80

KIWI FRUIT

LEEKS

LEMON BALM

LEMONS

LETTUCE BABY GEM LETTUCE CURLY ENDIVE LETTUCE LOLLO ROSSO LETTUCE OAK LEAF LETTUCE RADICHIO

LETTUCE ROCKET

LIMES MELON

MELON WATER MUSHROOMS

11.90

MUSHROOMS WILD

ONIONS RED

ONIONS SHALLOTS ONIONS WHITE ORANGE LEAFY

20.25

ORANGES

PASSION FRUIT

PEARS

PINEAPPLE

10.15

Ref:073 LC 148

Page 3

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

FRESH VEGETABLES Contd. PLUMS

EAC 0.360 8.0 25K 9.000 1.0 BAG 1.210 2.0 PUN 2.130 2.0 EAC 0.380 2.0 6KG 10.850 1.0 3KG 16.000 0.5 PUN 2.500 6.0

2.88 9.00 2.42 4.26 0.76

POTATOES SPINACH

STRAWBERRIES

SWEDE

TOMATOES

10.85

TOMATOS CHERRY VINE WATERCRESS MICRO

8.00

15.00

213.90

FROZEN VEGETABLES BLACKBERRIES

BAG 6.350 1.0 2.5 3.220 5.0 2.5 2.700 3.0 2.5 7.570 3.0 BAG 7.490 0.5 BAG 8.250 1.0 KGS 6.670 1.0 X50 20.840 2.0 BAG 4.350 1.0 2.5 4.350 0.5 BAG 7.650 2.0 X80 14.240 5.0 X20 29.990 1.0 2KG 2.690 2.5 X20 18.670 0.5 BOX 10.790 2.3 X90 10.810 3.0 2KG 9.490 0.4 1KG 11.800 5.5 2LT 50.000 4.0 100 20.950 0.3 500 15.220 0.8 750 17.990 1.0 5LT 2.430 2.0 2LT 16.250 2.0 X24 9.480 1.0 X12 6.990 1.0 BAG 15.990 0.8 X25 1.490 6.0

6.35

CHIPS CHUNKY

16.10

CHIPS FRENCH FRIES

8.10

CHIPS SWEET CRANBERRIES

22.71 3.75 8.25 6.67 4.35 2.18 41.68 15.30 71.20 29.99

FRUIT OF FOREST MOZZARELLA STICKS

ONION BAJAHIS

ONIONS SILVER SKIN

PEAS

RASPBERRIES VEG SAMOSA

VEGAN BURGER MOVING MOUNTAIN

VEGAN NUGGETS

6.73 9.34

VEGGIE BURGER BANKOK BAD BOY

VEGGIE SAUSAGE

24.82 32.43

VEGGIE SPRING ROLLS

309.93

BEVEREGES CHOCOLATE DRINKING

3.80

COFFEE COFFEE

64.90 200.00

COFFEE DECAF COFFEE DECAF COFFEE INSTANT

6.29

12.18 17.99

CORDIAL

4.86

MILK

32.50

ORANGE JUICE

9.48 6.99

RIBENA

TEA BAGS

12.79 8.94

TEA VARIOUS FLAVOURS

380.71

DRY GOODS AGA AGA

TUB 22.500 0.5 1KG 11.350 1.5 KGS 14.240 0.2 3KG 17.630 0.5 TUB 4.940 0.3

11.25 17.03

ALMONDS GROUND ALMONFS FLAKED

2.85 8.82 1.48

APRICOTS

ARROWROOT

Ref:073 LC 190

Page 4

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

DRY GOODS Contd. BAKING POWDER BAKING POWDER G/F

TUB 6.370 0.3 BAG 5.950 0.5 KGS 5.770 0.2 TUB 2.690 1.0 X12 10.870 0.4 KGS 10.990 4.5 KGS 8.540 1.0 500 1.740 7.5 500 1.220 11.0 2KG 2.260 3.5 X15 39.840 0.4 3KG 7.640 0.5 2.5 18.700 1.0 2.5 25.570 0.5 KGS 8.320 0.3 BAG 12.600 0.5 3.5 6.290 0.5 KGS 2.500 1.0 BAG 7.490 0.1 3.5 5.020 0.5 3KG 10.490 0.2 1KG 13.490 1.0 300 1.510 1.0 2KG 3.000 0.1 BAG 9.990 0.9 KGS 2.990 0.5 BAG 10.270 0.9 BAG 17.990 1.0 BAG 18.590 0.8 KGS 28.870 0.5 KGS 2.400 1.5 7.5 9.950 0.1 TUB 5.770 0.3 EAC 8.390 20.4 3.1 21.370 0.5 2KG 19.790 0.6 3.1 10.420 1.5 2KG 11.390 3.1 2.2 10.720 0.5 KGS 9.250 1.0 BOT 1.010 7.0 3KG 6.140 0.5 X24 4.180 7.0 2KG 3.510 3.0 BAG 9.250 0.3 KGS 13.950 0.2 BAG 11.240 0.5 KGS 49.270 0.3 1KG 31.570 0.5 20L 20.200 2.0 5KG 7.120 1.6 500 2.340 3.5 3KG 10.340 0.2 500 2.290 2.0 5KG 6.670 0.8 5KG 6.890 0.5 3KG 7.640 0.5

1.91 2.98 1.15 2.69 4.35

BANNANA CHIPS BI CARBONATE

BISCUITS DIGESTIVE

BOULLION

49.46

BOULLION BRAKES CEREAL ALL BRAN CEREAL CORNFLAKES

8.54

13.05 13.42

CEREAL OATS CHEESE TWISTS

7.91

15.94

CHICK PEAS

3.82

CHOCOLATE DROPS

18.70 12.79 2.50 6.30 3.15 2.50 0.75 2.51 2.10 1.51 0.30 8.99 1.50 9.24 13.49 17.99 14.87 14.44

CHOCOLATE DROPS WHITE

COCO POWDER COCONUT CORNFLOUR COUS COUS CRANBERRIES DEMI GLAZE EGG NOODLES FLOUR MUSTARD FLOUR PLAIN FLOUR S/F G/F CUSTARD POWDER DATES FLOUR SELF RAISING

FLOUR STRONG

FLOUR WHOLEMEAL

GELATINE GLUCOSE

3.60 1.00 1.73

GOLDEN SYRUP H/S STAR ANIS HERBS & SPICES

171.16 10.69 11.87 15.63 35.31

HONEY

HONEY MINI

JAM STRAWBERRY JAMS ASSORTED MINI JELLY CRYSTALS JUNIPER BERRIES

5.36 9.25 7.07 3.07

LEMON JUICE LENTILS RED

MARMITE MUESLI

29.26 10.53

MUSTARD SEEDS BLACK

2.78 2.79 5.62

NUTS CASHEWS

NUTS HAZEL NUTS PINE

14.78 15.79 40.40 11.39

NUTS PISTACHIO PEELED

OIL VEGETABLE

PASTA FUSSL TRICOLOUR PASTA GLUTEN FREE

8.19 2.07 4.58 5.34 3.45 3.82

PASTA LASAGNE

PASTA PAPPERDELLE PASTA PENNE PASTA SPAGETTI PASTA TAGLETELLI

Ref:073 LC 247

Page 5

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

DRY GOODS Contd. PEPPER BLACK PEPPERCORNS PEPPER GROUND WHITE

KGS 10.490 0.5 TUB 10.490 0.5 TUB 6.500 1.0 TUB 10.490 0.3 TUB 63.860 0.3 3KG 3.740 0.6 BOX 14.540 3.5 750 15.140 1.0 EAC 5.320 0.5 3KG 15.070 0.3 KGS 9.220 1.0 KGS 14.170 0.1 5KG 16.720 0.8 1G 3.700 1.0 BAG 3.740 0.3 BAG 9.250 0.1 3KS 4.940 0.6 25K 26.690 0.5 1KG 4.630 3.0 3KG 7.190 1.0 3KG 8.620 0.3 3KG 5.990 0.2 3KG 14.840 0.2 X10 13.940 0.9 200 5.090 0.5 231 62.810 0.7 BOT 4.500 0.5 BAG 14.990 0.5 500 2.490 0.5 800 3.450 1.0 A10 4.870 1.0 3.1 2.190 1.0 400 1.200 2.0 425 1.180 8.0 397 1.640 4.0 800 1.490 3.0 A10 4.600 1.0 800 1.870 5.5 1.7 10.910 2.0 TIN 1.600 3.0

5.25 5.25 6.50 3.15

PEPPERCORNS GREEN PEPPERCORNS PINK

PISTACHIO PASTE

19.16

POLENTA

2.24

POPPADUMS

50.89 15.14 2.66 4.52 9.22 1.42 3.70 1.12 0.93 2.96 7.19 2.59 1.20 2.97 13.38 13.35 13.89 12.55 2.55 43.97

POPPADUMS MINI POPPY SEEDS

PRUNES QUINOA

QUINOA RED RICE BASMATI

SAFFERON

SEESEME SEEDS

SESEME SEEDS BLACK

STUFFING

SUGAR CASTER SUGAR CUBES SUGAR DEM SUGAR ICING SULTANAS TACO SHELLS TANDORI RUB SUGAR DARK BROWN TRUFFLES ASSORTED VANILLA ESSENCE

2.25 7.50 1.25

WALNUTS

YEAST

995.44

TINNED GOODS 5 BEAN SALAD

3.45 4.87 2.19 2.40 9.44 6.56 4.47 4.60

APPLES

BAKED BEANS BAMBOO SHOOTS COCONUT MILK CONDENSED MILK KIDNEY BEANS RED

PEAR HALVES TOMATO PASTE

10.29 21.82

TUNA

WATER CHESTNUTS

4.80

74.89

SAUCES APPLE SAUCE BBQ SAUCE BROWN SAUCE CHILLI SAUCE

2.2 7.420 0.5 2.2 6.370 0.5 4.3 8.090 2.1 LTR 2.840 2.0 2.5 11.990 1.1 2.5 6.990 3.0 KGS 7.600 1.0

3.71 3.19

16.99

5.68

CHUTNEY TOMATOE CRANBERRY SAUCE

13.19 20.97

FRUIT PUREE

7.60

Ref:073 LC 294

Page 6

F30 Quorn Grange Quorn

STOCK ON HAND

STOCK AUDIT by

as at 4th February 2020

Description

Size

Cost Price

Closing Stock

Valuation at Cost

SAUCES Contd. GHERKINS HOI SIN SAUCE HOLLANDAISE

2.2 7.420 0.5 5LT 16.000 1.0 LTR 4.040 3.5 2.2 6.670 1.0 2.2 7.720 6.0 2LT 10.380 2.0 3KG 10.870 1.0 2.8 5.690 1.0 10L 13.500 0.9 2.2 11.050 1.0 2.2 9.520 0.3 2.3 5.620 0.4 2.3 5.620 0.3 2.2 6.740 0.4 LTR 1.930 5.0 1.1 4.870 0.5 3KG 9.740 1.0 2LT 6.370 0.3 BOT 11.250 1.0 4.3 6.590 0.2 BOT 2.690 0.2 5LT 3.520 0.3 5LT 6.740 2.0 BOT 1.000 0.5 5LT 8.020 0.2

3.71

16.00 14.14 46.32 20.76 10.87 12.15 11.05 6.67 5.69 2.86 2.25 1.69 2.70 9.65 2.44 9.74 1.91 1.32 0.54 1.06 0.50 1.60 11.25 13.48

HORSERADDISH SAUCE

JALFREZI SAUCE

LEA PERINS

MANGO CHUTNEY MAPLE SYRUP

MAYONNAISE MINT SAUCE

MUSTARD DIJON MUSTARD ENGLISH MUSTARD FRENCH

MUSTARD WHOLEGRAIN

PASSATA

PIR PIR

REDCURRANT JELLY

SOY SAUCE TOBASCO

TOMATO SAUCE VINEGAR CIDER VINEGAR MALT

VINEGAR RED WINE VINEGAR SHERRY VINEGAR WHITE WINE

281.65

SUNDRIES BRANDY DARK RUM

70 11.060 0.8 75 7.060 1.0 70 21.150 0.1 75 10.250 0.3 75 6.750 0.8 75 7.570 1.5 75 4.140 13.5 75 5.640 2.0 VAL 1.000 20.0

8.85 7.06 2.12 3.08 5.40

GRAND MARNIER

MADERIA

NOLLY PRATT

PORT WINE

11.36 55.89 11.28 20.00

WINE BAR

WORKING STOCK

125.02

TOTAL STOCK ON HAND AT COST 4535.58

Ref:073 LC 328

Page 7

F30 Quorn Grange Quorn

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

DELIVERY SUMMARY

Supplier Name

Delivery Date

Delivery Ref

Purchases at Cost

Credits at Cost

Total at Cost

Andrew Tebbutt

06/01/20 07/01/20 08/01/20 09/01/20 10/01/20 11/01/20 14/01/20 16/01/20 17/01/20 18/01/20 20/01/20 22/01/20 23/01/20 24/01/20 25/01/20 27/01/20 28/01/20 29/01/20 30/01/20 31/01/20 01/02/20

5689 5690 5691 5692 5693 5694 5695 5696 5697 5698 5699 5700 5301 5303 5304 5305 5306 5307 5308 5309 5310

123.52

123.52

85.56 23.18

85.56 23.18

243.15 106.68 167.24 220.59

243.15 106.68 167.24 220.59

94.70 45.25

94.70 45.25

282.26 125.83 106.30

282.26 125.83 106.30

34.44

34.44

277.74

277.74

96.67

96.67

216.48

216.48

52.44 90.90 87.20

52.44 90.90 87.20

163.77 179.30

163.77 179.30

2823.20

2823.20

A C Birkle

07/01/20 14/01/20 21/01/20 28/01/20

NONE NONE NONE NONE

60.00 60.00 60.00 60.00

60.00 60.00 60.00 60.00

240.00

240.00

BAR

09/01/20 16/01/20 23/01/20 23/01/20 30/01/20 31/01/20

4327 4156 4264 6595 4471

48.66 31.66 57.61

48.66 31.66 57.61 -51.88 49.74 23.31

51.88

49.74 23.31

NONE

210.98

51.88

159.10

Bebida

13/01/20 27/01/20

9517 0812

165.02 300.00

165.02 300.00

465.02

465.02

Page 1

Continued ...

F30 Quorn Grange Quorn

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

DELIVERY SUMMARY

Supplier Name

Delivery Date

Delivery Ref

Purchases at Cost

Credits at Cost

Total at Cost

Continental Coffee

29/01/20

7362

70.80

70.80

70.80

70.80

Direct Seafoods

06/01/20 08/01/20 09/01/20 10/01/20 11/01/20 13/01/20 14/01/20 15/01/20 16/01/20 17/01/20 18/01/20 22/01/20 22/01/20 23/01/20 27/01/20 27/01/20 29/01/20 01/02/20 04/02/20 04/02/20

1667 2611 3067 3596 4166 0462 5073 5550 6010 6581 0726 8695 8696 9183 4097 1986 3699 4741 4742

49.66 11.25 81.59 11.25 45.82 62.78 59.54 91.45 30.00 33.74 26.00 68.61 62.61 178.94 168.51

49.66 11.25 81.59 11.25 45.82 62.78 59.54 91.45 30.00 33.74 26.00 68.61 62.61 178.94 168.51 -51.70

NONE

51.70

33.66 51.42 10.91 56.82

33.66 51.42 10.91 56.82

1134.56

51.70

1082.86

Delice de France

08/01/20 10/01/20 15/01/20 22/01/20 29/01/20 31/01/20

2456 4333 2288 5325 6979 7554

215.70

215.70

45.48 33.33

45.48 33.33

148.98 111.99

148.98 111.99

29.88

29.88

585.36

585.36

Olleco

06/01/20 09/01/20 17/01/20

1064 6658 8159

79.90 40.40 80.80

79.90 40.40 80.80

201.10

201.10

Price & Fretwell Ltd

13/12/19 16/01/20 27/01/20 31/01/20

NONE

6.00

-6.00

3251 3964

114.69

114.69 68.88 -28.00

68.88

NONE

28.00

Page 2

Continued ...

F30 Quorn Grange Quorn

Period from 6th January 2020

STOCK AUDIT by

to 4th February 2020 29 Days

DELIVERY SUMMARY

Supplier Name

Delivery Date

Delivery Ref

Purchases at Cost

Credits at Cost

Total at Cost

183.57

34.00

149.57

Veg Factor

07/01/20 08/01/20 08/01/20 09/01/20 10/01/20 11/01/20 13/01/20 14/01/20 14/01/20 15/01/20 15/01/20 15/01/20 16/01/20 16/01/20 16/01/20 16/01/20 17/01/20 18/01/20 20/01/20 21/01/20 22/01/20 23/01/20 24/01/20 25/01/20 27/01/20 28/01/20 28/01/20 29/01/20 30/01/20 31/01/20 01/02/20 03/02/20 04/02/20 07/01/20 07/01/20 09/01/20 14/01/20 16/01/20 21/01/20 23/01/20 28/01/20 28/01/20

4732 4805 4809 4900 5114 5202 5280 5367 5388 5377 5466 5479 5474 5570 5572 5574 5730 5755 5880 5951 6035 6121 6349 6449 6530 6539 6616 6615 6757 6949 7027 7108 7181 0405 4043 4324 1391 5445 2472 6595 3543 4042

149.42

149.42

83.33 11.25

83.33 11.25

153.82 154.05 264.30

153.82 154.05 264.30

98.34

98.34

231.56

231.56

8.58

8.58

228.28

228.28

43.89

43.89

2.90

2.90

63.60

63.60

3.20 5.68

3.20 5.68

23.43

23.43

167.37 449.24 179.43 106.67 137.20 199.83 128.43 122.70 344.31 148.21 105.21 174.82 291.31 202.28 145.04 177.10 19.73

167.37 449.24 179.43 106.67 137.20 199.83 128.43 122.70 344.31 148.21 105.21 174.82 291.31 202.28 145.04 177.10 372.58 -43.94 401.11 639.04 221.76 541.36 442.80 930.15 -21.49 19.73 4624.51

4624.51

Woodwards

372.58

43.94

401.11 639.04 221.76 541.36 442.80 930.15

21.49

Page 3

Continued ...

Made with FlippingBook - Online magazine maker