Logistics Review

Through Effective Integrated Supply China Management



()
()

Contents
Why are we SCM existing? – KPIs of Inventory Control KPI
Why inventory control? “”
Where is the inventory?
How to do inventory control?
Why “more sales” could be “faster to bankrupt” ?
Why don’t we get the right parts on hand?
Why over-production is crime? “”
How are organized? – 3P – People / Process / Performance 3P
Case 1 - why did we lose this customer? 1
Case 2 – why customer is respecting us? 2
Case 3 – is this the right MPS loading ? – MPS
* / 17




Healthy …

Earning …


Where is inventory?
NORMAL inventory is the LINK of whole demand – supply chain …

ABnormal inventory is the output of ABnormal processes or ABnormally executed processes …


… …
Data Accuracy


Tsingtao Beer, Revenue increasing, EBIT/Net Income reducing … why??
…
…

Why don’t we get the right parts on hand?

The warehouse is FULL, but why I do not get the parts I need?

Over-production


Over-production is NOT only FG/Semi-FG but generate more inventory on raw materials …

Line Stop Strategy …

3P
Production Planning
Capacity / Scheduling
External Logistics


“”
“”“”


Chart2
Jan.
Jan.
Jan.
Jan.
Feb.
Feb.
Feb.
Feb.
Mar
Mar
Mar
Mar
Apr
Apr
Apr
Apr
May
May
May
May
Jun
Jun
Jun
Jun
Jul
Jul
Jul
Jul
Aug
Aug
Aug
Aug
Sep
Sep
Sep
Sep
Oct
Oct
Oct
Oct
Nov
Nov
Nov
Nov
Dec
Dec
Dec
Dec
Jan
Jan
Jan
Jan
Feb
Feb
Feb
Feb
Mar
Mar
Mar
Mar
Apr
Apr
Apr
Apr
May
May
May
May
Jun
Jun
Jun
Jun
Jul
Jul
Jul
Jul
Aug
Aug
Aug
Aug
Sep
Sep
Sep
Sep
Oct
Oct
Oct
Oct
F/C
PO
8478
DOS
14
1
Download the data from POS - daily sales of all POS by model
every Monday
Analyze the demand fluctuation / average demand with moving average - history
Standard deviation - stdev() / average ( 7 ~ 14 days?)
3
Calculate the buffer level for Semi-FG (ASY) by model per demand fluctuation
Buffer = normsinv(SL-95%) * stdev () * sqrt (repl. C/T)
4
Forecast (future 3 months) vs Actual sales (during last 3 months)
What's the GAP between
6
Repl critr
0
0
0
0
0
0
0
0
0
390
221
311
325
406
298
0
226
306
220
195
14
A
B
POS
D1
D2
D3
D4
D5
D6
D7
A
24
59
23
26
44
77
31
7
Customer's customer
Customer POS
2976
DOS
14

