アパレル開業シミュレーション

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2	2018年		単位	11月	12月	1月	2月	3月	4月	5月	6月	7月	8月	9月	10月	年合計
3	売上高		円	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	78,000,000
4		アパレル	円	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	6,500,000	78,000,000
5
6	売上原価		円	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	46,800,000
7		アパレル6掛け	円	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	3,900,000	46,800,000
8
9	売上総利益		円	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	31,200,000
10		アパレル	円	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	2,600,000	31,200,000
11
12
13	販売費及び一般管理費用		円	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	2,415,000	28,980,000
14		旅費交通費		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
15		広告宣伝費		300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	3,600,000
16		容器包装費		10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	120,000
17		発送配達費		20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	240,000
18		システム費		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
19		その他販売費		50000	50000	50000	50000	50000	50000	50000	50000	50000	50000	50000	50,000	600,000
20		調査研究費		10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10,000	120,000
21		役員報酬		300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	3,600,000
22		従業員給与		600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	7,200,000
23		法定福利費		150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	1,800,000
24		福利厚生費		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
25		書籍研究費		10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	120,000
26		地代家賃		300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	3,600,000
27		修繕費		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
28		事務用消耗品費		20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	240,000
29		通信費		10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	120,000
30		水道光熱費		100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	1,200,000
31		租税公課		30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	360,000
32		保険料		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
33		備品消耗品費		30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	360,000
34		管理諸費		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
35		車両費		30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	30,000	360,000
36		接待交際費		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
37		外注費		0	0	0	0	0	0	0	0	0	0	0	0	0
38		決済手数料		130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	1,560,000
39		雑費		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
40		販売促進費		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
41	営業利益		円	185,000	185,000	185,000	185,000	185,000	185,000	185,000	185,000	185,000	185,000	185,000	185,000	2,220,000
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