ABCDEFGHIJKLMNOPQRSTUVWXY
1
Месяц работы ресторана
0123456789101112131415161718
2
3
P&L
4
Выручка (с НДС)490,962995,8501,251,4371,424,2101,561,6161,678,0831,781,3691,876,2631,964,4852,047,8892,129,9952,208,2072,288,6712,331,0452,366,1112,394,4052,415,0952,431,9552,445,942
5
Выручка490,962995,8501,251,4371,424,2101,561,6161,678,0831,781,3691,876,2631,964,4852,047,8892,129,9952,208,2072,288,6712,331,0452,366,1112,394,4052,415,0952,431,9552,445,942
6
Unit Cost162,815333,804416,202468,813508,423540,208566,902590,165610,649629,000646,302661,854670,868683,244693,541701,914708,136713,262717,564
7
% от продаж33.2%33.5%33.3%32.9%32.6%32.2%31.8%31.5%31.1%30.7%30.3%30.0%29.3%29.3%29.3%29.3%29.3%29.3%29.3%
8
Labour Cost582,939596,686606,534614,944622,170628,259633,490638,123642,132645,624648,993651,775654,754657,476659,442660,692661,093661,127660,905
9
% от продаж118.7%59.9%48.5%43.2%39.8%37.4%35.6%34.0%32.7%31.5%30.5%29.5%28.6%28.2%27.9%27.6%27.4%27.2%27.0%
10
Kitchen Cost430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689
11
% от продаж87.7%43.2%34.4%30.2%27.6%25.7%24.2%23.0%21.9%21.0%20.2%19.5%18.8%18.5%18.2%18.0%17.8%17.7%17.6%
12
GM Cost89,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,655
13
% от продаж18.3%9.0%7.2%6.3%5.7%5.3%5.0%4.8%4.6%4.4%4.2%4.1%3.9%3.8%3.8%3.7%3.7%3.7%3.7%
14
Delivery Cost62,59576,34286,19094,600101,825107,914113,146117,779121,788125,280128,649131,431134,410137,132139,097140,348140,749140,783140,561
15
% от продаж12.7%7.7%6.9%6.6%6.5%6.4%6.4%6.3%6.2%6.1%6.0%6.0%5.9%5.9%5.9%5.9%5.8%5.8%5.7%
16
Маркетинг26,23126,23126,23126,23126,23126,23126,23126,23126,23126,23126,23126,23126,23124,60622,98121,35619,73118,10716,482
17
% от продаж5.3%2.6%2.1%1.8%1.7%1.6%1.5%1.4%1.3%1.3%1.2%1.2%1.1%1.1%1.0%0.9%0.8%0.7%0.7%
18
Роялти20,27741,12951,68458,82064,49569,30573,57177,49081,13384,57887,96991,19994,522137,532139,601141,270142,491143,485144,311
19
% от продаж4.1%4.1%4.1%4.1%4.1%4.1%4.1%4.1%4.1%4.1%4.1%4.1%4.1%5.9%5.9%5.9%5.9%5.9%5.9%
20
Аренда190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000190,000
21
% от продаж38.7%19.1%15.2%13.3%12.2%11.3%10.7%10.1%9.7%9.3%8.9%8.6%8.3%8.2%8.0%7.9%7.9%7.8%7.8%
22
Прочие расходы170,034191,682203,029210,965217,406222,930227,872232,448236,723240,781244,806248,641252,625254,657256,303257,590258,467259,146259,678
23
% от продаж34.6%19.2%16.2%14.8%13.9%13.3%12.8%12.4%12.1%11.8%11.5%11.3%11.0%10.9%10.8%10.8%10.7%10.7%10.6%
24
Коммунальные144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432
25
% от продаж29.4%14.5%11.5%10.1%9.2%8.6%8.1%7.7%7.4%7.1%6.8%6.5%6.3%6.2%6.1%6.0%6.0%5.9%5.9%
26
Расходные материалы
9,81919,91725,02928,48431,23233,56235,62737,52539,29040,95842,60044,16445,77346,62147,32247,88848,30248,63948,919
27
% от продаж2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%
28
Колл-центр5,9637,4168,5409,56410,50911,37412,18512,96613,71214,43315,17415,88016,64616,98317,22717,38217,43217,43617,408
29
% от продаж1.2%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%0.7%
30
Прочие9,81919,91725,02928,48431,23233,56235,62737,52539,29040,95842,60044,16445,77346,62147,32247,88848,30248,63948,919
31
% от продаж2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%
32
Store-level EBITDA
-661,333-383,681-242,243-145,562-67,1081,15263,304121,806177,616231,676285,694338,507399,671383,530404,244421,583435,177446,827457,003
33
% от продаж-134.7%-38.5%-19.4%-10.2%-4.3%0.1%3.6%6.5%9.0%11.3%13.4%15.3%17.5%16.5%17.1%17.6%18.0%18.4%18.7%
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100