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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | sku | national_inv | lead_time | in_transit_qty | forecast_3_month | forecast_6_month | forecast_9_month | sales_1_month | sales_3_month | sales_6_month | sales_9_month | min_bank | potential_issue | pieces_past_due | perf_6_month_avg | perf_12_month_avg | local_bo_qty | deck_risk | oe_constraint | ppap_risk | stop_auto_buy | rev_stop | went_on_backorder | ||
2 | 3426872 | 452 | 8 | 107 | 7 | 7 | 7 | 52 | 154 | 324 | 501 | 67 | Yes | 0 | 0.86 | 0.58 | 0 | No | No | No | Yes | No | No | ||
3 | 2805812 | 3 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | No | 0 | 0.99 | 0.97 | 0 | No | No | No | Yes | No | No | ||
4 | 3652230 | 12 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | No | 0 | 0.99 | 0.98 | 0 | No | No | Yes | Yes | No | No | ||
5 | 2246897 | 6 | 8 | 0 | 5 | 10 | 15 | 0 | 3 | 10 | 15 | 0 | No | 0 | 0.41 | 0.46 | 0 | No | No | No | Yes | No | No | ||
6 | 3816414 | 342 | 8 | 61 | 320 | 800 | 1400 | 153 | 536 | 1117 | 1517 | 146 | No | 0 | 0.75 | 0.86 | 0 | No | No | No | Yes | No | No | ||
7 | 3152385 | 0 | 2 | 0 | 16 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.66 | 0.75 | 0 | Yes | No | No | Yes | No | No | ||
8 | 2196472 | 47 | 52 | 0 | 0 | 0 | 0 | 2 | 9 | 13 | 18 | 2 | No | 0 | 0 | 0 | 0 | No | No | Yes | Yes | No | No | ||
9 | 3630334 | 249 | 8 | 45 | 2700 | 4536 | 6480 | 417 | 1743 | 3848 | 5463 | 267 | No | 108 | 0.63 | 0.62 | 0 | No | No | No | Yes | No | No | ||
10 | 4826759 | 4985 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | No | 0 | 0.88 | 0.86 | 0 | No | No | No | Yes | No | No | ||
11 | 3652136 | 215 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 12 | 2 | No | 0 | 0.98 | 0.99 | 0 | No | No | No | Yes | No | No | ||
12 | 2283106 | 267 | 8 | 0 | 240 | 240 | 240 | 40 | 163 | 358 | 582 | 60 | No | 0 | 0.98 | 0.98 | 0 | No | No | No | Yes | No | No | ||
13 | 3061663 | 4698 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.63 | 0.72 | 0 | No | No | No | Yes | No | No | ||
14 | 3539426 | 253 | 12 | 6 | 0 | 0 | 0 | 22 | 44 | 90 | 160 | 16 | No | 0 | 0.86 | 0.85 | 0 | No | No | No | Yes | No | No | ||
15 | 3384135 | 94 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.94 | 0.83 | 0 | No | No | No | Yes | No | No | ||
16 | 3996159 | 11 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.93 | 0.85 | 0 | Yes | No | No | Yes | No | No | ||
17 | 4980918 | 86 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | No | 0 | 0.63 | 0.75 | 0 | No | No | No | Yes | No | No | ||
18 | 3471056 | 20 | 8 | 0 | 0 | 0 | 8 | 3 | 5 | 10 | 16 | 2 | No | 0 | 0.99 | 0.98 | 0 | No | No | No | Yes | No | No | ||
19 | 2202567 | 11 | 8 | 0 | 0 | 0 | 0 | 2 | 3 | 4 | 4 | 0 | No | 0 | 1 | 0.99 | 0 | No | No | Yes | Yes | No | No | ||
20 | 3279997 | 0 | 2 | 0 | 12 | 18 | 24 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.95 | 0.97 | 0 | Yes | No | Yes | Yes | No | No | ||
21 | 2226773 | 8 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 10 | 1 | No | 0 | 0.96 | 0.96 | 0 | No | No | No | Yes | No | No | ||
22 | 3471926 | 136 | 12 | 0 | 1008 | 1968 | 2904 | 254 | 819 | 1681 | 2347 | 229 | No | 0 | 0.73 | 0.79 | 29 | No | No | No | Yes | No | No | ||
23 | 4788405 | 35 | 2 | 0 | 0 | 0 | 0 | 2 | 4 | 7 | 9 | 0 | No | 0 | 0.32 | 0.2 | 0 | Yes | No | No | Yes | No | No | ||
24 | 4804426 | 29 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.86 | 0.93 | 0 | No | No | No | Yes | No | No | ||
25 | 2086867 | 3 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.73 | 0.76 | 0 | No | No | No | Yes | No | No | ||
26 | 4971807 | 11 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | No | 0 | 0.96 | 0.97 | 0 | No | No | No | Yes | No | No | ||
27 | 3097802 | 16 | 12 | 0 | 10 | 20 | 32 | 10 | 10 | 60 | 70 | 0 | No | 0 | 0.57 | 0.68 | 0 | No | No | Yes | Yes | No | No | ||
28 | 3729522 | 16 | 8 | 0 | 0 | 2 | 7 | 0 | 5 | 17 | 23 | 1 | No | 0 | 0.97 | 0.96 | 0 | No | No | No | Yes | No | No | ||
29 | 4810100 | 6 | 3 | 0 | 0 | 80 | 80 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.9 | 0.89 | 0 | Yes | No | No | Yes | No | No | ||
30 | 4841437 | 0 | 8 | 0 | 42 | 50 | 54 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0 | 0 | 20 | No | No | No | Yes | No | No | ||
31 | 3680036 | 14 | 2 | 0 | 20 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.5 | 0.5 | 0 | Yes | No | Yes | No | No | No | ||
32 | 3338957 | 3 | 4 | 3 | 1 | 1 | 1 | 0 | 0 | 3 | 5 | 0 | No | 0 | 0.73 | 0.78 | 0 | No | No | No | Yes | No | No | ||
33 | 3064213 | 360 | 8 | 0 | 0 | 0 | 20 | 95 | 122 | 151 | 394 | 172 | No | 0 | 0.94 | 0.94 | 0 | No | No | No | Yes | No | No | ||
34 | 3568951 | 4 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | No | 0 | 0.55 | 0.7 | 0 | No | No | No | Yes | No | No | ||
35 | 3078010 | 4 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.93 | 0.89 | 0 | No | No | No | Yes | No | No | ||
36 | 3087301 | 24 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.22 | 0.15 | 0 | Yes | No | No | Yes | No | No | ||
37 | 2163504 | -1 | 4 | 2 | 5 | 7 | 8 | 5 | 7 | 8 | 9 | 2 | No | 0 | 0.73 | 0.78 | 1 | No | No | No | Yes | No | No | ||
38 | 2980719 | 10 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 1 | 0.97 | 0 | No | No | No | Yes | No | No | ||
39 | 3010737 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | No | 0 | 0.54 | 0.56 | 0 | Yes | No | Yes | Yes | No | No | ||
40 | 2076805 | 6 | 2 | 0 | 600 | 600 | 600 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.64 | 0.65 | 0 | Yes | No | No | Yes | No | No | ||
41 | 2166452 | 7 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.97 | 0.97 | 0 | No | No | No | Yes | No | No | ||
42 | 2265792 | 1 | 8 | 0 | 14 | 14 | 19 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.97 | 0.96 | 0 | No | No | No | Yes | No | No | ||
43 | 2083224 | 7 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.99 | 0.95 | 0 | No | No | No | Yes | No | No | ||
44 | 4764703 | 3 | 8 | 0 | 2 | 5 | 7 | 0 | 2 | 5 | 6 | 0 | No | 0 | 0.8 | 0.76 | 0 | No | No | No | Yes | No | No | ||
45 | 3090867 | 2 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | No | 0 | 0.9 | 0.95 | 0 | No | No | No | Yes | No | No | ||
46 | 3822478 | 2 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.63 | 0.75 | 0 | No | No | No | Yes | No | No | ||
47 | 3812086 | 1 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.63 | 0.75 | 0 | Yes | No | No | Yes | No | No | ||
48 | 3268380 | 6 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | No | 0 | 0.7 | 0.66 | 0 | No | No | Yes | Yes | No | No | ||
49 | 2985331 | 3 | 12 | 0 | 1 | 3 | 5 | 0 | 2 | 3 | 3 | 0 | No | 0 | 0.73 | 0.79 | 0 | No | No | No | Yes | No | No | ||
50 | 3670542 | 19 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.91 | 0.95 | 0 | No | No | No | Yes | No | No | ||
51 | 2135877 | 2651 | 8 | 196 | 891 | 2916 | 4050 | 698 | 2332 | 5370 | 8105 | 450 | No | 0 | 0.61 | 0.59 | 0 | No | No | No | Yes | No | No | ||
52 | 2110507 | 2 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.57 | 0.7 | 0 | No | No | No | Yes | No | No | ||
53 | 3279084 | 1 | 8 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 7 | No | 0 | 0.97 | 0.97 | 0 | No | No | No | Yes | No | No | ||
54 | 3183432 | 67 | 2 | 0 | 40 | 108 | 176 | 17 | 67 | 170 | 199 | 9 | No | 0 | 0.38 | 0.51 | 0 | Yes | No | No | Yes | No | No | ||
55 | 3173459 | 3765 | 2 | 3105 | 0 | 0 | 0 | 174 | 613 | 1213 | 2102 | 339 | No | 0 | 1 | 0.99 | 0 | No | No | No | Yes | No | No | ||
56 | 3939210 | 14 | 9 | 0 | 0 | 0 | 0 | 1 | 1 | 4 | 6 | 0 | No | 0 | 0.8 | 0.82 | 0 | No | No | No | Yes | No | No | ||
57 | 3140558 | 3 | 8 | 0 | 3 | 6 | 10 | 1 | 3 | 7 | 9 | 1 | No | 0 | 0.79 | 0.79 | 0 | No | No | No | Yes | No | No | ||
58 | 2807165 | 16 | 2 | 0 | 0 | 0 | 0 | 5 | 6 | 6 | 6 | 0 | No | 0 | 0.81 | 0.78 | 0 | Yes | No | Yes | Yes | No | No | ||
59 | 3783786 | 44 | 8 | 0 | 32 | 52 | 62 | 7 | 29 | 64 | 92 | 14 | No | 12 | 0.59 | 0.62 | 0 | No | No | Yes | Yes | No | No | ||
60 | 3569081 | 138 | 12 | 0 | 0 | 0 | 0 | 0 | 2 | 14 | 24 | 10 | No | 0 | 0.62 | 0.69 | 0 | Yes | No | No | Yes | No | No | ||
61 | 3779434 | 448 | 2 | 353 | 1445 | 2444 | 3572 | 407 | 1260 | 2518 | 3799 | 343 | No | 0 | 0.89 | 0.91 | 0 | No | No | No | Yes | No | No | ||
62 | 2970190 | 11 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 0 | No | 0 | 1 | 1 | 0 | No | No | No | Yes | No | No | ||
63 | 4976812 | 11 | 4 | 15 | 20 | 55 | 95 | 8 | 15 | 22 | 22 | 0 | No | 0 | 0.7 | 0.67 | 0 | Yes | No | No | Yes | No | No | ||
64 | 3514066 | 16 | 8 | 0 | 67 | 101 | 142 | 9 | 28 | 68 | 113 | 17 | No | 0 | 0.02 | 0.12 | 0 | No | No | Yes | Yes | No | No | ||
65 | 3244697 | 62 | 9 | 0 | 0 | 0 | 0 | 2 | 6 | 7 | 12 | 0 | No | 0 | 0.58 | 0.45 | 0 | No | No | Yes | Yes | No | No | ||
66 | 3872838 | 0 | 4 | 0 | 6 | 8 | 8 | 5 | 5 | 6 | 7 | 0 | No | 0 | 0.79 | 0.66 | 0 | Yes | No | No | Yes | No | No | ||
67 | 3145512 | 47 | 8 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | No | 0 | 0.97 | 0.98 | 0 | No | No | No | Yes | No | No | ||
68 | 3029877 | 11 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | No | 0 | 0.73 | 0.78 | 0 | No | No | No | Yes | No | No | ||
69 | 3545359 | 3 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 5 | 5 | 0 | No | 0 | 0.99 | 0.99 | 0 | No | No | No | Yes | No | No | ||
70 | 4798667 | 3088 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | No | 0 | 0.88 | 0.81 | 0 | No | No | No | Yes | No | No | ||
71 | 4900255 | 12 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.97 | 0.96 | 0 | No | No | No | Yes | No | No | ||
72 | 2150896 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | No | 0 | 0.73 | 0.76 | 0 | Yes | No | No | Yes | No | No | ||
73 | 4908694 | 6 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.32 | 0.35 | 0 | No | No | No | Yes | No | No | ||
74 | 3112299 | 200 | 8 | 0 | 0 | 0 | 0 | 15 | 31 | 98 | 141 | 17 | No | 0 | 0.94 | 0.96 | 0 | No | No | No | Yes | No | No | ||
75 | 2081917 | 138 | 2 | 0 | 0 | 0 | 0 | 4 | 21 | 53 | 98 | 0 | No | 0 | 0.9 | 0.96 | 0 | Yes | No | No | Yes | No | No | ||
76 | 3639351 | 4 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.72 | 0.76 | 0 | No | No | Yes | Yes | No | No | ||
77 | 4764965 | 351 | 8 | 30 | 182 | 426 | 609 | 69 | 199 | 356 | 512 | 90 | No | 0 | 0.76 | 0.61 | 0 | No | No | No | Yes | No | No | ||
78 | 4811171 | 2420 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 2 | No | 0 | 1 | 0.85 | 0 | No | No | No | Yes | No | No | ||
79 | 3575275 | 2 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | No | 0 | 0.28 | 0.33 | 0 | No | No | No | Yes | No | No | ||
80 | 2194844 | 22 | 12 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 8 | 0 | No | 0 | 0.73 | 0.76 | 0 | No | No | Yes | Yes | No | No | ||
81 | 2241101 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.19 | 0.5 | 0 | No | No | No | Yes | No | No | ||
82 | 2090737 | 24 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | No | 0 | 0.99 | 0.97 | 0 | No | No | No | Yes | No | No | ||
83 | 2136501 | 2786 | 2 | 1522 | 1408 | 4672 | 7680 | 573 | 2536 | 6716 | 9330 | 1258 | No | 0 | 0.98 | 0.99 | 0 | No | No | No | Yes | No | No | ||
84 | 3970506 | 0 | 4 | 13 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | No | 0 | 0.26 | 0.18 | 0 | Yes | No | No | Yes | No | No | ||
85 | 2268715 | 267 | 8 | 67 | 95 | 305 | 589 | 69 | 304 | 592 | 912 | 96 | No | 0 | 0.96 | 0.9 | 0 | No | No | No | Yes | No | No | ||
86 | 4754936 | 40 | 9 | 0 | 0 | 0 | 0 | 1 | 4 | 6 | 9 | 0 | No | 0 | 0.99 | 0.99 | 0 | No | No | No | Yes | No | No | ||
87 | 4809721 | 163 | 2 | 0 | 0 | 0 | 8 | 14 | 30 | 89 | 139 | 16 | No | 0 | 0.69 | 0.61 | 0 | No | No | No | Yes | No | No | ||
88 | 3712891 | 59 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | No | 0 | 0.93 | 0.96 | 0 | No | No | No | Yes | No | No | ||
89 | 3398469 | 87 | 12 | 0 | 0 | 0 | 0 | 0 | 6 | 13 | 13 | 1 | No | 0 | 0.68 | 0.57 | 0 | No | No | No | Yes | No | No | ||
90 | 3305699 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | 0 | 1 | 1 | 0 | Yes | No | No | Yes | No | No | ||
91 | 2813382 | 370 | 8 | 6 | 62 | 294 | 474 | 34 | 172 | 552 | 939 | 70 | No | 0 | 0.93 | 0.96 | 0 | No | No | No | Yes | No | No | ||
92 | 3566469 | 59 | 9 | 0 | 0 | 0 | 0 | 0 | 15 | 31 | 50 | 0 | No | 0 | 0.82 | 0.81 | 0 | Yes | No | No | Yes | No | No | ||
93 | 4922398 | 15 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 5 | 0 | No | 0 | 0.71 | 0.8 | 0 | No | No | No | Yes | No | No | ||
94 | 4752891 | 3 | 2 | 0 | 2 | 6 | 8 | 1 | 2 | 4 | 10 | 0 | No | 0 | 0.68 | 0.64 | 0 | No | No | No | Yes | No | No | ||
95 | 4006451 | 459 | 8 | 6 | 0 | 0 | 0 | 14 | 64 | 161 | 212 | 43 | No | 0 | 0.98 | 0.96 | 0 | No | No | No | Yes | No | No | ||
96 | 3665742 | 269 | 8 | 3 | 0 | 0 | 0 | 19 | 52 | 119 | 185 | 22 | No | 0 | 1 | 0.99 | 0 | No | No | No | Yes | No | No | ||
97 | 2176321 | 311 | 8 | 6 | 0 | 140 | 224 | 31 | 159 | 510 | 771 | 46 | No | 0 | 0.87 | 0.72 | 0 | No | No | No | Yes | No | No | ||
98 | 3291255 | 11 | 3 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 4 | 1 | No | 0 | 1 | 0.99 | 0 | No | No | No | Yes | No | No | ||
99 | 2904811 | 3 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | No | 0 | 0.73 | 0.79 | 0 | Yes | No | No | Yes | No | No | ||
100 | 2192187 | 3 | 2 | 0 | 9 | 9 | 9 | 0 | 0 | 0 | 0 | 3 | No | 0 | 0.82 | 0.74 | 0 | Yes | No | No | Yes | No | No |