-
Model/Project:
mt
wk
07wk37
07wk38
07wk39
07wk40
07wk41
07wk42
07wk43
07wk44
07wk45
07wk46
07wk47
07wk48
07wk49
07wk50
07wk51
07wk52
08wk01
08wk02
08wk03
08wk04
08wk05
08wk06
08wk07
08wk08
08wk09
08wk10
08wk11
08wk12
08wk13
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
Forecast-FA
109,222
228,913
128,789
144,742
203,649
213,631
247,800
142,871
233,654
190,590
185,664
156,581
48,243
33,721
84,830
100,228
21,096
75,791
68,477
120,533
110,087
1
149,382
190,287
200,284
180,037
162,216
243,002
97,261
36,300
54,015
82,425
79,557
55,766
25,016
29,015
24,170
42,200
35,500
17,290
38,355
16,290
156,581
48,243
33,721
84,830
100,228
21,096
75,791
68,477
120,533
110,087
1
149,382
190,287
200,284
180,037
162,216
243,002
97,261
36,300
54,015
82,425
Forecast-SFG
41,707
51,053
78,774
61,614
77,596
94,803
92,056
62,326
72,409
68,976
77,580
52,123
51,984
57,397
58,404
37,081
20,160
33,539
56,545
69,209
55,616
0
76,912
55,947
27,267
71,147
77,553
56,057
0
0
81,796
27,526
9,481
231
0
27,293
63,368
26,916
12,033
47,375
60,793
46,767
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MPS
162,000
150,000
160,000
185,000
248,343
220,219
228,939
197,551
254,580
183,098
131,608
100,108
100,068
188,741
98,000
111,829
13,473
86,088
91,013
100,926
228,175
1
149,257
134,363
116,242
116,242
80,000
72,500
54,166
42,362
74,237
23,048
17,898
12,729
37,729
36,887
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Model/Project:
ml
wk
07wk37
07wk38
07wk39
07wk40
07wk41
07wk42
07wk43
07wk44
07wk45
07wk46
07wk47
07wk48
07wk49
07wk50
07wk51
07wk52
08wk01
08wk02
08wk03
08wk04
08wk05
08wk06
08wk07
08wk08
08wk09
08wk10
08wk11
08wk12
08wk13
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
09wk01
09wk02
09wk03
Forecast-FA
109,222
228,913
128,789
144,742
203,649
213,631
247,800
142,871
233,654
190,590
185,664
156,581
48,243
33,721
84,830
100,228
21,096
75,791
68,477
120,533
110,087
1
149,382
190,287
200,284
180,037
162,216
243,002
97,261
105,721
118,555
189,853
133,947
102,704
70,599
95,261
118,719
66,206
60,447
48,973
80,695
190,287
200,284
180,037
162,216
243,002
97,261
105,721
118,555
189,853
133,947
102,704
70,599
95,261
118,719
66,206
60,447
48,973
118,719
66,206
60,447
48,973
0
0
0
Forecast-SFG
109,222
228,913
128,789
144,742
203,649
213,631
247,800
142,871
233,654
190,590
185,664
156,581
48,243
33,721
88,863
90,452
31,056
88,306
71,597
122,397
112,067
0
141,555
190,725
90,911
67,393
200,560
187,644
173,380
129,808
83,552
63,922
106,756
75,903
63,858
77,493
23,067
12,730
53,728
72,718
76,497
85,094
84,476
57,477
55,907
72,390
72,392
67,041
59,941
58,776
58,767
58,776
45,323
36,374
34,917
34,920
35,026
36,726
38,680
38,835
37,453
35,001
35,001
25,001
2
2
2
1
0
0
0
MPS
162,000
150,000
160,000
185,000
248,343
220,219
228,939
197,551
254,580
183,098
131,608
100,108
100,068
188,741
98,000
111,829
13,473
86,088
91,013
100,926
228,175
1
149,257
134,363
116,242
116,242
163,846
157,480
160,320
82,516
160,758
204,348
78,756
60,143
49,484
57,233
126,865
106,150
112,914
124,000
17,976
32,046
64,679
75,150
73,594
106,411
59,572
67,089
36,163
91,700
92,016
72,274
71,885
60,473
64,324
45,008
13,742
16,724
0
0
0
0
0
0
0
0
0
0
0
0
0
vt
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-FA
MPS
Model/Project:
vt
Cat.
07wk37
07wk38
07wk39
07wk40
07wk41
07wk42
07wk43
07wk44
07wk45
07wk46
07wk47
07wk48
07wk49
07wk50
07wk51
07wk52
08wk01
08wk02
08wk03
08wk04
08wk05
08wk06
08wk07
08wk08
08wk09
08wk10
08wk11
08wk12
08wk13
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
09wk01
09wk02
09wk03
Forecast-FA
29,730
28,979
59,218
48,852
76,228
55,385
82,757
87,487
105,230
100,085
113,527
68,245
61,817
35,218
3,340
24,746
17,766
30,906
33,494
42,614
64,416
1
97,303
76,048
76,019
106,530
60,336
119,974
88,754
80,492
75,666
160,520
90,231
83,727
48,134
52,270
119,711
73,713
48,903
39,387
130,315
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-SFG
29,730
28,979
59,218
48,852
76,228
55,385
82,757
87,487
105,230
100,085
113,527
68,245
61,817
35,218
3,340
24,746
17,766
30,906
33,494
42,614
94,194
0
35,686
89,285
55,159
83,368
77,596
58,542
33,382
59,760
86,268
52,507
32,672
46,192
61,180
61,514
68,729
44,437
61,440
61,859
78,872
42,460
49,481
46,500
32,000
70,500
55,000
34,000
46,000
60,000
65,000
89,000
89,000
89,000
64,915
64,026
64,470
65,205
64,444
64,437
64,449
46,638
45,457
45,462
45,449
44,872
40,313
37205
37205
37764
41107
MPS
20,000
49,000
74,000
91,000
61,080
58,400
75,821
90,447
107,539
108,780
117,682
123,347
146,734
175,860
66,103
33,000
34,791
65,813
34,228
31,348
105,094
1
27,304
102,317
59,051
50,995
53,874
98,364
78,905
58,865
83,107
31,985
28,030
35,018
37,744
99,683
74,888
47,893
59,366
69,777
56,299
51,130
98,670
72,635
77,980
78,000
65,000
52,000
59,590
44,216
57,020
64,016
74,114
49,104
66,000
66,000
79,200
30,800
84,700
84,700
64,449
46,638
45,457
45,462
45,449
44,872
40,313
37205
37205
30257
41107
jh
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-FA
MPS
Model/Project:
jh
Cat.
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
09wk01
09wk02
09wk03
09wk04
09wk05
09wk06
09wk07
09wk08
09wk09
09wk10
09wk11
09wk12
09wk13
09wk14
09wk15
09wk16
09wk17
09wk18
09wk19
09wk20
09wk21
09wk22
09wk23
09wk24
09wk25
09wk26
Forecast-FA
4,500
15,000
29,910
39,885
46,074
158,994
92,938
237,414
173,481
167,135
133,882
148,513
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-SFG
0
0
20,586
45,190
31,256
38,773
121,763
97,707
154,786
156,354
187,332
154,458
62,700
112,511
105,000
189,000
256,000
180,001
190,000
195,747
194,661
179,278
159,664
181,130
220,333
222,888
222,880
216,913
193,772
169,086
169,080
169,085
139,363
120,299
100,295
100,291
97,375
64,729
64,419
104,329
105,140
110,933
116,647
116,670
116,795
116,748
111,058
111,053
111,059
82,634
30,136
13,680
13,675
13,472
13,012
12,747
12,745
12,740
14,825
16,909
16,907
16,907
16,900
8,851
1,610
0
MPS
0
0
0
549
15,000
78,800
139,595
158,812
185,105
182,749
181,325
69,837
102,490
108,633
152,069
229,363
256,001
180,000
40,000
175,747
204,661
199,278
219,664
201,130
205,333
202,888
222,880
236,913
233,772
204,086
169,080
169,085
139,363
120,299
100,295
100,291
97,375
64,729
64,419
104,329
105,140
110,933
PLC MTT2
Model/Project:
Cat.
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
Forecast-special
121,521
102,906
114,502
96,063
104,842
139,799
84,074
73,995
115,106
55,918
37,500
90,941
25,000
56,471
30,405
65,906
40,537
43,779
12,500
17,500
5,000
0
0
0
0
0
0
0
0
0
0
0
0
DMN00515: SEMC consign part shortage---welcome card.
DMN00515: Custom request hold the 832E22468/10 -2940pcs(shortage user guide, customer consign part. no schedule)
DMN00515: Flip material shortage as supplier decommit
DMN00515: Flip material shortage
FV jh
Coefficeint:
82,743
190,606
217,460
78,700
158,133
256,115
284,362
252,984
255,168
321,211
299,769
177,246
125,637
89,119
112,728
125,103
73,773
89,144
145,789
131,115
178,474
2
101,905
231,949
161,770
238,452
211,734
240,639
219,731
94,746
103,229
153,077
161,999
114,812
93,796
116,148
189,288
99,302
128,864
126,381
117,451
128,058
103,031
114,106
74,517
157,933
46,340
54,075
19,645
3,877
11,347
12,283
20,526
12,680
10,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
mt
55,550
72,705
57,535
8,835
82,855
68,950
123,282
66,810
47,615
40,525
70,235
110,780
47,920
32,225
53,835
68,250
19,820
16,968
55,122
104,670
58,580
1
53,870
84,479
51,205
56,156
45,782
88,795
8,300
2,595
15,184
72,916
11,225
9,820
10,760
5,054
56,885
33,145
14,070
23,685
8,730
25,500
22,750
9,500
20,840
31,025
20,000
3,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ml
79,644
178,536
178,536
53,080
112,614
183,391
203,180
171,837
169,127
198,935
191,750
124,383
73,661
70,215
82,895
64,455
52,508
48,368
112,327
98,860
126,811
1
62,635
176,450
88,460
139,708
135,160
180,111
164,895
51,911
48,835
81,822
106,943
66,211
42,480
60,711
110,427
51,410
73,345
72,585
37,005
53,403
55,697
69,891
43,880
82,455
12,130
10,285
12,695
1,123
345
2,183
10,426
2,680
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
vt
3,099
12,070
38,924
25,620
45,519
72,724
81,182
81,147
86,041
122,276
108,019
52,863
51,976
18,904
29,833
60,648
21,265
40,776
33,462
32,255
51,663
1
39,270
55,499
73,310
98,744
76,574
60,528
54,836
42,835
54,394
71,255
55,056
48,601
51,316
55,437
78,861
47,892
55,519
53,796
80,446
74,655
47,334
44,215
30,637
75,478
34,210
43,790
6,950
2,754
11,002
10,100
10,100
10,000
10,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
jh
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,039
9,852
26,929
19,605
86,476
107,177
127,792
120,960
150,595
97,311
74,186
46,286
73,370
82,944
86,607
30,965
16,125
5,295
1,760
0
800
0
495
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,039
9,852
26,929
19,605
86,476
107,177
127,792
120,960
150,595
97,311
74,186
46,286
73,370
82,944
86,607
0
0
0
0
WithNPI
WithNPI
w37
w37
w37
w37
w38
w38
w38
w38
w39
w39
w39
w39
w40
w40
w40
w40
w41
w41
w41
w41
w42
w42
w42
w42
w43
w43
w43
w43
w44
w44
w44
w44
w45
w45
w45
w45
w46
w46
w46
w46
w47
w47
w47
w47
w48
w48
w48
w48
w49
w49
w49
w49
w50
w50
w50
w50
w51
w51
w51
w51
w52
w52
w52
w52
w1
w1
w1
w1
w2
w2
w2
w2
w3
w3
w3
w3
w4
w4
w4
w4
w5
w5
w5
w5
w6
w6
w6
w6
w7
w7
w7
w7
w8
w8
w8
w8
w9
w9
w9
w9
w10
w10
w10
w10
w11
w11
w11
w11
w12
w12
w12
w12
w13
w13
w13
w13
w14
w14
w14
w14
w15
w15
w15
w15
w16
w16
w16
w16
w17
w17
w17
w17
w18
w18
w18
w18
w19
w19
w19
w19
w20
w20
w20
w20
w21
w21
w21
w21
w22
w22
w22
w22
w23
w23
w23
w23
w24
w24
w24
w24
w25
w25
w25
w25
w26
w26
w26
w26
w27
w27
w27
w27
w28
w28
w28
w28
w29
w29
w29
w29
w30
w30
w30
w30
w31
w31
w31
w31
w32
w32
w32
w32
w33
w33
w33
w33
w34
w34
w34
w34
w35
w35
w35
w35
w36
w36
w36
w36
w37
w37
w37
w37
w38
w38
w38
w38
w39
w39
w39
w39
w40
w40
w40
w40
w41
w41
w41
w41
w42
w42
w42
w42
w43
w43
w43
w43
w44
w44
w44
w44
w45
w45
w45
w45
w46
w46
w46
w46
w47
w47
w47
w47
w48
w48
w48
w48
w49
w49
w49
w49
w50
w50
w50
w50
w51
w51
w51
w51
w52
w52
w52
w52
- Mostly up & down together - Curves are quite similar - More than 0.6 coeficient
mt
ml
vt
jh
55550
79644
3099
0
72705
178536
12070
0
57535
178536
38924
0
8835
53080
25620
0
82855
112614
45519
0
68950
183391
72724
0
123282
203180
81182
0
66810
171837
81147
0
47615
169127
86041
0
40525
198935
122276
0
70235
191750
108019
0
110780
124383
52863
0
47920
73661
51976
0
32225
70215
18904
0
53835
82895
29833
0
68250
64455
60648
0
19820
52508
21265
0
16968
48368
40776
0
55122
112327
33462
0
104670
98860
32255
0
58580
126811
51663
0
1
1
1
0
53870
62635
39270
0
84479
176450
55499
0
51205
88460
73310
0
56156
139708
98744
0
45782
135160
76574
0
88795
180111
60528
0
8300
164895
54836
0
2595
51911
42835
0
15184
48835
54394
0
72916
81822
71255
2039
11225
106943
55056
9852
9820
66211
48601
26929
10760
42480
51316
19605
5054
60711
55437
86476
56885
110427
78861
107177
33145
51410
47892
127792
14070
73345
55519
120960
23685
72585
53796
150595
8730
37005
80446
97311
25500
53403
74655
74186
22750
55697
47334
46286
9500
69891
44215
73370
20840
43880
30637
82944
31025
82455
75478
86607
20000
12130
34210
30965
3000
10285
43790
16125
0
12695
6950
5295
0
1123
2754
1760
0
345
11002
0
0
2183
10100
800
0
10426
10100
0
0
2680
10000
495
0
0
10000
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NoNPI
NoNPI
w37
w37
w37
w37
w37
w38
w38
w38
w38
w38
w39
w39
w39
w39
w39
w40
w40
w40
w40
w40
w41
w41
w41
w41
w41
w42
w42
w42
w42
w42
w43
w43
w43
w43
w43
w44
w44
w44
w44
w44
w45
w45
w45
w45
w45
w46
w46
w46
w46
w46
w47
w47
w47
w47
w47
w48
w48
w48
w48
w48
w49
w49
w49
w49
w49
w50
w50
w50
w50
w50
w51
w51
w51
w51
w51
w52
w52
w52
w52
w52
w1
w1
w1
w1
w1
w2
w2
w2
w2
w2
w3
w3
w3
w3
w3
w4
w4
w4
w4
w4
w5
w5
w5
w5
w5
w6
w6
w6
w6
w6
w7
w7
w7
w7
w7
w8
w8
w8
w8
w8
w9
w9
w9
w9
w9
w10
w10
w10
w10
w10
w11
w11
w11
w11
w11
w12
w12
w12
w12
w12
w13
w13
w13
w13
w13
w14
w14
w14
w14
w14
w15
w15
w15
w15
w15
w16
w16
w16
w16
w16
w17
w17
w17
w17
w17
w18
w18
w18
w18
w18
w19
w19
w19
w19
w19
w20
w20
w20
w20
w20
w21
w21
w21
w21
w21
w22
w22
w22
w22
w22
w23
w23
w23
w23
w23
w24
w24
w24
w24
w24
w25
w25
w25
w25
w25
w26
w26
w26
w26
w26
w27
w27
w27
w27
w27
w28
w28
w28
w28
w28
w29
w29
w29
w29
w29
w30
w30
w30
w30
w30
w31
w31
w31
w31
w31
w32
w32
w32
w32
w32
w33
w33
w33
w33
w33
w34
w34
w34
w34
w34
w35
w35
w35
w35
w35
w36
w36
w36
w36
w36
w37
w37
w37
w37
w37
w38
w38
w38
w38
w38
w39
w39
w39
w39
w39
w40
w40
w40
w40
w40
w41
w41
w41
w41
w41
w42
w42
w42
w42
w42
w43
w43
w43
w43
w43
w44
w44
w44
w44
w44
w45
w45
w45
w45
w45
w46
w46
w46
w46
w46
w47
w47
w47
w47
w47
w48
w48
w48
w48
w48
w49
w49
w49
w49
w49
w50
w50
w50
w50
w50
w51
w51
w51
w51
w51
w52
w52
w52
w52
w52
Reason for new peak is because of NPI
- 10 weeks ramp up roughly - 10 weeks peak - PS1 roughly also
Tot with NPI
Tot wo NPI
Peak S1 is wk38 to wk 48
Peak S2 is wk8 to wk 14, BUT lower than PS1
After Peak, usually 50 - 100 k per week - old models
Chart1
w37
w37
w37
w37
w38
w38
w38
w38
w39
w39
w39
w39
w40
w40
w40
w40
w41
w41
w41
w41
w42
w42
w42
w42
w43
w43
w43
w43
w44
w44
w44
w44
w45
w45
w45
w45
w46
w46
w46
w46
w47
w47
w47
w47
w48
w48
w48
w48
w49
w49
w49
w49
w50
w50
w50
w50
w51
w51
w51
w51
w52
w52
w52
w52
w1
w1
w1
w1
w2
w2
w2
w2
w3
w3
w3
w3
w4
w4
w4
w4
w5
w5
w5
w5
w6
w6
w6
w6
w7
w7
w7
w7
w8
w8
w8
w8
w9
w9
w9
w9
w10
w10
w10
w10
w11
w11
w11
w11
w12
w12
w12
w12
w13
w13
w13
w13
w14
w14
w14
w14
w15
w15
w15
w15
w16
w16
w16
w16
w17
w17
w17
w17
w18
w18
w18
w18
w19
w19
w19
w19
w20
w20
w20
w20
w21
w21
w21
w21
w22
w22
w22
w22
w23
w23
w23
w23
w24
w24
w24
w24
w25
w25
w25
w25
w26
w26
w26
w26
w27
w27
w27
w27
w28
w28
w28
w28
w29
w29
w29
w29
w30
w30
w30
w30
w31
w31
w31
w31
w32
w32
w32
w32
w33
w33
w33
w33
w34
w34
w34
w34
w35
w35
w35
w35
w36
w36
w36
w36
w37
w37
w37
w37
w38
w38
w38
w38
w39
w39
w39
w39
w40
w40
w40
w40
w41
w41
w41
w41
w42
w42
w42
w42
w43
w43
w43
w43
w44
w44
w44
w44
w45
w45
w45
w45
w46
w46
w46
w46
w47
w47
w47
w47
w48
w48
w48
w48
w49
w49
w49
w49
w50
w50
w50
w50
w51
w51
w51
w51
w52
w52
w52
w52
- Mostly up & down together - Curves are quite similar - More than 0.6 coeficient
mt
ml
vt
jh
55550
79644
3099
0
72705
178536
12070
0
57535
178536
38924
0
8835
53080
25620
0
82855
112614
45519
0
68950
183391
72724
0
123282
203180
81182
0
66810
171837
81147
0
47615
169127
86041
0
40525
198935
122276
0
70235
191750
108019
0
110780
124383
52863
0
47920
73661
51976
0
32225
70215
18904
0
53835
82895
29833
0
68250
64455
60648
0
19820
52508
21265
0
16968
48368
40776
0
55122
112327
33462
0
104670
98860
32255
0
58580
126811
51663
0
1
1
1
0
53870
62635
39270
0
84479
176450
55499
0
51205
88460
73310
0
56156
139708
98744
0
45782
135160
76574
0
88795
180111
60528
0
8300
164895
54836
0
2595
51911
42835
0
15184
48835
54394
0
72916
81822
71255
2039
11225
106943
55056
9852
9820
66211
48601
26929
10760
42480
51316
19605
5054
60711
55437
86476
56885
110427
78861
107177
33145
51410
47892
127792
14070
73345
55519
120960
23685
72585
53796
150595
8730
37005
80446
97311
25500
53403
74655
74186
22750
55697
47334
46286
9500
69891
44215
73370
20840
43880
30637
82944
31025
82455
75478
86607
20000
12130
34210
30965
3000
10285
43790
16125
0
12695
6950
5295
0
1123
2754
1760
0
345
11002
0
0
2183
10100
800
0
10426
10100
0
0
2680
10000
495
0
0
10000
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Model/Project:
mt
wk
07wk37
07wk38
07wk39
07wk40
07wk41
07wk42
07wk43
07wk44
07wk45
07wk46
07wk47
07wk48
07wk49
07wk50
07wk51
07wk52
08wk01
08wk02
08wk03
08wk04
08wk05
08wk06
08wk07
08wk08
08wk09
08wk10
08wk11
08wk12
08wk13
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
Forecast-FA
109,222
228,913
128,789
144,742
203,649
213,631
247,800
142,871
233,654
190,590
185,664
156,581
48,243
33,721
84,830
100,228
21,096
75,791
68,477
120,533
110,087
1
149,382
190,287
200,284
180,037
162,216
243,002
97,261
36,300
54,015
82,425
79,557
55,766
25,016
29,015
24,170
42,200
35,500
17,290
38,355
16,290
156,581
48,243
33,721
84,830
100,228
21,096
75,791
68,477
120,533
110,087
1
149,382
190,287
200,284
180,037
162,216
243,002
97,261
36,300
54,015
82,425
Forecast-SFG
41,707
51,053
78,774
61,614
77,596
94,803
92,056
62,326
72,409
68,976
77,580
52,123
51,984
57,397
58,404
37,081
20,160
33,539
56,545
69,209
55,616
0
76,912
55,947
27,267
71,147
77,553
56,057
0
0
81,796
27,526
9,481
231
0
27,293
63,368
26,916
12,033
47,375
60,793
46,767
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MPS
162,000
150,000
160,000
185,000
248,343
220,219
228,939
197,551
254,580
183,098
131,608
100,108
100,068
188,741
98,000
111,829
13,473
86,088
91,013
100,926
228,175
1
149,257
134,363
116,242
116,242
80,000
72,500
54,166
42,362
74,237
23,048
17,898
12,729
37,729
36,887
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Model/Project:
ml
wk
07wk37
07wk38
07wk39
07wk40
07wk41
07wk42
07wk43
07wk44
07wk45
07wk46
07wk47
07wk48
07wk49
07wk50
07wk51
07wk52
08wk01
08wk02
08wk03
08wk04
08wk05
08wk06
08wk07
08wk08
08wk09
08wk10
08wk11
08wk12
08wk13
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
09wk01
09wk02
09wk03
Forecast-FA
109,222
228,913
128,789
144,742
203,649
213,631
247,800
142,871
233,654
190,590
185,664
156,581
48,243
33,721
84,830
100,228
21,096
75,791
68,477
120,533
110,087
1
149,382
190,287
200,284
180,037
162,216
243,002
97,261
105,721
118,555
189,853
133,947
102,704
70,599
95,261
118,719
66,206
60,447
48,973
80,695
190,287
200,284
180,037
162,216
243,002
97,261
105,721
118,555
189,853
133,947
102,704
70,599
95,261
118,719
66,206
60,447
48,973
118,719
66,206
60,447
48,973
0
0
0
Forecast-SFG
109,222
228,913
128,789
144,742
203,649
213,631
247,800
142,871
233,654
190,590
185,664
156,581
48,243
33,721
88,863
90,452
31,056
88,306
71,597
122,397
112,067
0
141,555
190,725
90,911
67,393
200,560
187,644
173,380
129,808
83,552
63,922
106,756
75,903
63,858
77,493
23,067
12,730
53,728
72,718
76,497
85,094
84,476
57,477
55,907
72,390
72,392
67,041
59,941
58,776
58,767
58,776
45,323
36,374
34,917
34,920
35,026
36,726
38,680
38,835
37,453
35,001
35,001
25,001
2
2
2
1
0
0
0
MPS
162,000
150,000
160,000
185,000
248,343
220,219
228,939
197,551
254,580
183,098
131,608
100,108
100,068
188,741
98,000
111,829
13,473
86,088
91,013
100,926
228,175
1
149,257
134,363
116,242
116,242
163,846
157,480
160,320
82,516
160,758
204,348
78,756
60,143
49,484
57,233
126,865
106,150
112,914
124,000
17,976
32,046
64,679
75,150
73,594
106,411
59,572
67,089
36,163
91,700
92,016
72,274
71,885
60,473
64,324
45,008
13,742
16,724
0
0
0
0
0
0
0
0
0
0
0
0
0
vt
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-FA
MPS
Model/Project:
vt
Cat.
07wk37
07wk38
07wk39
07wk40
07wk41
07wk42
07wk43
07wk44
07wk45
07wk46
07wk47
07wk48
07wk49
07wk50
07wk51
07wk52
08wk01
08wk02
08wk03
08wk04
08wk05
08wk06
08wk07
08wk08
08wk09
08wk10
08wk11
08wk12
08wk13
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
09wk01
09wk02
09wk03
Forecast-FA
29,730
28,979
59,218
48,852
76,228
55,385
82,757
87,487
105,230
100,085
113,527
68,245
61,817
35,218
3,340
24,746
17,766
30,906
33,494
42,614
64,416
1
97,303
76,048
76,019
106,530
60,336
119,974
88,754
80,492
75,666
160,520
90,231
83,727
48,134
52,270
119,711
73,713
48,903
39,387
130,315
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-SFG
29,730
28,979
59,218
48,852
76,228
55,385
82,757
87,487
105,230
100,085
113,527
68,245
61,817
35,218
3,340
24,746
17,766
30,906
33,494
42,614
94,194
0
35,686
89,285
55,159
83,368
77,596
58,542
33,382
59,760
86,268
52,507
32,672
46,192
61,180
61,514
68,729
44,437
61,440
61,859
78,872
42,460
49,481
46,500
32,000
70,500
55,000
34,000
46,000
60,000
65,000
89,000
89,000
89,000
64,915
64,026
64,470
65,205
64,444
64,437
64,449
46,638
45,457
45,462
45,449
44,872
40,313
37205
37205
37764
41107
MPS
20,000
49,000
74,000
91,000
61,080
58,400
75,821
90,447
107,539
108,780
117,682
123,347
146,734
175,860
66,103
33,000
34,791
65,813
34,228
31,348
105,094
1
27,304
102,317
59,051
50,995
53,874
98,364
78,905
58,865
83,107
31,985
28,030
35,018
37,744
99,683
74,888
47,893
59,366
69,777
56,299
51,130
98,670
72,635
77,980
78,000
65,000
52,000
59,590
44,216
57,020
64,016
74,114
49,104
66,000
66,000
79,200
30,800
84,700
84,700
64,449
46,638
45,457
45,462
45,449
44,872
40,313
37205
37205
30257
41107
jh
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-FA
MPS
Model/Project:
jh
Cat.
08wk14
08wk15
08wk16
08wk17
08wk18
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
09wk01
09wk02
09wk03
09wk04
09wk05
09wk06
09wk07
09wk08
09wk09
09wk10
09wk11
09wk12
09wk13
09wk14
09wk15
09wk16
09wk17
09wk18
09wk19
09wk20
09wk21
09wk22
09wk23
09wk24
09wk25
09wk26
Forecast-FA
4,500
15,000
29,910
39,885
46,074
158,994
92,938
237,414
173,481
167,135
133,882
148,513
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Forecast-SFG
0
0
20,586
45,190
31,256
38,773
121,763
97,707
154,786
156,354
187,332
154,458
62,700
112,511
105,000
189,000
256,000
180,001
190,000
195,747
194,661
179,278
159,664
181,130
220,333
222,888
222,880
216,913
193,772
169,086
169,080
169,085
139,363
120,299
100,295
100,291
97,375
64,729
64,419
104,329
105,140
110,933
116,647
116,670
116,795
116,748
111,058
111,053
111,059
82,634
30,136
13,680
13,675
13,472
13,012
12,747
12,745
12,740
14,825
16,909
16,907
16,907
16,900
8,851
1,610
0
MPS
0
0
0
549
15,000
78,800
139,595
158,812
185,105
182,749
181,325
69,837
102,490
108,633
152,069
229,363
256,001
180,000
40,000
175,747
204,661
199,278
219,664
201,130
205,333
202,888
222,880
236,913
233,772
204,086
169,080
169,085
139,363
120,299
100,295
100,291
97,375
64,729
64,419
104,329
105,140
110,933
PLC MTT2
Model/Project:
Cat.
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
Forecast-special
121,521
102,906
114,502
96,063
104,842
139,799
84,074
73,995
115,106
55,918
37,500
90,941
25,000
56,471
30,405
65,906
40,537
43,779
12,500
17,500
5,000
0
0
0
0
0
0
0
0
0
0
0
0
DMN00515: SEMC consign part shortage---welcome card.
DMN00515: Custom request hold the 832E22468/10 -2940pcs(shortage user guide, customer consign part. no schedule)
DMN00515: Flip material shortage as supplier decommit
DMN00515: Flip material shortage
FV jh
Coefficeint:
82,743
190,606
217,460
78,700
158,133
256,115
284,362
252,984
255,168
321,211
299,769
177,246
125,637
89,119
112,728
125,103
73,773
89,144
145,789
131,115
178,474
2
101,905
231,949
161,770
238,452
211,734
240,639
219,731
94,746
103,229
153,077
161,999
114,812
93,796
116,148
189,288
99,302
128,864
126,381
117,451
128,058
103,031
114,106
74,517
157,933
46,340
54,075
19,645
3,877
11,347
12,283
20,526
12,680
10,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
mt
55,550
72,705
57,535
8,835
82,855
68,950
123,282
66,810
47,615
40,525
70,235
110,780
47,920
32,225
53,835
68,250
19,820
16,968
55,122
104,670
58,580
1
53,870
84,479
51,205
56,156
45,782
88,795
8,300
2,595
15,184
72,916
11,225
9,820
10,760
5,054
56,885
33,145
14,070
23,685
8,730
25,500
22,750
9,500
20,840
31,025
20,000
3,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ml
79,644
178,536
178,536
53,080
112,614
183,391
203,180
171,837
169,127
198,935
191,750
124,383
73,661
70,215
82,895
64,455
52,508
48,368
112,327
98,860
126,811
1
62,635
176,450
88,460
139,708
135,160
180,111
164,895
51,911
48,835
81,822
106,943
66,211
42,480
60,711
110,427
51,410
73,345
72,585
37,005
53,403
55,697
69,891
43,880
82,455
12,130
10,285
12,695
1,123
345
2,183
10,426
2,680
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
vt
3,099
12,070
38,924
25,620
45,519
72,724
81,182
81,147
86,041
122,276
108,019
52,863
51,976
18,904
29,833
60,648
21,265
40,776
33,462
32,255
51,663
1
39,270
55,499
73,310
98,744
76,574
60,528
54,836
42,835
54,394
71,255
55,056
48,601
51,316
55,437
78,861
47,892
55,519
53,796
80,446
74,655
47,334
44,215
30,637
75,478
34,210
43,790
6,950
2,754
11,002
10,100
10,100
10,000
10,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
jh
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,039
9,852
26,929
19,605
86,476
107,177
127,792
120,960
150,595
97,311
74,186
46,286
73,370
82,944
86,607
30,965
16,125
5,295
1,760
0
800
0
495
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,039
9,852
26,929
19,605
86,476
107,177
127,792
120,960
150,595
97,311
74,186
46,286
73,370
82,944
86,607
0
0
0
0
WithNPI
WithNPI
w37
w37
w37
w37
w38
w38
w38
w38
w39
w39
w39
w39
w40
w40
w40
w40
w41
w41
w41
w41
w42
w42
w42
w42
w43
w43
w43
w43
w44
w44
w44
w44
w45
w45
w45
w45
w46
w46
w46
w46
w47
w47
w47
w47
w48
w48
w48
w48
w49
w49
w49
w49
w50
w50
w50
w50
w51
w51
w51
w51
w52
w52
w52
w52
w1
w1
w1
w1
w2
w2
w2
w2
w3
w3
w3
w3
w4
w4
w4
w4
w5
w5
w5
w5
w6
w6
w6
w6
w7
w7
w7
w7
w8
w8
w8
w8
w9
w9
w9
w9
w10
w10
w10
w10
w11
w11
w11
w11
w12
w12
w12
w12
w13
w13
w13
w13
w14
w14
w14
w14
w15
w15
w15
w15
w16
w16
w16
w16
w17
w17
w17
w17
w18
w18
w18
w18
w19
w19
w19
w19
w20
w20
w20
w20
w21
w21
w21
w21
w22
w22
w22
w22
w23
w23
w23
w23
w24
w24
w24
w24
w25
w25
w25
w25
w26
w26
w26
w26
w27
w27
w27
w27
w28
w28
w28
w28
w29
w29
w29
w29
w30
w30
w30
w30
w31
w31
w31
w31
w32
w32
w32
w32
w33
w33
w33
w33
w34
w34
w34
w34
w35
w35
w35
w35
w36
w36
w36
w36
w37
w37
w37
w37
w38
w38
w38
w38
w39
w39
w39
w39
w40
w40
w40
w40
w41
w41
w41
w41
w42
w42
w42
w42
w43
w43
w43
w43
w44
w44
w44
w44
w45
w45
w45
w45
w46
w46
w46
w46
w47
w47
w47
w47
w48
w48
w48
w48
w49
w49
w49
w49
w50
w50
w50
w50
w51
w51
w51
w51
w52
w52
w52
w52
- Mostly up & down together - Curves are quite similar - More than 0.6 coeficient
mt
ml
vt
jh
55550
79644
3099
0
72705
178536
12070
0
57535
178536
38924
0
8835
53080
25620
0
82855
112614
45519
0
68950
183391
72724
0
123282
203180
81182
0
66810
171837
81147
0
47615
169127
86041
0
40525
198935
122276
0
70235
191750
108019
0
110780
124383
52863
0
47920
73661
51976
0
32225
70215
18904
0
53835
82895
29833
0
68250
64455
60648
0
19820
52508
21265
0
16968
48368
40776
0
55122
112327
33462
0
104670
98860
32255
0
58580
126811
51663
0
1
1
1
0
53870
62635
39270
0
84479
176450
55499
0
51205
88460
73310
0
56156
139708
98744
0
45782
135160
76574
0
88795
180111
60528
0
8300
164895
54836
0
2595
51911
42835
0
15184
48835
54394
0
72916
81822
71255
2039
11225
106943
55056
9852
9820
66211
48601
26929
10760
42480
51316
19605
5054
60711
55437
86476
56885
110427
78861
107177
33145
51410
47892
127792
14070
73345
55519
120960
23685
72585
53796
150595
8730
37005
80446
97311
25500
53403
74655
74186
22750
55697
47334
46286
9500
69891
44215
73370
20840
43880
30637
82944
31025
82455
75478
86607
20000
12130
34210
30965
3000
10285
43790
16125
0
12695
6950
5295
0
1123
2754
1760
0
345
11002
0
0
2183
10100
800
0
10426
10100
0
0
2680
10000
495
0
0
10000
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NoNPI
NoNPI
w37
w37
w37
w37
w37
w38
w38
w38
w38
w38
w39
w39
w39
w39
w39
w40
w40
w40
w40
w40
w41
w41
w41
w41
w41
w42
w42
w42
w42
w42
w43
w43
w43
w43
w43
w44
w44
w44
w44
w44
w45
w45
w45
w45
w45
w46
w46
w46
w46
w46
w47
w47
w47
w47
w47
w48
w48
w48
w48
w48
w49
w49
w49
w49
w49
w50
w50
w50
w50
w50
w51
w51
w51
w51
w51
w52
w52
w52
w52
w52
w1
w1
w1
w1
w1
w2
w2
w2
w2
w2
w3
w3
w3
w3
w3
w4
w4
w4
w4
w4
w5
w5
w5
w5
w5
w6
w6
w6
w6
w6
w7
w7
w7
w7
w7
w8
w8
w8
w8
w8
w9
w9
w9
w9
w9
w10
w10
w10
w10
w10
w11
w11
w11
w11
w11
w12
w12
w12
w12
w12
w13
w13
w13
w13
w13
w14
w14
w14
w14
w14
w15
w15
w15
w15
w15
w16
w16
w16
w16
w16
w17
w17
w17
w17
w17
w18
w18
w18
w18
w18
w19
w19
w19
w19
w19
w20
w20
w20
w20
w20
w21
w21
w21
w21
w21
w22
w22
w22
w22
w22
w23
w23
w23
w23
w23
w24
w24
w24
w24
w24
w25
w25
w25
w25
w25
w26
w26
w26
w26
w26
w27
w27
w27
w27
w27
w28
w28
w28
w28
w28
w29
w29
w29
w29
w29
w30
w30
w30
w30
w30
w31
w31
w31
w31
w31
w32
w32
w32
w32
w32
w33
w33
w33
w33
w33
w34
w34
w34
w34
w34
w35
w35
w35
w35
w35
w36
w36
w36
w36
w36
w37
w37
w37
w37
w37
w38
w38
w38
w38
w38
w39
w39
w39
w39
w39
w40
w40
w40
w40
w40
w41
w41
w41
w41
w41
w42
w42
w42
w42
w42
w43
w43
w43
w43
w43
w44
w44
w44
w44
w44
w45
w45
w45
w45
w45
w46
w46
w46
w46
w46
w47
w47
w47
w47
w47
w48
w48
w48
w48
w48
w49
w49
w49
w49
w49
w50
w50
w50
w50
w50
w51
w51
w51
w51
w51
w52
w52
w52
w52
w52
Reason for new peak is because of NPI
- 10 weeks ramp up roughly - 10 weeks peak - PS1 roughly also
Tot with NPI
Tot wo NPI
Peak S1 is wk38 to wk 48
Peak S2 is wk8 to wk 14, BUT lower than PS1
After Peak, usually 50 - 100 k per week - old models
* / 17



