Spreadsheet: 146611d1332269924-search-dynamic-words-within-column-exmaple
Sheet: Data

Plant | Material | Product hierarchy | Material Description | Matl Type | Lot Size | Raw Material Issues | Semi-Finish Gds Issu | Labor | Variable Overhead | Production Support | Ext Svcs & O/S Proc. | Procurement Burden | Inbound Freight | Customs/Duty/Brokera | Tooling Depreciation | Total of all Components | Currency | Mat.pr.grp | Matl Group | Brand
5052 | 11639617 | EDWM7007AI40ALM | 57A09-24-240 | FERT | 100 | 65636.73 |  | 2081.45 | 1429.21 | 13717.4 |  | 56.7 | 110.43 |  |  | 83031.92 | $ |  | BL007 | B48
5052 | 11639621 | EDWM7007AI40ALM | 57A09-36-240 | FERT | 100 | 72148.32 |  | 2109.8 | 1440.28 | 13744.67 |  | 97.2 | 190.35 |  |  | 89730.62 | $ |  | BL007 | B48
5052 | 11652018 | EDSS4004AMM0ZNCE74 | B3202-7/8X6 GAP-ZN TURNBK | FERT | 100 | 5.62 | 3055.87 | 35.81 | 7.76 | 18.9 | 56.32 | 14.4 | 34.01 |  |  | 3228.69 | $ | 12 | BL004 | B48
5052 | 11652077 | EDWM7007BP70ALM | AL,EXTN .125X2X192 6063-T4 .122-.134 T | [NAME] | 100 | 2549.68 |  |  |  |  |  | 16.05 | 31.35 |  |  | 2597.08 | $ |  | 11040 | B48
5052 | 11654259 | EDWM7007BE30ALM | 817A40-12-90VO36-7 V/C | FERT | 100 |  | 7760 |  |  |  |  |  |  |  |  | 7760 | $ |  | BL007 | B48
5052 | 11654262 | EDWM7007BE30ALM | 817A40-24-90VO36-7 V/C | FERT | 100 |  | 10123.73 |  |  |  |  |  |  |  |  | 10123.73 | $ |  | 52010 | B48
5052 | 11656888 | EDWM7007AI40ALM | H46A09-48-240 ST SC | FERT | 100 | 65010.68 |  | 2515.43 | 1590.94 | 13991.76 |  | 162 | 316.98 |  |  | 83587.79 | $ |  | BL007 | B48
5052 | 11662041 | EDWM7007AP70ALM | AL,EXT SDRAL 34AX120 6063-T6 | [NAME] | 100 | 5928.01 |  |  |  |  |  |  |  |  |  | 5928.01 | $ |  | 11040 | B48
5052 | 11670225 | EDWM7007DE60PLN | RDCR SIDE 10.5 OFSET 6 PLN | HALB | 100 | 433.97 |  | 754.78 | 270.64 | 537.23 |  | 1.99 | 4.84 |  |  | 2003.45 | $ |  | BL007 | B48
5052 | 11674091 | [NAME] | B3373-30 ZN RISER CLMP | FERT | 100 | 16859.13 |  | 1527.45 | 1243.49 | 1473.15 | 4221 | 78.85 | 187.55 |  |  | 25590.62 | $ |  | BL004 | B48
5052 | 11678609 | EDSS4004AMM0ZNCE74 | B3202-1 1/4X6 GAP-ZN TUR | FERT | 100 |  | 5740.53 | 35.81 | 7.76 | 18.9 | 448.74 | 27 | 63.7 |  |  | 6342.44 | $ | 12 | BL004 | B48
5052 | 11681185 | EDSS4004AMM0ZNCE74 | B3202-1X6 ZN | FERT | 100 | 3182.41 |  | 35.81 | 7.76 | 18.9 | 24 | 14.96 | 35.32 |  |  | 3319.16 | $ | 12 | BL004 | B48
5052 | 11684546 | EDWM7007GZ10GLV | WB46H GLV FLIP CLIP | FERT | 100 | 52.91 |  | 16.35 | 14.02 | 15 |  | 0.22 | 0.6 |  |  | 99.1 | $ | QH | BL007 | VBL
5052 | 11684548 | EDWM7007GZ10 | [NAME] | FERT | 100 | 626.66 |  | 24.3 | 16.87 | 26.66 |  | 2.92 | 6.97 |  |  | 704.38 | $ |  | BL007 | B48
5052 | 11685421 | EDWM7007DE60PLN | 912 I/S HB 7.188 PLN 14GA | HALB | 100 | 616.87 |  | 1145.89 | 403.9 | 810.35 |  | 2.81 | 6.86 |  |  | 2986.68 | $ |  | BL007 | B48
5052 | 11689483 | EDWM7007DE60PLN | 918 I/S HB 6.188 PLN 14GA | HALB | 100 | 697.79 |  | 1159.58 | 417.32 | 826.51 |  | 3.19 | 7.76 |  |  | 3112.15 | $ |  | BL007 | B48
5052 | 11689968 | EDWM7007DEE0HDG | 9G-8037 W/SS6 HRZ ADJ S/P | FERT | 100 | 2534.6 | 2353.44 | 1170.35 | 380.1 | 848.05 | 650.48 | 24.64 | 48.12 |  |  | 8009.78 | $ |  | BL007 | B48
5052 | 11690365 | EDWM7007DE60PLN | 918 VT SD 6.188 PLN 14GA | HALB | 100 | 5877.84 |  | 2036.15 | 672.37 | 1405.62 |  | 36.93 | 71.88 |  |  | 10100.79 | $ |  | BL007 | B48
5052 | 11692581 | EDWM7007BH10ALM | 6A-24-48-HT24 | FERT | 100 | 20523.74 |  | 5154.77 | 1528.15 | 23903.11 |  | 129.41 | 252.59 |  |  | 51491.77 | $ |  | BL007 | B48
5052 | 11701260 | EDWM7007DEE0HDG | 9G-8067-12 W/SS6 RED S/P | FERT | 100 | 632.28 | 1176.72 | 250.46 | 82.55 | 173.9 | 446.04 | 9.37 | 18.28 |  |  | 2789.6 | $ |  | BL007 | B48
5052 | 11705486 | EDWM7007AP70ALM | AL,EXT SDRAL 35AX120 6063-T6 | [NAME] | 100 | 5729.28 |  |  |  |  |  |  |  |  |  | 5729.28 | $ |  | 11040 | B48
5052 | 11706112 | EDWM7007BE30ALM | 807A40-36-60HB36 SOLID CO | FERT | 100 | 9862.65 |  | 3534.38 | 1144.36 | 2542.37 |  | 62.13 | 121.07 |  |  | 17266.96 | $ |  | BL007 | B48
5052 | 11708096 | EDSS6006AE10HDG | B22SHB-120 HDG | FERT | 100 | 449.86 |  | 116.38 | 11.18 | 284.94 |  | 2.1 | 4.94 |  |  | 869.4 | $ | 13 | BL006 | B48
5052 | 11710562 | EDWM7007AI40ALM | H46A09-42-120 | FERT | 100 | 29655.14 |  | 1237.23 | 777.72 | 6791.04 |  | 63 | 123.34 |  |  | 38647.47 | $ |  | BL007 | B48
5052 | 11724163 | EDWM1001BXN0FBL | SB596V19103SFB | FERT | 100 | 3316.91 | 7.24 | 2277.73 | 1391.94 | 2505.1 |  | 63.07 | 137.83 |  |  | 9699.82 | $ | 3 | [NAME] | B50
5052 | 11724620 | EDWM7007CE30SS6 | 813SS620-18-120 | FERT | 100 | 36699.21 |  | 1031.8 | 302.7 | 882.9 |  | 231.61 | 451.22 |  |  | 39599.44 | $ |  | BL007 | B48
5052 | 11737658 | EDWM7007AI40ALM | H47A09-06-300 ST SC | FERT | 100 |  | 47817.68 | 1966.97 | 1384.66 | 13608.05 |  |  |  |  |  | 64777.36 | $ |  | BL007 | B48
5052 | 11738838 | EDWM7007FFL0FTZ | 13FT09-06-120 | FERT | 100 |  | 34019.5 |  |  |  |  | 159.88 | 377.62 |  |  | 34557 | $ |  | 52010 | B48
5052 | 11738958 | EDWM7007FFI0FTZ | FTC-18-120  S/C | FERT | 100 |  | 16884.14 |  |  |  |  |  |  |  |  | 16884.14 | $ |  | 52010 | B48
5052 | 11739181 | EDWM7007AI40ALM | 25A09-48-240 | FERT | 100 | 42933.44 |  | 2236.23 | 1394.38 | 12060.2 |  | 162 | 316.98 |  |  | 59103.23 | $ |  | BL007 | B48
5052 | 11742428 | EDWM7007BE30ALM | 817A40-36-45VO72-6 | FERT | 100 |  | 18000 |  |  |  |  |  |  |  |  | 18000 | $ |  | BL007 | B48
5052 | 11742432 | [NAME] | 472 VRT 6IN AL | HALB | 100 | 7732.21 |  | 1564.87 | 686.35 | 991.68 |  | 48.71 | 94.94 |  |  | 11118.76 | $ |  | BL007
5052 | 11742435 | [NAME] | 972 VRT 6IN AL | HALB | 100 | 27003.04 |  | 1564.87 | 686.35 | 991.68 |  | 170.12 | 331.5 |  |  | 30747.56 | $ |  | BL007 | B48
5052 | 11744327 | EDSS4004AMC0ZNCE02 | B3146-14 ZN PIPE CLMP | FERT | 100 | 20737.95 |  | 2320.25 | 1763.1 | 2146.49 | 4752.12 | 96.33 | 229.32 |  |  | 32045.56 | $ | 12 | BL004 | B48
5052 | 11744548 | EDWM7007AI40ALM | 57A09-30-240 | FERT | 100 | 69597.36 |  | 2109.8 | 1440.28 | 13744.67 |  | 81 | 159.03 |  |  | 87132.14 | $ |  | BL007 | B48
5052 | 11746856 | EDWM1001FXA0BZN | SB165BZ CORNER CLMP BRKT | FERT | 100 | 158.79 | 7.24 | 171.69 | 67.08 | 190.03 | 52.64 | 3.19 | 6.86 |  |  | 657.52 | $ |  | [NAME] | B48
5052 | 11747202 | EDWM7007AP70ALM | AL,EXT SDRAL 47AX300 6063-T6 | [NAME] | 100 | 25275.59 |  |  |  |  |  |  |  |  |  | 25275.59 | $ |  | 11040 | B48
5052 | 11750010 | EDWM7007CI40HDG | 366G09-06-120 | FERT | 100 | 8561.12 |  | 2837.79 | 1546.97 | 7901.88 | 3327 | 39.76 | 94.64 |  |  | 24309.16 | $ |  | BL007 | B48
5052 | 11758519 | EDWM7007BE30ALM | 816A40-36-90VO24-7 V/C | FERT | 100 | 5679.6 |  | 1586.88 | 501.24 | 1197.94 |  | 35.81 | 69.7 |  |  | 9071.17 | $ |  | BL007 | B48
5052 | 11758668 | EDWM7007BE30ALM | 816A40-24-90VI12 | FERT | 100 | 1735.36 |  | 823.4 | 249.12 | 670.83 |  | 10.95 | 21.3 |  |  | 3510.96 | $ |  | BL007 | B48
5052 | 11765754 | EDWM7007BE30ALM | 817A40-48-90VI36 V/C | FERT | 100 | 9710.24 |  | 2579.87 | 863.59 | 1917.96 |  | 61.34 | 119.39 |  |  | 15252.39 | $ |  | BL007 | B48
5052 | 11765755 | EDWM7007BE30ALM | 817A40-48-90VO36-4 | FERT | 100 | 10740.72 |  | 2579.87 | 863.59 | 1917.96 |  | 67.83 | 132.06 |  |  | 16302.03 | $ |  | BL007 | B48
5052 | 11778056 | EDWM7007AI40ALM | 25A09-48-120 | FERT | 100 | 21786 |  | 1237.23 | 777.72 | 6791.04 |  | 84 | 164.36 |  |  | 30840.35 | $ |  | BL007 | B48
5052 | 11779987 | EDWM7007DE30HDG | 811G18-06-90VI12 V/C | FERT | 100 |  | 1360 |  |  |  |  |  |  |  |  | 1360 | $ |  | BL007 | B48
5052 | 11781289 | EDWM2002HHS1GRY | 44120 HS | FERT | 100 | 7774.39 |  | 3191.86 | 1878.14 | 3395.8 |  | 82.11 | 49.12 |  |  | 16371.42 | $ | 4 | [NAME] | B56
5052 | 11781869 | EDWM2002HHS1 | 44 HSC | FERT | 100 | 229.92 |  | 1251.86 | 479.23 | 825.38 |  | 2.4 | 1.54 |  |  | 2790.33 | $ |  | [NAME] | B48
5052 | 11782683 | EDWM7007FFI0FGL | FC-12-90VO36 S/C | FERT | 100 |  | 9688.79 |  |  |  |  |  |  |  |  | 9688.79 | $ |  | 52010 | B48
5052 | 11783359 | EDWM2002HHS1GRY | 44 HSE | FERT | 100 | 155.94 |  | 808.7 | 317.32 | 536.63 |  | 1.69 | 1.01 |  |  | 1821.29 | $ | 4 | [NAME] | B56
5052 | 11783568 | EDWM2002HHS1GRY | 44 HSLOUT | FERT | 100 | 1331.57 |  | 2292.13 | 983.09 | 1725.72 |  | 14.06 | 8.29 |  |  | 6354.86 | $ |  | [NAME] | B48
5052 | 11784129 | EDWM2002HHS1GRY | 44 HSLIN | FERT | 100 | 1570.53 |  | 1870.19 | 804.16 | 1383.76 |  | 16.65 | 9.86 |  |  | 5655.15 | $ | 4 | [NAME] | B56
5052 | 11784431 | EDWM2002HHS1GRY | 44 HST | FERT | 100 | 1447.28 |  | 2217.62 | 976.19 | 1739.11 |  | 15.34 | 9.07 |  |  | 6404.61 | $ | 4 | [NAME] | B56
5052 | 11784977 | EDWM2002HHS1GRY | 4445 HSLSIDE | FERT | 100 | 690.96 |  | 1681.66 | 710.42 | 1250.77 |  | 7.39 | 4.27 |  |  | 4345.47 | $ | 4 | [NAME] | B56
5052 | 11785970 | EDWM7007BH10ALM | 7A06-48-HT24 | FERT | 100 | 34105.34 |  | 5329.65 | 1629.36 | 22920.34 |  | 138.93 | 271.72 |  |  | 64395.34 | $ |  | BL007 | B48
5052 | 11787636 | EDSS6006AEH0GLV | B22-116 GLV | FERT | 100 | 2778.03 |  | 181.59 | 178.03 | 214.74 |  | 13.12 | 31.12 |  |  | 3396.63 | $ |  | BL006 | B48
5052 | 11789847 | EDWM7007AP70ALM | AL,EXT SDRAL 46AX120 6063-T6 | HALB | 100 |  | 7581.55 |  |  |  |  |  |  |  |  | 7581.55 | $ |  | 11040 | B48
5052 | 11793925 | EDWM7007BQK0ALM | 6A-06-90VO72 | FERT | 100 | 54006.08 | 253.05 | 5302.52 | 2078.43 | 10099.4 |  | 340.24 | 663 |  |  | 72742.72 | $ |  | BL007 | B48
5052 | 11795181 | EDWM7007BQK0ALM | H6A-18-VTU12 | FERT | 100 | 14760.26 |  | 7583.72 | 3051.82 | 11556.17 |  | 93.03 | 181.16 |  |  | 37226.16 | $ |  | BL007 | B48
5052 | 11800415 | EDWM7007BE30ALM | 827A40-30-HX24 | FERT | 100 | 20223.51 |  | 6237.65 | 2037.12 | 4408.66 |  | 127.45 | 248.22 |  |  | 33282.61 | $ |  | BL007 | B48
5052 | 11800417 | EDWM7007BE30ALM | 827A40-30-24-HX24 | FERT | 100 | 18778.97 |  | 6237.65 | 2037.12 | 4408.66 |  | 118.34 | 230.48 |  |  | 31811.22 | $ |  | BL007 | B48
5052 | 11800418 | EDWM7007BH10ALM | H6A-30-24-HX24 | FERT | 100 | 25121.92 |  | 12185.08 | 3954.4 | 24034.18 |  | 158.11 | 309.15 |  |  | 65762.84 | $ |  | BL007 | B48
5052 | 11800967 | EDWM7007BH10ALM | 14A-12-90HB18 | FERT | 100 | 2733.8 |  | 2725.9 | 896.44 | 5199.46 |  | 17.23 | 33.65 |  |  | 11606.48 | $ |  | BL007 | B48
5052 | 11800968 | [NAME] | 918 I/S 14A HB AL | HALB | 100 | 766.82 |  | 725.01 | 239.41 | 500.52 |  | 4.84 | 9.45 |  |  | 2246.05 | $ |  | BL007 | B48
5052 | 11801472 | EDWM7007BQK0ALM | 14A-12-90VO18 | FERT | 100 | 5759.64 |  | 2704.49 | 999.35 | 4458.18 |  | 36.3 | 70.72 |  |  | 14028.68 | $ |  | BL007 | B48