F&B KPIs

8/13/2019 F&B KPIs

1/23

EXAMPLE OF STOCK SHEET

Case Split Description Size of Split

1 1 Kelloggs cornflakes 400g

2 muller peach yogurt 100g

1 Korma sauce 2.25kg

Always make sure to fill in all the boxes

Current

Quantity

This button w

Move data to t

Clear the Cost

Clear the entry

8/13/2019 F&B KPIs

2/23

Splits per Case Price of Case Total Price

4 5.98 7.48

12 2.77 0.46

1 5.99 5.99

A COPY OF THE WORKBOOK

MAKE SURE YOU HAVE MADE

UNDER THE NEXT MONTHS NAME

BEFORE YOU CONTINUE!!!!!!!!

ill:

e next month in the stock sheets

Analysis sheet

boxes on the KPI sheet

8/13/2019 F&B KPIs

3/23

Case Split Description Size of Split Splits per Case

arriba espresso beans 500g 16

assorted jam portions 20g 100

brown sauce portions 200 1

butter portions size 7 100 5

cooked scrambled egg 1kg 2

demerara sugar sticks 1000 1

english mustard portions 200 1

ext life oil 20ltr 1Fairtrade envelop Tea bag 250 1

freeze dried coffee sticks 500g 1

hht semi skimmed dairystick 200 1

Kelloggs cornflakes 500g 4

Kelloggs crunchy nut cornflakes 500g 4

Kelloggs rice krispies 400g 4

Kelloggs special K 450g 4

LaBo fully baked butter croissant 50 50

LaBo fully baked pain au chocolat 30 30

low fat natural yog 115g 12

mandarin orange segments in sryup 2.6kg 6

marmalade portions 20g 100

mayonnaise portions 200 1

muller H/balance SM/peach yog 100g 12

muller H/balance SM/strawberry yog 100g 12

nescafe instdcaf coffe sticks 200 1

salted dairy butter 250g 1

soft spread 2kg 1

splenda granular sticks 1000 1starwberry jam portions 20g 100

suchard prem hot choc vend 1kg 10

sunflower spread portions 10g 100

tetley decaf drawstring 25 6

tomato ketchup portions 200 1

twinings fruit/herb var 20 12

weetabix 50 2

wh grapefruit segments in sryup 3kg 6

white sugar sticks 1000 1

wholewheat breakfast cereal 24 12

1

back bacon 1pack 4

cumberland 8's 4.54kg 1

1

milk semi pergal 1 1

banana 1x18kg 1

banana per kg 1

green apple each 1

red apple each 1egg tray 30 1

hovis white 1 1

hovis brown 1 1

orange citrus medium for juicing each 1

full fat milk 2ltr 1

Quantity

Current Month

8/13/2019 F&B KPIs

4/23

1

orange juice 10l 1

apple juice 10l 1

1

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

1

1

1

8/13/2019 F&B KPIs

5/23

Price of Case Total Price Case Split

43.82 - 8

6.20 - 2 50

3.17 - 1 0.25

20.52 - 1 3

4.79 - 16

6.48 -

4.00 -

20.59 -6.80 - 3

16.67 -

4.13 -

5.98 - 1 2

9.39 - 1 2

7.39 - 2

9.33 - 1 2

9.18 - 45

6.82 - 2

2.13 - 5

23.15 - 4 2

6.33 - 2 50

6.14 -

2.77 - 7

2.77 - 7

14.35 - 50

4.92 -

2.00 -

10.82 -6.57 -

50.31 -

2.55 - 3

8.97 - 1

3.39 - 1

16.39 - 3 6

9.63 - 1

15.82 - 2 5

5.58 - 1 0.25

21.33 --

31.75 - 2 1

18.53 -

-

7.50 - 2

19.99 -

1.20 -

0.15 - 30

0.15 -3.50 -

0.99 - 7

0.99 - 12

0.15 -

1.00 - 2

Quantity

Previous Month

8/13/2019 F&B KPIs

6/23

-

2.92 - 0.25

3.57 - 1

