事業計画サンプル（夜は酒も出すラーメン屋）powered by カンム八巻 @8maki

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AV	AW	AX	AY	AZ	BA
1	2	NORMAL											広告打つ	高単価ラーメン出す		夜の営業時間増やす	高単価酒出す											夜の営業時間増やす												夜の営業時間増やす
2								2018		2018		2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020
3		KPI					単位	初期投資	1(予)	1(実)	2(予)	2(実)	3	4	5	6	7	8	9	10	11	12	1	2	3	4	5	6	7	8	9	10	11	12	1	2	3	4	5	6	7	8	9	10	11	12

4			月次来店数				人		2,600	1,780	2,600	2,000	2,240	2,240	2,240	2,400	2,400	2,400	2,400	2,400	2,240	2,240	2,240	2,240	2,240	2,240	2,240	2,400	2,400	2,400	2,400	2,400	2,240	2,240	2,240	2,240	2,240	2,240	2,240	2,400	2,400	2,400	2,400	2,400	2,240	2,240
5				日次来店数			人		130	89	130	100	112	112	112	120	120	120	120	120	112	112	112	112	112	112	112	120	120	120	120	120	112	112	112	112	112	112	112	120	120	120	120	120	112	112
6					日次来店数(昼)		人		80	60	80	65	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72	72
7						時間当来店数(昼)	人		20	15.00	20	16.25	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00	18.00
8						営業時間(昼)	h		4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4
9					日次来店数(夜)		人		50	29	50	35	40	40	40	48	48	48	48	48	40	40	40	40	40	40	40	48	48	48	48	48	40	40	40	40	40	40	40	48	48	48	48	48	40	40
10						時間当来店数(夜)	人		10	5.80	10	7.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00	8.00
11						営業時間(夜)	h		5	5	5	5	5	5	5	6	6	6	6	6	5	5	5	5	5	5	5	6	6	6	6	6	5	5	5	5	5	5	5	6	6	6	6	6	5	5
12			_月次来店数(酒)				人		1,000	580	1,000	700	800	800	800	960	960	960	960	960	800	800	800	800	800	800	800	960	960	960	960	960	800	800	800	800	800	800	800	960	960	960	960	960	800	800
13				内日次来店数(酒)=日次来店数(夜)			人		50	29	50	35	40	40	40	48	48	48	48	48	40	40	40	40	40	40	40	48	48	48	48	48	40	40	40	40	40	40	40	48	48	48	48	48	40	40
14			営業日数				d		20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20
15		売上					円	0	3,080,000	1,861,248	3,080,000	2,180,200	2,592,000	2,816,000	2,816,000	3,120,000	3,312,000	3,312,000	3,312,000	3,312,000	2,976,000	2,976,000	2,976,000	2,976,000	2,976,000	2,976,000	2,976,000	3,312,000	3,312,000	3,312,000	3,312,000	3,312,000	2,976,000	2,976,000	2,976,000	2,976,000	2,976,000	2,976,000	2,976,000	3,312,000	3,312,000	3,312,000	3,312,000	3,312,000	2,976,000	2,976,000
16			ラーメン代				円		2,080,000	1,384,840	2,080,000	1,570,000	1,792,000	2,016,000	2,016,000	2,160,000	2,160,000	2,160,000	2,160,000	2,160,000	2,016,000	2,016,000	2,016,000	2,016,000	2,016,000	2,016,000	2,016,000	2,160,000	2,160,000	2,160,000	2,160,000	2,160,000	2,016,000	2,016,000	2,016,000	2,016,000	2,016,000	2,016,000	2,016,000	2,160,000	2,160,000	2,160,000	2,160,000	2,160,000	2,016,000	2,016,000
17				平均単価			円		800	778	800	785	800	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900	900
18				注文数			回		2,600	1,850	2,600	2,050	2,240	2,240	2,240	2,400	2,400	2,400	2,400	2,400	2,240	2,240	2,240	2,240	2,240	2,240	2,240	2,400	2,400	2,400	2,400	2,400	2,240	2,240	2,240	2,240	2,240	2,240	2,240	2,400	2,400	2,400	2,400	2,400	2,240	2,240
19					一人当たり注文数		回		1	1.04	1	1.03	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
20			酒類				円		1,000,000	476,408	1,000,000	610,200	800,000	800,000	800,000	960,000	1,152,000	1,152,000	1,152,000	1,152,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	1,152,000	1,152,000	1,152,000	1,152,000	1,152,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	1,152,000	1,152,000	1,152,000	1,152,000	1,152,000	960,000	960,000
21				平均単価			円		500	452	500	452	500	500	500	500	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600	600
22				注文数			回		2,000	1,054	2,000	1,350	1,600	1,600	1,600	1,920	1,920	1,920	1,920	1,920	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,920	1,920	1,920	1,920	1,920	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,920	1,920	1,920	1,920	1,920	1,600	1,600
23					一人当たり注文数		回		2	1.82	2	1.93	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00
24		費用					円	11,000,000	2,960,000	2,760,200	2,960,000	2,760,200	3,800,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000	2,900,000
25			変動費				円	1,000,000	2,000,000	1,757,000	2,000,000	1,757,000	2,840,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000	1,940,000
26				ラーメン原価			円	0	1,000,000	942,000	1,000,000	942,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000	1,000,000
27					日次当たり仕入れ金額		円	0	50,000	47,100	50,000	47,100	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000
28				酒類原価			円	0	1,000,000	815,000	1,000,000	815,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000	840,000
29					日次当たり仕入れ金額		円	0	50,000	40,750	50,000	40,750	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000	42,000
30				広告宣伝費			円	1,000,000	0	0	0	0	1,000,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000
31			固定費				円	10,000,000	960,000	1,003,200	960,000	1,003,200	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000	960,000
32				人件費			円	0	600,000	580,000	600,000	580,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000
33					一人あたり人件費		円	0	300,000	290,000	300,000	290,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000
34					人数		円	0	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
35				家賃			円	0	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000
36				その他			円	10,000,000	60,000	123,200	60,000	123,200	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,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,000	120,000	-898,952	120,000	-580,000	-1,208,000	-84,000	-84,000	220,000	412,000	412,000	412,000	412,000	76,000	76,000	76,000	76,000	76,000	76,000	76,000	412,000	412,000	412,000	412,000	412,000	76,000	76,000	76,000	76,000	76,000	76,000	76,000	412,000	412,000	412,000	412,000	412,000	76,000	76,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																																															年次計画			2018	2019	2020
42																																															年次来店数		人	26,980	27,680	27,680
43																																															_年次来店数(酒)		人	10,080	10,400	10,400
44																																															売上		円	34,585,448	37,392,000	37,392,000
45																																																ラーメン代	円	23,610,840	24,912,000	24,912,000
46																																																酒類	円	10,974,608	12,480,000	12,480,000
47																																															費用		円	46,420,400	34,800,000	34,800,000
48																																																変動費	円	24,814,000	23,280,000	23,280,000
49																																																固定費	円	21,606,400	11,520,000	11,520,000
50																																															営業利益		円	-11,834,952	2,592,000	2,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