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