ABCDEFGHIJKLMNOPQRSTUVWXY
1
Месяц работы ресторана
0123456789101112131415161718
2
3
P&L
4
Выручка (с НДС)521,5651,051,5711,320,5361,502,8231,648,0591,771,3271,880,7661,981,4182,075,0742,163,6842,250,9982,334,2152,419,9132,464,0302,501,6112,530,7412,553,0262,569,9712,585,092
5
Выручка521,5651,051,5711,320,5361,502,8231,648,0591,771,3271,880,7661,981,4182,075,0742,163,6842,250,9982,334,2152,419,9132,464,0302,501,6112,530,7412,553,0262,569,9712,585,092
6
Unit Cost169,513345,481430,470484,872525,911558,891586,628610,833632,173651,313669,385685,645695,226707,863718,671727,133733,692738,763743,309
7
% от продаж32.5%32.9%32.6%32.3%31.9%31.6%31.2%30.8%30.5%30.1%29.7%29.4%28.7%28.7%28.7%28.7%28.7%28.7%28.8%
8
Labour Cost701,830720,236733,421744,681754,355762,508769,512775,716781,083785,758790,269793,994797,982801,504804,223805,781806,413806,344806,137
9
% от продаж134.6%68.5%55.5%49.6%45.8%43.0%40.9%39.1%37.6%36.3%35.1%34.0%33.0%32.5%32.1%31.8%31.6%31.4%31.2%
10
Kitchen Cost498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483498,483
11
% от продаж95.6%47.4%37.7%33.2%30.2%28.1%26.5%25.2%24.0%23.0%22.1%21.4%20.6%20.2%19.9%19.7%19.5%19.4%19.3%
12
GM Cost119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540119,540
13
% от продаж22.9%11.4%9.1%8.0%7.3%6.7%6.4%6.0%5.8%5.5%5.3%5.1%4.9%4.9%4.8%4.7%4.7%4.7%4.6%
14
Delivery Cost83,807102,213115,398126,658136,332144,485151,489157,693163,060167,735172,246175,971179,959183,481186,200187,758188,390188,321188,114
15
% от продаж16.1%9.7%8.7%8.4%8.3%8.2%8.1%8.0%7.9%7.8%7.7%7.5%7.4%7.4%7.4%7.4%7.4%7.3%7.3%
16
Маркетинг40,50040,50040,50040,50040,50040,50040,50040,50040,50040,50040,50040,50040,50037,99135,48332,97430,46527,95625,448
17
% от продаж7.8%3.9%3.1%2.7%2.5%2.3%2.2%2.0%2.0%1.9%1.8%1.7%1.7%1.5%1.4%1.3%1.2%1.1%1.0%
18
Роялти21,54143,43054,53862,06768,06573,15677,67681,83385,70189,36092,96696,40399,942145,378147,595149,314150,629151,628152,520
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
Аренда180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000180,000
21
% от продаж34.5%17.1%13.6%12.0%10.9%10.2%9.6%9.1%8.7%8.3%8.0%7.7%7.4%7.3%7.2%7.1%7.1%7.0%7.0%
22
Прочие расходы171,409194,098206,009214,351221,130226,948232,156236,983241,494245,778250,031254,083258,297260,395262,156263,469264,421265,092265,677
23
% от продаж32.9%18.5%15.6%14.3%13.4%12.8%12.3%12.0%11.6%11.4%11.1%10.9%10.7%10.6%10.5%10.4%10.4%10.3%10.3%
24
Коммунальные144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432
25
% от продаж27.7%13.7%10.9%9.6%8.8%8.2%7.7%7.3%7.0%6.7%6.4%6.2%6.0%5.9%5.8%5.7%5.7%5.6%5.6%
26
Расходные материалы
10,43121,03126,41130,05632,96135,42737,61539,62841,50143,27445,02046,68448,39849,28150,03250,61551,06151,39951,702
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
Колл-центр6,1147,6038,7569,80610,77511,66312,49413,29414,05914,79915,55916,28317,06817,40217,66017,80817,86817,86117,842
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
Прочие10,43121,03126,41130,05632,96135,42737,61539,62841,50143,27445,02046,68448,39849,28150,03250,61551,06151,39951,702
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
-763,227-472,173-324,402-223,648-141,901-70,676-5,70655,554114,124170,975227,847283,590347,967330,898353,483372,071387,407400,188412,000
33
% от продаж-146.3%-44.9%-24.6%-14.9%-8.6%-4.0%-0.3%2.8%5.5%7.9%10.1%12.1%14.4%13.4%14.1%14.7%15.2%15.6%15.9%
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