Customer Profitability Sample.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	연월	고객ID	제품ID	사업부ID	시나리오ID	매출	재료비	변동노무비	세금	여행패키지매출	출장비	외주비용	구독매출
2	201411	10029	50	60	1	0	0	0	0	0	0	0	15000
3	201411	10029	50	60	1	0	0	0	0	0	0	0	-15000
4	201411	10029	50	14	1	0	0	0	0	0	0	0	9790
5	201411	10029	50	14	1	0	0	0	0	0	0	0	15000
6	201411	10029	50	14	1	0	0	0	0	0	0	0	8050
7	201310	10029	50	113	1	0	0	0	0	0	0	0	5595.25
8	201310	10029	50	113	1	0	0	0	0	0	0	0	15000
9	201311	10029	50	113	1	0	0	0	0	0	0	0	15000
10	201312	10029	50	113	1	0	0	0	0	0	0	0	15000
11	201401	10029	50	113	1	0	0	0	0	0	0	0	15000
12	201402	10029	50	113	1	0	0	0	0	0	0	0	9790
13	201402	10029	50	113	1	0	0	0	0	0	0	0	15000
14	201402	10029	50	113	1	0	0	0	0	0	0	0	8050
15	201403	10029	50	113	1	0	0	0	0	0	0	0	9790
16	201403	10029	50	113	1	0	0	0	0	0	0	0	15000
17	201403	10029	50	113	1	0	0	0	0	0	0	0	8050
18	201404	10029	50	113	1	0	0	0	0	0	0	0	9790
19	201404	10029	50	113	1	0	0	0	0	0	0	0	15000
20	201404	10029	50	113	1	0	0	0	0	0	0	0	8050
21	201405	10029	50	113	1	0	0	0	0	0	0	0	9790
22	201405	10029	50	113	1	0	0	0	0	0	0	0	15000
23	201405	10029	50	113	1	0	0	0	0	0	0	0	8050
24	201406	10029	50	113	1	0	0	0	0	0	0	0	9790
25	201406	10029	50	113	1	0	0	0	0	0	0	0	15000
26	201406	10029	50	113	1	0	0	0	0	0	0	0	8050
27	201407	10029	50	113	1	0	0	0	0	0	0	0	9790
28	201407	10029	50	113	1	0	0	0	0	0	0	0	15000
29	201407	10029	50	113	1	0	0	0	0	0	0	0	8050
30	201407	10029	50	14	1	0	0	0	0	0	0	0	9790
31	201407	10029	50	14	1	0	0	0	0	0	0	0	8050
32	201408	10029	50	113	1	0	0	0	0	0	0	0	9790
33	201408	10029	50	113	1	0	0	0	0	0	0	0	15000
34	201408	10029	50	113	1	0	0	0	0	0	0	0	8050
35	201408	10029	50	14	1	0	0	0	0	0	0	0	9790
36	201408	10029	50	14	1	0	0	0	0	0	0	0	8050
37	201409	10029	50	113	1	0	0	0	0	0	0	0	9790
38	201409	10029	50	113	1	0	0	0	0	0	0	0	15000
39	201409	10029	50	113	1	0	0	0	0	0	0	0	8050
40	201409	10029	50	14	1	0	0	0	0	0	0	0	9790
41	201409	10029	50	14	1	0	0	0	0	0	0	0	8050
42	201410	10029	50	113	1	0	0	0	0	0	0	0	9790
43	201410	10029	50	113	1	0	0	0	0	0	0	0	15000
44	201410	10029	50	113	1	0	0	0	0	0	0	0	8050
45	201410	10029	50	60	1	0	0	0	0	0	0	0	15000
46	201410	10029	50	60	1	0	0	0	0	0	0	0	25000
47	201410	10029	50	60	1	0	0	0	0	0	0	0	-15000
48	201410	10029	50	60	1	0	0	0	0	0	0	0	-25000
49	201410	10029	50	14	1	0	0	0	0	0	0	0	25000
50	201410	10029	50	14	1	0	0	0	0	0	0	0	-25000
51	201410	10029	50	14	1	0	0	0	0	0	0	0	9790
52	201410	10029	50	60	1	0	0	0	0	0	0	0	25000
53	201410	10029	50	60	1	0	0	0	0	0	0	0	-25000
54	201410	10029	50	14	1	0	0	0	0	0	0	0	15000
55	201410	10029	50	14	1	0	0	0	0	0	0	0	25000
56	201410	10029	50	14	1	0	0	0	0	0	0	0	-25000
57	201410	10029	50	14	1	0	0	0	0	0	0	0	8050
58	201411	10029	50	113	1	0	0	0	0	0	0	0	9790
59	201411	10029	50	113	1	0	0	0	0	0	0	0	15000
60	201411	10029	50	113	1	0	0	0	0	0	0	0	8050
61	201310	10029	50	113	2	0	0	0	0	0	0	0	5595.25
62	201310	10029	50	113	2	0	0	0	0	0	0	0	15000
63	201311	10029	50	113	2	0	0	0	0	0	0	0	15000
64	201312	10029	50	113	2	0	0	0	0	0	0	0	15000
65	201401	10029	50	113	2	0	0	0	0	0	0	0	15000
66	201408	10029	50	14	2	0	0	0	0	0	0	0	9790
67	201408	10029	50	14	2	0	0	0	0	0	0	0	8050
68	201409	10029	50	113	2	0	0	0	0	0	0	0	9790
69	201409	10029	50	113	2	0	0	0	0	0	0	0	15000
70	201409	10029	50	113	2	0	0	0	0	0	0	0	8050
71	201409	10029	50	14	2	0	0	0	0	0	0	0	9790
72	201409	10029	50	14	2	0	0	0	0	0	0	0	8050
73	201410	10029	50	60	2	0	0	0	0	0	0	0	15000
74	201410	10029	50	60	2	0	0	0	0	0	0	0	25000
75	201410	10029	50	60	2	0	0	0	0	0	0	0	-15000
76	201410	10029	50	60	2	0	0	0	0	0	0	0	-25000
77	201410	10029	50	14	2	0	0	0	0	0	0	0	25000
78	201410	10029	50	14	2	0	0	0	0	0	0	0	-25000
79	201410	10029	50	14	2	0	0	0	0	0	0	0	9790
80	201410	10029	50	60	2	0	0	0	0	0	0	0	25000
81	201410	10029	50	60	2	0	0	0	0	0	0	0	-25000
82	201410	10029	50	14	2	0	0	0	0	0	0	0	15000
83	201410	10029	50	14	2	0	0	0	0	0	0	0	25000
84	201410	10029	50	14	2	0	0	0	0	0	0	0	-25000
85	201410	10029	50	14	2	0	0	0	0	0	0	0	8050
86	201411	10029	50	113	2	0	0	0	0	0	0	0	9790
87	201411	10029	50	113	2	0	0	0	0	0	0	0	15000
88	201411	10029	50	113	2	0	0	0	0	0	0	0	8050
89	201402	10029	50	113	2	0	0	0	0	0	0	0	9790
90	201402	10029	50	113	2	0	0	0	0	0	0	0	15000
91	201402	10029	50	113	2	0	0	0	0	0	0	0	8050
92	201403	10029	50	113	2	0	0	0	0	0	0	0	9790
93	201403	10029	50	113	2	0	0	0	0	0	0	0	15000
94	201403	10029	50	113	2	0	0	0	0	0	0	0	8050
95	201404	10029	50	113	2	0	0	0	0	0	0	0	9790
96	201404	10029	50	113	2	0	0	0	0	0	0	0	15000
97	201404	10029	50	113	2	0	0	0	0	0	0	0	8050
98	201407	10029	50	113	2	0	0	0	0	0	0	0	9790
99	201407	10029	50	113	2	0	0	0	0	0	0	0	15000
100	201407	10029	50	113	2	0	0	0	0	0	0	0	8050