ABCDEFGHIJKLMNOPQRSTUVWXY
1
Месяц работы ресторана
0123456789101112131415161718
2
3
P&L
4
Выручка (с НДС)469,167968,3481,219,3081,387,7121,520,9461,633,4531,732,9031,823,9941,908,4721,988,1542,066,3772,140,7752,217,0922,257,5352,290,9562,317,8952,340,2842,356,9312,370,624
5
Выручка469,167968,3481,219,3081,387,7121,520,9461,633,4531,732,9031,823,9941,908,4721,988,1542,066,3772,140,7752,217,0922,257,5352,290,9562,317,8952,340,2842,356,9312,370,624
6
Unit Cost157,798329,093411,122463,121502,056533,164559,187581,774601,592619,284635,896650,782658,987670,972680,932689,025695,801700,929705,198
7
% от продаж33.6%34.0%33.7%33.4%33.0%32.6%32.3%31.9%31.5%31.1%30.8%30.4%29.7%29.7%29.7%29.7%29.7%29.7%29.7%
8
Labour Cost577,683590,276599,297607,001613,619619,197623,989628,234631,906635,104638,191640,739643,468645,898647,620648,675649,294649,299649,042
9
% от продаж123.1%61.0%49.2%43.7%40.3%37.9%36.0%34.4%33.1%31.9%30.9%29.9%29.0%28.6%28.3%28.0%27.7%27.5%27.4%
10
Kitchen Cost430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689430,689
11
% от продаж91.8%44.5%35.3%31.0%28.3%26.4%24.9%23.6%22.6%21.7%20.8%20.1%19.4%19.1%18.8%18.6%18.4%18.3%18.2%
12
GM Cost89,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,65589,655
13
% от продаж19.1%9.3%7.4%6.5%5.9%5.5%5.2%4.9%4.7%4.5%4.3%4.2%4.0%4.0%3.9%3.9%3.8%3.8%3.8%
14
Delivery Cost57,33969,93178,95286,65693,27598,853103,645107,889111,562114,760117,846120,395123,123125,554127,276128,331128,949128,955128,698
15
% от продаж12.2%7.2%6.5%6.2%6.1%6.1%6.0%5.9%5.8%5.8%5.7%5.6%5.6%5.6%5.6%5.5%5.5%5.5%5.4%
16
Маркетинг24,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00022,51321,02719,54018,05316,56715,080
17
% от продаж5.1%2.5%2.0%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.8%0.7%0.6%
18
Роялти19,37739,99350,35757,31262,81567,46271,56975,33178,82082,11185,34188,41491,566133,195135,166136,756138,077139,059139,867
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
% от продаж38.4%18.6%14.8%13.0%11.8%11.0%10.4%9.9%9.4%9.1%8.7%8.4%8.1%8.0%7.9%7.8%7.7%7.6%7.6%
22
Прочие расходы168,746190,065201,149208,838215,047220,352225,084229,454233,528237,386241,204244,837248,602250,526252,079253,289254,263254,929255,445
23
% от продаж36.0%19.6%16.5%15.0%14.1%13.5%13.0%12.6%12.2%11.9%11.7%11.4%11.2%11.1%11.0%10.9%10.9%10.8%10.8%
24
Коммунальные144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432144,432
25
% от продаж30.8%14.9%11.8%10.4%9.5%8.8%8.3%7.9%7.6%7.3%7.0%6.7%6.5%6.4%6.3%6.2%6.2%6.1%6.1%
26
Расходные материалы
9,38319,36724,38627,75430,41932,66934,65836,48038,16939,76341,32842,81544,34245,15145,81946,35846,80647,13947,412
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,5486,8997,9458,8989,77710,58211,33612,06312,75713,42814,11714,77415,48715,79216,00916,14216,21916,22016,188
29
% от продаж1.2%0.7%0.7%0.6%0.6%0.6%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,38319,36724,38627,75430,41932,66934,65836,48038,16939,76341,32842,81544,34245,15145,81946,35846,80647,13947,412
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
-658,438-385,079-246,617-152,560-76,591-10,72249,074105,201158,627210,269261,745312,003370,469354,432374,133390,610404,796416,148425,993
33
% от продаж-140.3%-39.8%-20.2%-11.0%-5.0%-0.7%2.8%5.8%8.3%10.6%12.7%14.6%16.7%15.7%16.3%16.9%17.3%17.7%18.0%
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