事業計画サンプル(夜は酒も出すラーメン屋)powered by カンム八巻 @8maki
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBE
1
2
NORMAL
広告打つ高単価ラーメン出す夜の営業時間増やす高単価酒出す夜の営業時間増やす夜の営業時間増やす
2
2018201820182018201820182018201820182018201820182018201920192019201920192019201920192019201920192019202020202020202020202020202020202020202020202020
3
KPI単位初期投資1(予)1(実)2(予)2(実)3456789101112123456789101112123456789101112
4
月次来店数
2,6001,7802,6002,0002,2402,2402,2402,4002,4002,4002,4002,4002,2402,2402,2402,2402,2402,2402,2402,4002,4002,4002,4002,4002,2402,2402,2402,2402,2402,2402,2402,4002,4002,4002,4002,4002,2402,240
5
日次来店数
13089130100112112112120120120120120112112112112112112112120120120120120112112112112112112112120120120120120112112
6
日次来店数(昼)
8060806572727272727272727272727272727272727272727272727272727272727272727272
7
時間当来店数(昼)2015.002016.2518.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.0018.00
8
営業時間(昼)h44444444444444444444444444444444444444
9
日次来店数(夜)
5029503540404048484848484040404040404048484848484040404040404048484848484040
10
時間当来店数(夜)105.80107.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.008.00
11
営業時間(夜)h55555556666655555556666655555556666655
12
_月次来店数(酒)
1,0005801,000700800800800960960960960960800800800800800800800960960960960960800800800800800800800960960960960960800800
13
内日次来店数(酒)=日次来店数(夜)
5029503540404048484848484040404040404048484848484040404040404048484848484040
14
営業日数
d2020202020202020202020202020202020202020202020202020202020202020202020202020
15
売上03,080,0001,861,2483,080,0002,180,2002,592,0002,816,0002,816,0003,120,0003,312,0003,312,0003,312,0003,312,0002,976,0002,976,0002,976,0002,976,0002,976,0002,976,0002,976,0003,312,0003,312,0003,312,0003,312,0003,312,0002,976,0002,976,0002,976,0002,976,0002,976,0002,976,0002,976,0003,312,0003,312,0003,312,0003,312,0003,312,0002,976,0002,976,000
16
ラーメン代
2,080,0001,384,8402,080,0001,570,0001,792,0002,016,0002,016,0002,160,0002,160,0002,160,0002,160,0002,160,0002,016,0002,016,0002,016,0002,016,0002,016,0002,016,0002,016,0002,160,0002,160,0002,160,0002,160,0002,160,0002,016,0002,016,0002,016,0002,016,0002,016,0002,016,0002,016,0002,160,0002,160,0002,160,0002,160,0002,160,0002,016,0002,016,000
17
平均単価
800778800785800900900900900900900900900900900900900900900900900900900900900900900900900900900900900900900900900900
18
注文数
2,6001,8502,6002,0502,2402,2402,2402,4002,4002,4002,4002,4002,2402,2402,2402,2402,2402,2402,2402,4002,4002,4002,4002,4002,2402,2402,2402,2402,2402,2402,2402,4002,4002,4002,4002,4002,2402,240
19
一人当たり注文数
11.0411.031.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.00
20
酒類1,000,000476,4081,000,000610,200800,000800,000800,000960,0001,152,0001,152,0001,152,0001,152,000960,000960,000960,000960,000960,000960,000960,0001,152,0001,152,0001,152,0001,152,0001,152,000960,000960,000960,000960,000960,000960,000960,0001,152,0001,152,0001,152,0001,152,0001,152,000960,000960,000
21
平均単価
500452500452500500500500600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600
22
注文数
2,0001,0542,0001,3501,6001,6001,6001,9201,9201,9201,9201,9201,6001,6001,6001,6001,6001,6001,6001,9201,9201,9201,9201,9201,6001,6001,6001,6001,6001,6001,6001,9201,9201,9201,9201,9201,6001,600
23
一人当たり注文数
21.8221.932.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.00
24
費用11,000,0002,960,0002,760,2002,960,0002,760,2003,800,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,0002,900,000
25
変動費
1,000,0002,000,0001,757,0002,000,0001,757,0002,840,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,0001,940,000
26
ラーメン原価
01,000,000942,0001,000,000942,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,000
27
日次当たり仕入れ金額
050,00047,10050,00047,10050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,000
28
酒類原価
01,000,000815,0001,000,000815,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000840,000
29
日次当たり仕入れ金額
050,00040,75050,00040,75042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,00042,000
30
広告宣伝費
1,000,00000001,000,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000
31
固定費
10,000,000960,0001,003,200960,0001,003,200960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000960,000
32
人件費
0600,000580,000600,000580,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000600,000
33
一人あたり人件費
0300,000290,000300,000290,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000
34
人数022222222222222222222222222222222222222
35
家賃0300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000
36
その他
10,000,00060,000123,20060,000123,20060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,000
37
対人件費当たり割合
0%10%21.24%10%21.24%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%10%
38
営業利益
-11,000,000120,000-898,952120,000-580,000-1,208,000-84,000-84,000220,000412,000412,000412,000412,00076,00076,00076,00076,00076,00076,00076,000412,000412,000412,000412,000412,00076,00076,00076,00076,00076,00076,00076,000412,000412,000412,000412,000412,00076,00076,000
39
累計利益
-11,000,000-10,880,000-11,778,952-11,658,952-12,238,952-13,446,952-13,530,952-13,614,952-13,394,952-12,982,952-12,570,952-12,158,952-11,746,952-11,670,952-11,594,952-11,518,952-11,442,952-11,366,952-11,290,952-11,214,952-10,802,952-10,390,952-9,978,952-9,566,952-9,154,952-9,078,952-9,002,952-8,926,952-8,850,952-8,774,952-8,698,952-8,622,952-8,210,952-7,798,952-7,386,952-6,974,952-6,562,952-6,486,952-6,410,952
40
41
年次計画
201820192020
42
年次来店数
26,98027,68027,680
43
_年次来店数(酒)
10,08010,40010,400
44
売上34,585,44837,392,00037,392,000
45
ラーメン代23,610,84024,912,00024,912,000
46
酒類10,974,60812,480,00012,480,000
47
費用46,420,40034,800,00034,800,000
48
変動費24,814,00023,280,00023,280,000
49
固定費21,606,40011,520,00011,520,000
50
営業利益
-11,834,9522,592,0002,592,000
51
累計利益
-11,594,952-9,002,952-6,410,952
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
Loading...
 
 
 
事業計画
 
 
Main menu