Hotel Directors Meeting March 2020

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