We reduced the buffer – Semi-FG from 14 days to 2 days
14DOS2

PO
7154
DOS
14
1
Download the data from POS - daily sales of all POS by model
every Monday
Analyze the demand fluctuation / average demand with moving average - history
Standard deviation - stdev() / average ( 7 ~ 14 days?)
3
Calculate the buffer level for Semi-FG (ASY) by model per demand fluctuation
Buffer = normsinv(SL-95%) * stdev () * sqrt (repl. C/T)
4
Forecast (future 3 months) vs Actual sales (during last 3 months)
What's the GAP between
6
Repl critr
0
0
0
0
0
0
0
0
0
303
198
65
203
329
306
342
239
263
272
251
14
A
B
POS
D1
D2
D3
D4
D5
D6
D7
A
43
90
60
25
76
77
76
7
Customer's customer
Customer POS
2362
DOS
14

Very clear this product has weekly consumption around 50 ~ 60k and monthly around 200k … very stable …
EXXX (adapter product) – Product Life Cycle – is this the RIGHT MPS loading?
– MPS
E & O …
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
Note:
MPS - weekly update
DEL-VP-09500039-000-038
19,122
840
2,940
2,110
675
4,211
288
3,153
2,348
60
17,524
6,440
25,976
28,000
0
0
0
0
25
20
3,169
35,786
16
64,984
0
0
5,258
5,271
38
50,433
14,000
14,000
0
0
0
19,000
0
0
0
12,000
0
0
0
9,000
0
0
0
10,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DEL-VP-09500039-100-038
18,022
75,006
46,593
44,361
60,182
34,020
42,845
56,282
105,853
17,010
9,450
33,605
133,935
307,000
0
0
0
0
30,475
50,203
50,820
80,502
1,470
81,600
81,600
107,330
33,946
46,956
43,182
257,916
105,000
115,000
0
105,000
60,000
60,000
60,000
60,000
10,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
0
50,000
50,000
50,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
37,144
75,846
49,533
46,471
60,857
38,231
43,133
59,435
108,201
17,070
26,974
40,045
159,911
335,000
0
0
0
0
30,500
50,223
53,989
116,288
1,486
146,584
81,600
107,330
39,204
52,227
43,220
308,349
119,000
129,000
0
105,000
60,000
79,000
60,000
60,000
10,000
62,000
50,000
50,000
50,000
59,000
50,000
50,000
0
60,000
50,000
50,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DEL-VP-09500039-200-011
0
10,035
6,580
3,034
3,772
0
0
0
0
0
153
0
197
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DEL-VP-09500039-300-008
0
10,035
6,580
3,034
3,772
0
0
0
0
0
143
0
257
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
20,070
13,160
6,068
7,544
0
0
0
0
0
296
0
454
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
E130W
DEL-VP-09500042-000-030
0
2,851
270
1,412
281
0
0
0
5,000
3,799
1,400
0
4,801
14,000
0
0
0
0
0
0
0
5,000
2,289
12,711
0
0
0
1,075
3,375
10,550
0
12,000
0
0
5,000
0
0
0
0
6,000
0
0
0
4,000
0
0
0
0
5,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
donfcaze: base on due date -9"need date"
donfcaze: WO Balance
donfcaze: 3 wk balance
DEL-VP-09500039-000-038
6700
3300
0
0
0
0
24000
0
0
20839
15000
0
0
0
20000
18000
0
0
0
4211
5789
0
0
60
13000
15940
0
29021
0
0
0
0
25
20
3169
35786
65000
5258
5271
38
50433
14000
14000
0
0
0
19000
0
0
0
12000
0
0
0
9000
0
0
0
10000
0
0
0
0
DEL-VP-09500039-100-038
0
170000
160000
145110
0
102480
100000
90000
11520
134644
80000
80000
74000
70000
70000
65000
50000
50000
15000
34020
105980
60000
47000
17010
52990
124000
0
87848
70000
70000
80450
0
30475
50203
50820
80502
81600
81600
54400
54400
33946
46956
43182
257916
105000
115000
0
105000
60000
60000
60000
60000
10000
50000
50000
50000
50000
50000
50000
50000
0
50000
50000
50000
0
0
DEL-VP-09500039-200-012
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
20000
0
0
0
0
0
0
0
0
10000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DEL-VP-09500039-300-009
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
40000
40000
0
0
0
0
0
0
0
20000
20000
32000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
donfcaze: WO Balance
donfcaze: turn in
donfcaze: turn in
donfcaze: turn in
donfcaze: WO Balance
donfcaze: 2 wk turn in
donfcaze: use Load sys qty- total =WO turn in qty ok
donfcaze: 3 wk balance
donfcaze: 1 WK 2-1WK 3-2-1 WK 4-3-2-1 WK EOL Model Total VS REV
SALSE
Customer
Model
W1
W2
W3
W4
W5
W6
W7
W8
W9
W10
W11
W12
W13
W14
W15
W16
W17
W18
W19
W20
W21
W22
W23
W24
W25
W26
W27
W28
W29
W30
W31
W32
W33
W34
W35
W36
W37
W38
W39
W40
W41
W42
W43
W44
W45
W46
W47
W48
W49
W50
W51
W52
W53
Sum of Inventory
Model/Project:
Cat.
08wk19
08wk20
08wk21
08wk22
08wk23
08wk24
08wk25
08wk26
08wk27
08wk28
08wk29
08wk30
08wk31
08wk32
08wk33
08wk34
08wk35
08wk36
08wk37
08wk38
08wk39
08wk40
08wk41
08wk42
08wk43
08wk44
08wk45
08wk46
08wk47
08wk48
08wk49
08wk50
08wk51
08wk52
Forecast-special
121,