Spreadsheet: 678278d1589806226-index-offset-issue-for-cost-variance-help-help-2a
Sheet: Zproj Analysis

 |  |  |  |  |  |  |  |  |  | BOM Lvl | Material Number | Material Description |  | Cover Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baseline Tot Savings Components |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assembly number
 |  |  |  |  |  |  |  |  |  | 0 | H421014001 | RPP, HE 535-32 CRUSHB BPS-D202 (AP800) A | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -6973.523999999998
 |  |  |  |  |  |  |  |  |  | 1 | H028138802 | [NAME] | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1489.171700000001
 |  |  |  |  |  |  |  |  |  | 1 | H013299900 | DRV P BMS-C129 | 8 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.08000000000000007
 |  |  |  |  |  |  |  |  |  | 1 | H028136100 | 535 SUPPORT RING SETTING SLEEV | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88.53015999999997
 |  |  |  |  |  |  |  |  |  | 1 | H027943200 | BLR BMS-A137 | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 304.5678999999999
 |  |  |  |  |  |  |  |  |  | 1 | H026196101 | 81 SLIP | 2 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -143.32
 |  |  |  |  |  |  |  |  |  | 1 | H026196101 | 81 SLIP | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1558.6099
 |  |  |  |  |  |  |  |  |  | 1 | H028136000 | 535-32 TOP SUB | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80.81000000000006
 |  |  |  |  |  |  |  |  |  | 1 | HWWG51B0H0 | SCR SET SOC CUP 5/16-18X.500 ALY STL | 4 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1 | H028136200 | 535 UPPER CONE | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153.3029599999999
 |  |  |  |  |  |  |  |  |  | 1 | HWWGE180MB | SCR SHR HDLS 1/4-20X.625 BRS 15% | 12 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.2399999999999984
 |  |  |  |  |  |  |  |  |  | 1 | H028143600 | 535 CONE RING | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1095.998624
 |  |  |  |  |  |  |  |  |  | 1 | H028143700 | 535 PACKER RING | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1271.762336
 |  |  |  |  |  |  |  |  |  | 1 | H028136300 | WIRE MESH B/U RG | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 205.49488736
 |  |  |  |  |  |  |  |  |  | 1 | H028136400 | PE WSHR | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03399999999999181
 |  |  |  |  |  |  |  |  |  | 1 | H028136500 | PE | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 297.38300928
 |  |  |  |  |  |  |  |  |  | 1 | H028136600 | 535 LOWER CONE | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 224.5550400000001
 |  |  |  |  |  |  |  |  |  | 1 | H017306400 | KEY FORM B .187X.187X3.500 CS | 2 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -181.24
 |  |  |  |  |  |  |  |  |  | 1 | H028136700 | ADJNG NUT F/535 HE RPP | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.71358400000003
 |  |  |  |  |  |  |  |  |  | 1 | HWWG51B0M0 | SCR SET SOC CUP 5/16-18X.625 ALY STL | 8 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1 | H015290800 | FLR RG BMS-E106 | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -250.341
 |  |  |  |  |  |  |  |  |  | 1 | HWWB243A40 | O-RING 243 FEPM-90 | 2 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 337.68
 |  |  |  |  |  |  |  |  |  | 2 | HWRB55H301 | BMS-E104 CST 5.500"OD X 3.000"  ID X 36. | 2.2 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54.538
 |  |  |  |  |  |  |  |  |  | 2 | HWRB55H301 | BMS-E104 CST 5.500"OD X 3.000"  ID X 36. | 3 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74.37
 |  |  |  |  |  |  |  |  |  | 0 | H274101756 | PT LNDG CLR, TYP I 7.6" 55.3#TENARISHYDR | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -23.30249999999978
 |  |  |  |  |  |  |  |  |  | 1 | H093258414 | INS | 2 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47.25999999999999
 |  |  |  |  |  |  |  |  |  | 1 | HWWB259H40 | O-RING 259 NBR-90 | 2 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.3199999999999994
 |  |  |  |  |  |  |  |  |  | 1 | H093258036 | SPLT LK RG BMS-L106 | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -74.92000000000002
 |  |  |  |  |  |  |  |  |  | 1 | H07914111Y | [NAME]P125 | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -397.54
 |  |  |  |  |  |  |  |  |  | 0 | H293800006GT2 | QRD ZXP W/INTG FLX V LHP, ROT DG RTVBL N | 7 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7035.30329999997
 |  |  |  |  |  |  |  |  |  | 1 | H0G0628700060 | [NAME] | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34802.49
 |  |  |  |  |  |  |  |  |  | 1 | H0G0628700060 | [NAME] | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46403.31999999999
 |  |  |  |  |  |  |  |  |  | 1 | H0G0133625060 | [NAME] | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -4637.314299999998
 |  |  |  |  |  |  |  |  |  | 1 | H0G0133625060 | [NAME] | 1 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.61140000000159
 |  |  |  |  |  |  |  |  |  | 1 | H0G0133625060 | [NAME] | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 962.6857000000018
 |  |  |  |  |  |  |  |  |  | 1 | H0G0133625060 | [NAME] | 2 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 962.6857000000018
 |  |  |  |  |  |  |  |  |  | 1 | H078996400 | B/U RG | 14 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -11.6746
 |  |  |  |  |  |  |  |  |  | 1 | HWWB352A40 | O-RING 352 FEPM-90 | 3 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63.52227272727272
 |  |  |  |  |  |  |  |  |  | 1 | HWWB352A40 | O-RING 352 FEPM-90 | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.510519039999991
 |  |  |  |  |  |  |  |  |  | 1 | H079030912 | CONE EXT BMS-A099 | 1 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 151.37896
 |  |  |  |  |  |  |  |  |  | 1 | H079030912 | CONE EXT BMS-A099 | 2 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302.75792
 |  |  |  |  |  |  |  |  |  | 1 | H079030912 | CONE EXT BMS-A099 | 4 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 605.51584
 |  |  |  |  |  |  |  |  |  | 1 | [NAME] | BLR BMS-A099 | 14 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1940.544704
 |  |  |  |  |  |  |  |  |  | 1 | [NAME] | ROLL PS | 14 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1 | HWWGE1F0HB | SCR SHR HDLS 7/16-14X.500 BRS 15% | 35 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -38.11955
 |  |  |  |  |  |  |  |  |  | 1 | H078999800060 | [NAME] | 6 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 322.9310400000004
 |  |  |  |  |  |  |  |  |  | 1 | H078999800060 | [NAME] | 1 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98.90352000000004
 |  |  |  |  |  |  |  |  |  | 1 | HWWG51H0B0 | SCR SET SOC CUP 1/2-13X.312 ALY STL | 9 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1 | HWWG51H0B0 | SCR SET SOC CUP 1/2-13X.312 ALY STL | 47 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.417784800000007
 |  |  |  |  |  |  |  |  |  | 1 | H078996500 | SPC RG BMS-A099 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76.27173400000001
 |  |  |  |  |  |  |  |  |  | 1 | H079057400 | B/U RG | 14 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -57.42100000000005
 |  |  |  |  |  |  |  |  |  | 1 | HWWB353A40 | O-RING 353 FEPM-90 | 7 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1.260000000000019
 |  |  |  |  |  |  |  |  |  | 1 | H079029000 | LWR CONE BMS-A098 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 284.1003026399999
 |  |  |  |  |  |  |  |  |  | 1 | HWWGE1D0HB | SCR SHR HDLS 3/8-16X.500 BRS 15% | 21 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -16.847832
 |  |  |  |  |  |  |  |  |  | 1 | H093000728 | [NAME] | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 174.2592656
 |  |  |  |  |  |  |  |  |  | 1 | H079029200 | HLD DWN SLP BMS-A138 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1194.86878616
 |  |  |  |  |  |  |  |  |  | 1 | HWWG518080 | SCR SET SOC CUP 1/4-20X.250 ALY STL | 14 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09967328
 |  |  |  |  |  |  |  |  |  | 1 | H0930007D3 | [NAME] | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31.04980255999999
 |  |  |  |  |  |  |  |  |  | 1 | [NAME] | ADJMT RG BMS-A099 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 263.28464848
 |  |  |  |  |  |  |  |  |  | 1 | HWWB252A40 | O-RING 252 FEPM-90 | 7 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14.7
 |  |  |  |  |  |  |  |  |  | 1 | H078996101 | BACK-UP RING 5.205X0.115 PEEK | 14 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -13.90899999999999
 |  |  |  |  |  |  |  |  |  | 1 | H079000100060 | [NAME] | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3374.774031999999
 |  |  |  |  |  |  |  |  |  | 1 | H093000904 | GA RG BMS-A098 | 7 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -229.5597500000001
 |  |  |  |  |  |  |  |  |  | 1 | H0930007A7 | [NAME] | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131.83179744
 |  |  |  |  |  |  |  |  |  | 1 | H079680300 | UPR RG BMS-A097 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 427.0399840000002
 |  |  |  |  |  |  |  |  |  | 1 | HWWG51H0F0 | SCR SET SOC CUP 1/2-13X.437 ALY STL | 1 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1 | HWWG51H0F0 | SCR SET SOC CUP 1/2-13X.437 ALY STL | 55 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8205075999999996
 |  |  |  |  |  |  |  |  |  | 1 | H079680400060 | QRD INT SLP BMS-P129 | 4 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 727.1128899999999
 |  |  |  |  |  |  |  |  |  | 1 | H079680400060 | QRD INT SLP BMS-P129 | 3 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 442.42553
 |  |  |  |  |  |  |  |  |  | 1 | H079681800 | SPT RG BMS-A098 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69.96071880000002
 |  |  |  |  |  |  |  |  |  | 1 | H078879100 | BRNG ASSY | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1124.62289576
 |  |  |  |  |  |  |  |  |  | 1 | H079223703 | SPRNG PSHR BMS-A098 | 7 | WO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -157.7485
 |  |  |  |  |  |  |  |  |  | 1 | H079680200 | L-RG BMS-A098 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -86.97500000000002
 |  |  |  |  |  |  |  |  |  | 1 | HWX1195620 | SCR LLCAP SOC 3/8-16X.187 STL-8 CTG | 42 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.070991999999997
 |  |  |  |  |  |  |  |  |  | 1 | HWWGE1D0HB | SCR SHR HDLS 3/8-16X.500 BRS 15% | 21 | STK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -16.847832
 |  |  |  |  |  |  |  |  |  | 1 | H079146402 | KEY FORM D .725X.218X1.125 LOW ALY STL | 15 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 198.3486864
 |  |  |  |  |  |  |  |  |  | 1 | H079146402 | KEY FORM D .725X.218X1.125 LOW ALY STL | 6 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157.14
 |  |  |  |  |  |  |  |  |  | 1 | H0G0551901060 | QRD SLP ST BMS-A163 | 7 | PRQ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225.1900000000005
 |  |  |  |  |  |  |  |  |  | 1 | H0G0552001060 | QRD SLP BMS-A138 | 42 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5589.580500000002
 |  |  |  |  |  |  |  |  |  | 1 | H078238804 | T-SLOT SWVL BMS-A098 | 1 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -54.58839999999998
 |  |  |  |  |  |  |  |  |  | 1 | H078238804 | T-SLOT SWVL BMS-A098 | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -76.82195999999999
 |  |  |  |  |  |  |  |  |  | 1 | H078238804 | T-SLOT SWVL BMS-A098 | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -76.82195999999999
 |  |  |  |  |  |  |  |  |  | 1 | H093005707 | SWVL WIRE | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -65.39274728
 |  |  |  |  |  |  |  |  |  | 1 | H078879121 | BRNG ASSY | 1 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 201.532784
 |  |  |  |  |  |  |  |  |  | 1 | H078879121 | BRNG ASSY | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 604.598352
 |  |  |  |  |  |  |  |  |  | 1 | H078879121 | BRNG ASSY | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 604.598352
 |  |  |  |  |  |  |  |  |  | 1 | H079362300 | SWVL SLV BMS-A098 | 7 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 734.3311500000004
 |  |  |  |  |  |  |  |  |  | 1 | H0A1099600 | LTCH SLV BMS-A137 | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 127.585968
 |  |  |  |  |  |  |  |  |  | 1 | H0A1099600 | LTCH SLV BMS-A137 | 1 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.52865600000001
 |  |  |  |  |  |  |  |  |  | 1 | H0A1099600 | LTCH SLV BMS-A137 | 3 | PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 272.491368