Spreadsheet: 697640d1601462677-i-need-horizontal-look-up-that-looks-at-a-part-number-and-date-test-capicty-plan
Sheet: Product List

Customer | Part Number | Tool No. | Description | M/C Group | RFT  - % | % of the Forecast | Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kanban stock
 |  |  |  |  |  |  | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week |  | 2018-04-30 00:00:00
 |  |  |  |  |  |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A
 | Mercedes BR204
JLR  Painted | 14-149-606 | 181620 | Sleeve | 80 tonne group | 1 | 1 | 37960 | 35196 | 34547 | 27976 | 9026 | 26895 | 38128 | 38962 | 51846 | 32243 | 34665 | 38741 | 37524 | #N/A | #N/A | #N/A | #N/A
JLR  Painted | 14-149-605 | 181616 | Lever | 80 tonne group | 1 | 0.25 | 34990 | 31328 | 31673 | 24901 | 8317 | 23735 | 34195 | 35531 | 47062 | 29435 | 31498 | 34264 | 35020 | #N/A | #N/A | #N/A | #N/A
JLR  Painted | 14-139-403 | 181949 | RH Locking Cap | 5,12,24 | 0.8 | 0.1 | 34990 | 31328 | 31673 | 24901 | 8317 | 23735 | 34195 | 35531 | 47062 | 29435 | 31498 | 34264 | 35020 | #N/A | #N/A | #N/A | #N/A
JLR | 14-149-801 | 181947 | RH Locking Bracket | 28 | 1 | 1 | 1152 | 1536 | 384 | 768 | 3456 | 1546 | 3092 | 0 | 384 | 394 | 5760 | 2688 | 3072 | #N/A | #N/A | #N/A | #N/A
JLR  Painted | 14-149-805 | 181948 | [NAME] | 80 tonne group | 0.8 | 0.075 | 34990 | 31328 | 31673 | 24901 | 8317 | 23735 | 34195 | 35531 | 47062 | 29435 | 31498 | 34264 | 35020 | #N/A | #N/A | #N/A | #N/A
JLR  Chrome | 14-225-202 | 182328A | Strip K - Dimple (Kessy) | 5,12,24 | 0.8 | 0.95 | 2314 | 3041 | 2240 | 2365 | 589 | 2508 | 2972 | 2613 | 3836 | 2353 | 2738 | 3649 | 2162 | #N/A | #N/A | #N/A | #N/A
JLR  Chrome | 14-538-202 | 182328B | Strip N - Plain (Standard) | 5,12,24 | 0.8 | 0.05 | 2314 | 3041 | 2240 | 2365 | 589 | 2508 | 2972 | 2613 | 3836 | 2353 | 2738 | 3649 | 2162 | #N/A | #N/A | #N/A | #N/A
JLR  Chrome | 14-258-202 | 181759 | LH Locking Insert | 80 tonne group | 0.8 | 0.15 | 2314 | 3041 | 2240 | 2365 | 589 | 2508 | 2972 | 2613 | 3836 | 2353 | 2738 | 3649 | 2162 | #N/A | #N/A | #N/A | #N/A
JLR  Chrome | 14-258-402 | 181761 | RH Locking Insert | 80 tonne group | 0.8 | 0.05 | 2314 | 3041 | 2240 | 2365 | 589 | 2508 | 2972 | 2613 | 3836 | 2353 | 2738 | 3649 | 2162 | #N/A | #N/A | #N/A | #N/A
JLR  Chrome | 14-225-602 | 181763 | Non Locking Insert | 80 tonne group | 0.8 | 0.8 | 2314 | 3041 | 2240 | 2365 | 589 | 2508 | 2972 | 2613 | 3836 | 2353 | 2738 | 3649 | 2162 | #N/A | #N/A | #N/A | #N/A
BMW F54 | 32-796-503 | 182448 | Gripp RR Activator [NAME] | 14 | 1 | 0.3 | 2016 | 2652 | 2352 | 2016 | 2352 | 2352 | 2352 | 3024 | 3360 | 2688 | 2352 | 2016 | 0 | #N/A | #N/A | #N/A | #N/A
BMW F54 | 32-796-510 | 182449 | Gripper RR Body | 24 | 1 | 0.35 | 2016 | 2652 | 2352 | 2016 | 2352 | 2352 | 2352 | 3024 | 3360 | 2688 | 2352 | 2016 | 0 | #N/A | #N/A | #N/A | #N/A
BMW F54 | 32-796-505 | 182450 | Gripper RR Carrier | 80 tonne group | 1 | 0.35 | 2016 | 2652 | 2352 | 2016 | 2352 | 2352 | 2352 | 3024 | 3360 | 2688 | 2352 | 2016 | 0 | #N/A | #N/A | #N/A | #N/A
BMW F56 | 14-317-201 | 182036 | Handle Base STD | 15 | 1 | 0.3 | 23352 | 28368 | 26112 | 26952 | 29664 | 27996 | 28464 | 30072 | 41904 | 33408 | 31392 | 19272 | 1584 | #N/A | #N/A | #N/A | #N/A
BMW F56 | 14-321-201/401 | 182037 | Handle Base OVT/CA LH / RH | 420 tonne group | 1 | 0.7 | 23352 | 28368 | 26112 | 26952 | 29664 | 27996 | 28464 | 30072 | 41904 | 33408 | 31392 | 19272 | 1584 | #N/A | #N/A | #N/A | #N/A
BMW M13 | 14-624-102 | 182619 | [NAME] | 80 tonne group | 1 | 1 | 1848 | 1584 | 1584 | 1848 | 1584 | 1584 | 1584 | 1848 | 1584 | 1584 | 1584 | 1848 | 1584 | #N/A | #N/A | #N/A | #N/A
BMW M13 | 14-624-101 / 201 | 182620 | LH Rear & LH Front OVT Cover | 5,12,24 | 1 | 0.5 | 1848 | 1584 | 1584 | 1848 | 1584 | 1584 | 1584 | 1848 | 1584 | 1584 | 1584 | 1848 | 1584 | #N/A | #N/A | #N/A | #N/A
BMW M13 | 14-321-201/401 | 182037 | RH Rear OVT Cover | 5,12,24 | 1 | 0.5 | 1848 | 1584 | 1584 | 1848 | 1584 | 1584 | 1584 | 1848 | 1584 | 1584 | 1584 | 1848 | 1584 | #N/A | #N/A | #N/A | #N/A
[NAME] | 15-781-201 / 401 | 103867 | [NAME] | 420 tonne group | 0.8 | 1 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-781-202 | 103873 | LH Lock Cover CA | 5,12,24 | 0.8 | 0.13 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-781-302 | 103874 | LH Non Lock Cover CA | 5,12,24 | 0.8 | 0.14 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-781-402 | 103872 | RH Lock Cover CA | 5,12,24 | 0.8 | 0.02 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-781-502 | 103875 | RH Non Lock Cover CA | 5,12,24 | 0.8 | 0.26 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-782-202 | 103869 | LH Lock Cover ST | 5,12,24 | 0.8 | 0.1 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-782-302 | 103870 | LH Non Lock Cover ST | 5,12,24 | 0.8 | 0.18 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-782-402 | 103872 | RH Lock Cover ST | 5,12,24 | 0.8 | 0.02 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 15-782-502 | 103871 | RH Non Lock Cover ST | 5,12,24 | 0.8 | 0.15 | 126 | 112 | 168 | 182 | 84 | 84 | 210 | 140 | 196 | 42 | 392 | 126 | 126 | #N/A | 0 | #N/A | #N/A | #N/A
[NAME] | 14-010-201 / 401 | 181447 | [NAME] | 420 tonne group | 0.8 | 1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-010-202 | 181448 | LH Lock Bowl Std | 29 | 0.8 | 0.2 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-010-302 |  | RH Non Lock Bowl Std | 29 | 0.8 | 0.2 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-010-102 | 181449 | LH Non Lock Bowl Std | 29 | 0.8 | 0.1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-010-402 |  | RH Lock Bowl Std | 29 | 0.8 | 0.1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-011-202 | 181450 | LH Lock Bowl CA | 29 | 0.8 | 0.1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-011-302 |  | RH Non Lock Bowl CA | 29 | 0.8 | 0.1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-011-102 | 181451 | LH Non Lock Bowl CA | 29 | 0.8 | 0.1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-011-402 |  | RH Lock Bowl CA | 29 | 0.8 | 0.1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
[NAME] | 14-010-209 | 181596 | Sleeve | 80 tonne group | 0.8 | 1 | 36 | 0 | 49 | 0 | 0 | 0 | 49 | 1 | 0 | 0 | 60 | 1 | 0 | #N/A | #N/A | #N/A | #N/A
Nissan | 14-682-201 / 401 | 103927B | [NAME] | 420 tonne group | 0.8 | 0.1 | 637 | 2548 | 1568 | 1092 | 2526 | 2992 | 2982 | 2498 | 2388 | 1296 | 1078 | 1804 | 1734 | #N/A | #N/A | #N/A | #N/A
Nissan | 14-682-601 | 180889B | LH Locking [NAME] | 5,12,24 | 0.8 | 0.05 | 637 | 2548 | 1568 | 1092 | 2526 | 2992 | 2982 | 2498 | 2388 | 1296 | 1078 | 1804 | 1734 | #N/A | #N/A | #N/A | #N/A
Nissan | 14-682-801 | 180929B | RH Locking Cap | 5,12,24 | 0.8 | 0.01 | 637 | 2548 | 1568 | 1092 | 2526 | 2992 | 2982 | 2498 | 2388 | 1296 | 1078 | 1804 | 1734 | #N/A | #N/A | #N/A | #N/A
Nissan | 14-682-202/402 |  | LH/RH Dummy Housing | 80 tonne group | 0.8 | 0.1 | 637 | 2548 | 1568 | 1092 | 2526 | 2992 | 2982 | 2498 | 2388 | 1296 | 1078 | 1804 | 1734 | #N/A | #N/A | #N/A | #N/A
Huf Poland | 14-467-201 | 182247 | LH RKG | 14 | 1 | 0.66 | 18000 | 17505 | 18000 | 23596 | 20500 | 19000 | 20000 | 22000 | 23000 | 25096 | 22000 | 17596 | 18500 | #N/A | 0 | #N/A | #N/A
Huf Poland | 14-467-401 | 182248 | RH RKG | 14 | 1 | 0.33 | 18000 | 17505 | 18000 | 23596 | 20500 | 19000 | 20000 | 22000 | 23000 | 25096 | 22000 | 17596 | 18500 | #N/A | 0 | #N/A | #N/A
Huf Poland | 15-782-202 | 103869 | LH Lock Cover ST | 5,12,24 | 1 | 0.01 | 18000 | 17505 | 18000 | 23596 | 20500 | 19000 | 20000 | 22000 | 23000 | 25096 | 22000 | 17596 | 18500 | #N/A | 0 | #N/A | #N/A
Huf Poland | 15-782-302 | 103870 | LH Non Lock Cover ST | 5,12,24 | 1 | 0.01 | 18000 | 17505 | 18000 | 23596 | 20500 | 19000 | 20000 | 22000 | 23000 | 25096 | 22000 | 17596 | 18500 | #N/A | 0 | #N/A | #N/A
Paint Shop | 68970002 | 180927 | MASK |  | 1 | 0 | 14524 | 16206 | 18098 | 13696 | 9030 | 19332 | 18772 | 21434 | 19297 | 19400 | 18326 | 20202 | 23604 | 0 | #N/A | #N/A | #N/A
Paint Shop | 68990025 | UK3075 | BR 204 [NAME] |  | 1 | 0 | 14524 | 16206 | 18098 | 13696 | 9030 | 19332 | 18772 | 21434 | 19297 | 19400 | 18326 | 20202 | 23604 | 0 | #N/A | #N/A | #N/A
Paint Shop | 68990015 | UK3064 | GRIPPER WAFFLE MASK |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | #N/A
Paint Shop | 68990026 | UK3076 | GRIPPER TOP MASK |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | #N/A
 | Jaguar Landrover L538
JLR  Painted | 14-139-206 | UK6077 | Glide Shoe | 80 tonne group | 1 | 1 | 37960 | 35196 | 34547 | 27976 | 9026 | 26895 | 38128 | 38962 | 51846 | 32243 | 34665 | 38741 | 37524 | 0 | #N/A | #N/A | #N/A