-

-

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

-

--

-

Total - Total 1,280.71

Previous Month

8/13/2019 F&B KPIs

7/23


les chocolats de luxe finesse 10kg 1

RA piacetto espr superiore 1kg 6

1

Mini Pack Biscuit Assortment 100 1

Fox Glacier Mints 3.18Kg 1

Kenco Rich Roast Vending Coff /10.29 - split-- (9 300g 10

Kenco Instant Decafe (10x300g = 149.93) 300g 1

Suchard Prem Hot Choc 1Kg 10Kenco Cappuccino topping 1.5Kg 6

UHT SSkimed Dairy sticks ptns 200 1

UHT Whole milk Dairy sticks ptns 200 1

Lace Tray Paper 30X40-15.77 /25X35 - 9.03 250 1

Buffet trays black - 46X30 50 1

1

1

1

1

1

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

11

1

1

1

1

Quantity

Current

8/13/2019 F&B KPIs

8/23

1

1

1

1

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

11

1

8/13/2019 F&B KPIs

9/23


70.42 - 1.75

139.54 - 1

-

14.17 -

11.42 -

94.87 - 8

13.73 -

38.20 - 160.04 - 1 2

3.40 -

3.40 -

9.03 - 0.2

25.08 -

-

-

-

-

--

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

- -

-

-

-

-

Quantity

Previous Month

8/13/2019 F&B KPIs

10/23

-

-

-

-

-

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

-

--

-

Total - Total 458.73

Previous Month

8/13/2019 F&B KPIs

11/23


1

battercrisp cod fillets 140-170g 20 1

battered onion rings 1kg 1

breaded wholetail scampi 20-30 500g 1

cajun seasonings 550g 6

carrot & coriander soup 1kg 5

catering peas 2.5kg 1

cauliflower each 1Cham burgers 156g(6oz) 24

chicken fillets 200/220g 1

chicken pakora 2kg 1

chocolate dessert sauce 500g 1

chota naan 30 1

citrus lemon each 1

cool mint fling 14 portions ind 1x1 1

dairy strawberry icecream 4ltr 1

dairy vanilla ice cream 4ltr 1

double cream 2.27ltr 1english mustard portions 200 1

ext life oil 20ltr 1

french dressing 2.27ltr 1

fresh herb parsley 250g 1

fries freeze chill 9/16 2.5kg 4

garlic & herb bread slices 75 1

groung white pepper 600g 6

hamburger relish 2.25kg 1

hollandaise sauce 1ltr 12jalfrezi sauce 2.25kg 1

korma sauce 2.25kg 1

LaBo 10" malted wheat baguette 30 1

LaBo petit Pain white 55g 70 1

LaBo white sandwich baguettes 10" 30 1

leeks per kg 1

lemon & pepper brd mushrooms 1kg 1

lime exotic each 1

madras sauce 2.25kg 1

mango chutney 3kg 1microwave chocolate pudding 12 1

minestrone soup 1kg 5

mix capsicum per kg 1

new washed potatoes per kg 1

real mayonnaise 5ltr 1

red onion per kg 1

roquette pesto chicken pasta 12 1

salad cucumber 50/60 spa 1

salad mix seasonal 500gm 1salmon pasta bake 400g 12 1

seasoned mushroom boats 1kg 1

sesame seed bun 5" 48 1

spinach & feta goujons 50 1

spinach & ricotta ravioli 12 1

Quantity

Current

8/13/2019 F&B KPIs

12/23

sundried tomato/basil soup 2.5kg 1

tartare sauce 2.27ltr 1

tikka masala sauce 2.25kg 1

broccolli loose 5kg 1

parsnips per kg 1

baker potaotes 15kg 1

mange tout 1.8kg 1

fresh chives herb per kg 1

1

mix leaf 1

tomato (case) 1

Burger 1

burger relish 1mayo 1

onion 1

mix peppers 1

cucumber 1

spices 1

tortilla chips 1

custard 1

brown sauce 1

tomato sauce 1

cod 1scampi 1

prawns 1

peas 1

mushroom boats 1

soup 1

twister fries 1

nann bread 1

chocolate puddings 1

pate 1ice cream 1

mint fling 1

bagguettes 1

spicy fries 1

chicken pasta 1

salmon bake 1

spinach ricotta 1

korma sauce 1

tikka sauce 1

jalfrezy sauce 1chicken fillets 1

soft cheese 1

fries 1

mild cheddar 1

caesar dressing 1

french dressing 1

tartare sauce 1

bbq sauce 1

mushroom buttons 1roast beef 1

ham 1

blackforest cake 1

spinach feta goujons 1

fillet chicken sate 1

8/13/2019 F&B KPIs

13/23

king prawns skewers 1

thai chicken skewers 1

paugasins goujons 1

veg spring roll 1

indian savory 1

chicken pakora 1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

11

1

1

1

1

1

8/13/2019 F&B KPIs

14/23


-

-

-

-

-

-

-

-18.00 -

4.30 -

-

-

-

0.35 -

-

-

-

5.25 --

-

-

1.60 -

-

-

-

-

- -

-

-

-

-

-

-

0.20 -

-

--

-

2.25 -

0.99 -

-

0.75 -

-

0.60 -

3.00 - -

-

-

-

-

Quantity

Previous Month

8/13/2019 F&B KPIs

15/23

-

-

-

7.99 -1.75 -

6.99 -

9.50 -

1.20 -

-

9.00 - 3

7.95 - 1

48.75 - 3

3.25 - 0.56.50 - 1

3.00 - 4

4.70 - 2

1.40 - 2

10.00 -

8.00 - 0.5

2.20 - 2

8.00 - 2

7.00 - 2

7.95 - 0.510.50 - 3

6.90 -

1.40 -

10.75 - 2

15.74 - 2

8.00 - 2

3.00 - 0.5

5.90 -

5.40 - 16.95 - 1

6.00 - 0.5

5.00 - 1

19.00 -

15.16 - 7

12.49 - 6

14.00 - 8

10.50 - 0.5

13.95 - 2

15.95 - 221.00 - 1

6.50 -

2.99 -

18.95 - 0

5.00 -

3.99 -

2.95 -

5.95 -

6.95 -4.00 -

3.00 -

5.99 -

6.09 -

5.50 -

8/13/2019 F&B KPIs

16/23

7.50 -

10.00 -

-

-13.76 -

11.00 -

-

-

-

-

-

-

--

-

-

-

-

-

-

-

-

--

-

-

-

-

-


Previous Month

8/13/2019 F&B KPIs

17/23


disaronno originale(amrto) 28% 70cl 1

bacardi superior rum 37.5% 70cl 1

baileys irish cream 17% 70cl 1

Bells whisky 40% 70cl 1

cape promise chenin blanc 13% 75cl 6

cape promise pinotage 14.1% 75cl 6

courvoisier vs cognac 40% 70cl 1

glenfiddich 12YO whisky 40% 70cl 1glenmorangie original 40% 70cl 1

Gordons gin 70cl 1

grouse 40% 70cl 1

jack daniels 40% 70cl 1

jamesons irish 40% 70cl 1

jose cuervo esecial gold 38% 70cl 1

l'emage merlot 13.5% 75cl 6

l'emage sauvignon blanc 12% 75cl 6

l'emage shiraz rose 12.5% 75cl 6

luxardo sambuca 38% 70cl 1malibu 21% 70cl 1

martini bianco 15% 75cl 6

moondarra shiraz 14.5% 75cl 6

smirnoff red 37.5% 70cl 1

southern comfort 35% 70cl 1

sunrise sauvignon blanc 13% 75cl 6

tia maria 20% 70cl 1

trulli pinot grigio del ven 12% 75cl 6

1budweiser 330ml 24

bvic blackcurrent cordial 1L 12

Bvic bitter lemon 125ml 24

bvic L/cal tonic water 125ml 24

bvic lime cordial 1L 12

bvic orange cordial 1L 12

Bvic orange juice 160ml 24

bvic tonic water 125ml 24

caffreys keg 11G 80

carling keg 11G 80diet pepsi 200ml 24

gunness draught can 440ml 24

J20 apple & mango 275ml 24

J20 orange & passion 275ml 24

J20 Red grape & blkcurrent 275ml 24

magners 568ml 12

pepsi cola 200ml 24

peroni 330ml 24

sch lemonade 200ml 24seven up can 330ml 24

smore sparkling 330ml 24

smore sparkling 1L 12

smore still 330ml 24

smore still 1L 12

Quantity

Current

8/13/2019 F&B KPIs

18/23

sol nrb sgl 330ml 24

stella artois 330ml 24

1

archers 70cl 1bristol cream 75cl 1

JP Chennet white 75cl 6

JP Chennet Red 75cl 6

1

ginger ale 125ml 24

1

1

1

11

1

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

11

1

1

1

1

1

1

1

1

11

1

1

1

1

1

8/13/2019 F&B KPIs

19/23


11.88 - 0.5

11.73 - 1 0.5

9.41 - 0.5

10.36 - 2 0.5

18.60 - 4.5

20.94 - 6.5

13.02 - 1.5

9.55 - 0.521.41 - 1

9.69 - 0.1

11.89 -

13.66 - 0.5

12.45 - 0.5

13.15 - 1

17.70 - 0.7

19.15 - 11.5

18.79 - 7.5

11.46 -9.73 - 1

4.47 - 1.5

29.46 -

9.73 - 2

12.68 - 0.7

23.82 -

10.68 - 0.5

20.52 - 2.5

-22.00 - 7

18.77 - 5

5.83 - 15

5.83 -

18.77 - 10

18.77 - 4

14.49 - 19

5.83 - 37

72.14 - 1 20

65.30 - 108.81 - 17

23.50 - 28

16.82 - 8

16.82 - 4

16.82 - 12

15.32 - 96

8.81 - 23

19.41 - 3

14.03 -10.33 -

11.20 - 67

10.61 - 35

11.20 - 67

10.61 -

Quantity

Previous Month

8/13/2019 F&B KPIs

20/23

18.20 - 30

24.09 - 77

-

10.00 - 1.56.30 - 1.5

19.99 - 6.3

19.99 - 0.5

-

6.85 - 30

-

-

-

- -

-

-

-

-

-

-

-

-

--

-

-

-

-

-

-

-

- -

-

-

-

-

-

-

-

-

--

-

-

-

-

-


Previous Month

8/13/2019 F&B KPIs

21/23

BREAKFAST/

SLEEPERS 3516 BAR 5,235.44 BAR 397.40 BAR 205.05

GROUP DINNER 208 RESTURANT 2,676.21 RESTURANT 141.73 RESTURANT NA

CONFERENCE

DDELEGATES 155 CONFERENCE 778.50 CONFERENCE CONFERENCE NA

DATE 1-Dec OPENING STOCK 1,271.49 1,491.06 1,055.29 0.00 52.19

CLOSING STOCK 1,434.10 1,527.00 1,056.00 -

RUNNING TOTAL 3,956.14 1,686.97 1,354.00 1,504.67 632.67KPI 1.08 28.28% 48.02% 7.23 4.42

NOMINAL ACC. 5000 5004 5013 5014 5002

DATE SUPPLIER INV BREAKFAST BAR RESTAURANT GROUP CONFERENCE

04/11/13 Welsh Bros 124.55

04/11/13 Brakes 57.07 283.00 7.50

04/11/13 Brakes 19.49

01/11/13 Brakes 193.12

06/11/13 Brakes 86.67 58.65

07/11/13 Brakes 68.84

04/11/13 Brakes 134.15 181.09

04/11/13 Brakes

01/11/13 Brakes 114.24

01/11/13 Brakes 145.32

06/11/13 Brakes 83.24

08/11/13 Brakes 114.67

06/11/13 Molson Coors 221.19

08/11/13 FN Foods 203148 37.45

07/11/13 FN Foods 202999 53.85 25.80

06/11/13 FN Foods 202901 47.23 8.9604/11/13 FN Foods 202663 96.02

04/11/13 FN Foods 202664 100.55

02/11/13 FN Foods 202564 35.68

16/10/13 FN Foods 291122 80.57

13/11/13 Tchibo 9410752269 220.00

07/11/13 Molson Coors 901572680 180.00

11/11/13 Krogab 220955 137.60

05/11/13 Krogab 220665 130.80

08/11/13 Welsh Bros 1570554 23.00

12/11/13 Welsh Bros 1571440 49.0215/11/13 Welsh Bros 1572275 54.75

14/11/13 Booker 418187 282.33

14/11/13 Booker 418189 4.85

14/11/13 Booker 418188 292.98

09/11/13 FN Foods 203248 61.30

11/11/13 FN Foods 203359 63.67

12/11/13 FN Foods 203481 22.95

13/11/13 FN Foods 203592 75.80

14/11/13 FN Foods 203704 29.70

15/11/13 FN Foods 203812 15.40

16/11/13 FN Foods 203920 144.06

18/11/13 FN Foods 204030 56.13

31/10/13 Brakes 9222009594 -46.50

11/11/13 Brakes 9222342795 103.12 59.15

15/11/13 Brakes 9222345982 77.77 19.90

08/11/13 Brakes 34144579 98.69

11/11/13 Brakes 34151017 103.06

GUESTS REVENUE SPILLAGE/ WASTEGE/COMP IHG REWARDS CLUB

8/13/2019 F&B KPIs

22/23

26/11/13 Brakes 9222353814 78.1027/11/13 FN Foods 204999 24.99 8.35

28/11/13 FN Foods 205113 13.00

29/11/13 FN Foods 205245 64.90

30/11/13 FN Foods 205361 132.03

25/11/13 Welsh Bros 1574157 44.25

29/11/13 Welsh Bros 1575329 77.50

Molson Coors 150.00

29/11/13 Bookers 244794 464.37

29/11/13 Bookers 244795 12.19

26/11/13 Bookers 419329 693.1929/11/13 Bookers 419528 148.07

29/11/13 Bookers 419527 343.57

8/13/2019 F&B KPIs

23/23

Account Number Phone number Sales Rep Sales Rep Phone

Mon Tue Wed Thu Fri Sat Sun

FoodBrakes Groceries 523220 0844 800 4910 Order Delivery Order Delivery

Brakes Frozen 707956 0844 800 4910 Order Order/Delivery Order/Delivery Order/Delivery Order/Delivery Delivery

F*N Foods EXPRESSB 01793 522 233

Welsh Bros 5070 01633 273 344

Frution (Stationary,HK soft Drink) User Password Order/Del ivery Order/Del ivery Order/Del ivery Order/Del ivery Order/Del ivery Order/Del ivery Order/Del ivery

Drinks

Waverly 391498 0844 556 2520 Order Delivery Lee Williams 07919 566 110

waverleytbsonline.co.uk BX138339 Expressisgreat Order Order Order Order Order/Delivery Order Order

Molson Coors 00516991100 08456 000 888 Order Delivery

ordering.molsoncoorsdirect.com BX138341 Expressisgreat Order Order Order Order/Delivery Order Order Order

Britvic 758068 01217 111 102 Fruition Fruition Fruition Fruition Fruition Fruition Fruition

Stationary

Office Depot HCM02 08704 114 968 Fruition Fruition Fruition Fruition Fruition Fruition Fruition

Charisma 01217 726 020 Fruition Fruition Fruition Fruition Fruition Fruition Fruition

Neopost A4668590 08458 800 0000

Coffee

Tchibo 2015226 01372 736 260Tchibo Support 0800 824 426

Housekeeping

Bunzl 00031839 01179 821 111 Fruition Fruition Fruition Fruition Fruition Fruition Fruition

Uniform

Simon Jersey IC012235/000 08444 994 414

Order/Delivery

F&B KPIs

Documents

Transcript of F&B KPIs