Template009_InventoryWaterfallChart1.0.xlsx

	B	C	D	E	F	G	H	J	K	L
1
2	Inventory Value In-Out Monitoring by Waterfall Chart
3
4	Monthly
5
6		In	Out	Net Flow	On Hand	Down	Up	In	Out	End
7	START			100000		0	100000	100000
8	January	150000	50000	200000	100000	0	200000	200000
9	February	1000	-700	300	300000	0	300	300
10	March	1500	-1200	300	300300	0	300	300
11	April	900	-500	400	300600	0	400	400
12	May	300	-800	-500	300500	500	0		500
13	June	600	-1000	-400	300100	400	0		400
14	July	1100	-1600	-500	299600	500	0		500
15	August	1500	-700	800	299600	0	800	800
16	September	1300	-1100	200	300400	0	200	200
17	October	900	-500	400	300600	0	400	400
18	November	500	-1500	-1000	300000	1000	0		1000
19	December	1800	-100	1700	300000	0	1700	1700
20	END				301700	0	0			301700
21
22	By วิศวกรสร้างภาพ
23	https://www.facebook.com/coachpbob
24	Version 1.0
25
26
27
28
29
30
31
32
33
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