Spreadsheet: 188908d1351020763-indented-bom-cost-roll-up-help-indented-test-bom
Sheet: Sheet1

Level 2 | 3 | 4 | 5 | part number | rev | description | qty | uom | p/m | Cost | Extended Cost | Phantom
2 |  |  |  | 12754684 | P01 | C80 TANDEM ASSY TO LINE - RWD | 1 | EA | M |  |  | True
 | 3 |  |  | 102232 | 0 | GASKET ELIMINATOR 518-10.2 OZ | 1 | EA | P | 48.43 |  | False
 | 3 |  |  | 106065 | P01 | CHAIN ARRAGEMENT,#120 | 1 | EA | M |  |  | True
 |  | 4 |  | 100580 | 0 | CHAIN, C80 #120 HS 50 PITCH W/ | 4 | EA | P | 93.96 |  | False
 |  | 4 |  | 13A-3.512ZI | 0 | COTTER PIN, 7/64 X 3/4 EXTENDE | 8 | EA | P | 0.0001 |  | False
 | 3 |  |  | 106066 | P02 | REAR END ARRAGEMENT, #120 CHA | 1 | EA | M |  |  | True
 |  | 4 |  | 100554 | P02 | VENTED PLUG ASSY - #8 O-RING A | 1 | EA | P | 3.81 |  | False
 |  | 4 |  | 100602 | P02 | REAR END HOUSING, MACHINED COM | 1 | EA | P | 357.1928 |  | False
 |  | 4 |  | 100605 | P01 | CARRIER ASSY-W/RANGE BOX-2 SP | 1 | EA | P | 0 |  | False
 |  | 4 |  | 105571 | P01 | THICK WASHER, W/ OFFSET HOLE | 4 | EA | P | 0.0001 |  | False
 |  | 4 |  | 105939 | P01 | HUB/SPINDLE ARRAGEMENT, 2.5 A | 2 | EA | M |  |  | True
 |  |  | 5 | 100233 | P01 | NUT, ART JOINT | 2 | EA | P | 5.66 |  | False
 |  |  | 5 | 100234 | P01 | LOCK WASHER, ART JOINT | 1 | EA | P | 0.0001 |  | False
 |  |  | 5 | 100235 | P01 | BEARING, ART JOINT / TANDEM OS | 1 | EA | P | 29.45 |  | False
 |  |  | 5 | 100236 | 0 | BRG RACE ART JOINT | 1 | EA | P | 17.75 |  | False
 |  |  | 5 | 100581 | P01 | AXLE ASSY,SPLINED,2.5,#120CHA | 1 | EA | P | 307.4592 |  | False
 |  |  | 5 | 100594-CMG | P01 | SEAL, TANDEM OSCILLATION | 1 | EA | P | 33.56 |  | False
 |  |  | 5 | 100595 | P01 | BEARING, OUTER, TAND OSC | 1 | EA | P | 77 |  | False
 |  |  | 5 | 100596 | P01 | BEARING RACE, OUTER,TAND OSC | 1 | EA | P | 47.35 |  | False
 |  |  | 5 | 100597 | P01 | OSC HUB [NAME], MACHINED | 1 | EA | P | 76.86 |  | False
 |  |  | 5 | 100603 | P01 | SNAP RING, SPLINED AXLE | 1 | EA | P | 4.66 |  | False
 |  |  | 5 | 100604 | P01 | SEAL, SPLINED AXLE - 2.5" - CU | 1 | EA | P | 6.74 |  | False
 |  |  | 5 | 100593-CMG | P03 | TANDEM OSCILLATING SPINDLE,  C | 1 | EA | P | 176.8 |  | False
 |  | 4 |  | 111H-08 | 0 | MB EXTERNAL HEX PLUG, O RING | 2 | EA | P | 0.26 |  | False
 |  | 4 |  | 112237 | P01 | CONTROL LEVER-HYD MOTOR-23 SE | 1 | EA | P | 4.17 |  | False
 |  | 4 |  | 12756577 | P01 | HYDROSTATIC DRIVE MOTOR - 23 S | 1 | EA | P | 2468.47 |  | False
 |  | 4 |  | 14A-07ZI | 0 | LOCKWASHER 7/16 GR 8 Z&Y | 10 | EA | P | 0.0001 |  | False
 |  | 4 |  | 14A-10ZI | 0 | LOCKWASHER 5/8 USS GR 8 Z&Y | 12 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0710ZI | 0 | HEX C/S 7/16 x 1-1/4 UNC GR8 Z | 6 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0712ZI | 0 | HEX C/S 7/16 x 1-1/2 UNC GR8 Z | 2 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0716ZI | 0 | HEX C/S 7/16 x2 UNC GR 8 Z&Y | 2 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0816ZI | 0 | HEX C/S 1/2 X 2 GR 8 Z & Y | 4 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-1016ZI | 0 | HEX C/S 5/8 X 2 UNC GR 8 Z & Y | 12 | EA | P | 0.0001 |  | False
 | 3 |  |  | 110751 | P03 | TANDEM BOX ARR.-PARK BRAKE-C8 | 1 | EA | M |  |  | True
 |  | 4 |  | 100550 | P02 | SIDE COVER PLATE ASSY,TANDEM B | 2 | EA | P | 11.6 |  | False
 |  | 4 |  | 100551 | P01 | TANDEM BOX ACCESS HOLE COVER P | 4 | EA | P | 6.85 |  | False
 |  | 4 |  | 100552 | P03 | TOP COVERPLATE W/FILLER | 2 | EA | P | 10.4913 |  | False
 |  | 4 |  | 100554 | P02 | VENTED PLUG ASSY - #8 O-RING A | 2 | EA | P | 3.81 |  | False
 |  | 4 |  | 110753 | P03 | TANDEM BOX-C80-MACH-RH | 1 | EA | P | 644.5356 |  | False
 |  | 4 |  | 110761 | P03 | TANDEM BOX-C80-MACH-LH | 1 | EA | P | 644.5356 |  | False
 |  | 4 |  | 110792 | P03 | CABLE BRACKET ASSY-RIGHT-TAND | 1 | EA | P | 5.95 |  | False
 |  | 4 |  | 110795 | P03 | TANDEM BOX CABLE BRACKET ASSY | 1 | EA | P | 5.95 |  | False
 |  | 4 |  | 111H-08 | 0 | MB EXTERNAL HEX PLUG, O RING | 4 | EA | P | 0.26 |  | False
 |  | 4 |  | 14A-06ZI | 0 | LOCKWASHER 3/8 USS GR 5 ZINC | 36 | EA | P | 0.0001 |  | False
 |  | 4 |  | 14A-08ZI | 0 | LOCKWASHER 1/2 GR 8 Z&Y | 16 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0606ZI | 0 | HEX C/S 3/8-16 UNC X 3/4 GR 5 | 26 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0610ZI | 0 | HEX C/S 3/8 x 1-1/4 UNC GR5 ZI | 10 | EA | P | 0.0001 |  | False
 | 3 |  |  | 110772 | P03 | LOCATION-TANDEM STOP,DISC GUA | 1 | EA | M |  |  | True
 |  | 4 |  | 110773 | P04 | BURNOUT, TANDEM STOP-C80 | 4 | EA | P | 10.75 |  | False
 |  | 4 |  | 111238 | P01 | DISC GUARD, W/PARK BRAKE | 2 | EA | P | 6.4395 |  | False
 | 3 |  |  | 110799 | P01 | WHL AXLE ASSY-REAR-3INBRG,#12 | 2 | EA | M |  |  | True
 |  | 4 |  | 100558 | P01 | KEY-3IN WHL END-3/4 X 4.25 | 1 | EA | P | 1.3613 |  | False
 |  | 4 |  | 100559 | P01 | OUTER BEARING, TANDEM WHEEL AX | 2 | EA | P | 49.56 |  | False
 |  | 4 |  | 100560 | P01 | OUTER BEARING RACE, TANDEM WHE | 2 | EA | P | 27.94 |  | False
 |  | 4 |  | 100562 | P01 | SEAL, OUTER, WHL AXLE,3IN | 1 | EA | P | 15.53 |  | False
 |  | 4 |  | 100564 | P03 | BROWNING BUSHING, TAPERED 3IN | 1 | EA | P | 77.1 |  | False
 |  | 4 |  | 100566 | P01 | HEX BOLT 1/2 X 2 FULLTHREAD GR | 3 | EA | P | 0.0001 |  | False
 |  | 4 |  | 105979 | P01 | OUTER BRG HSG,3IN WHL AXLE, C7 | 1 | EA | P | 114 |  | False
 |  | 4 |  | 110106 | P01 | WHEEL HUB W/STUDS PRESSED & L | 1 | EA | M |  |  | True
 |  |  | 5 | 100567 | P01 | STUD, WHEEL 5/8-18 X 2-1/2 | 8 | EA | P | 0.67 |  | False
 |  |  | 5 | 105971 | P02 | WHEEL HUB,3IN WHL END,1IN OFF | 1 | EA | P | 68.85 |  | False
 |  | 4 |  | 110830 | P01 | SHIM-BEARING CAP-.010 | 4 | EA | P | 2.25 |  | False
 |  | 4 |  | 110831 | P01 | SHIM-.005 THK-7.19 OD | 1 | EA | P | 1.8 |  | False
 |  | 4 |  | 110834 | P01 | REAR INNER AXLE BEARING CAP , | 1 | EA | P | 51.4612 |  | False
 |  | 4 |  | 110840 | P01 | SEAL, SPLINED ROTOR SHAFT 3IN | 1 | EA | P | 8.06 |  | False
 |  | 4 |  | 110846 | P01 | WELDMENT-REAR WHEEL AXLE/SPROC | 1 | EA | M |  |  | True
 |  |  | 5 | 105976 | P02 | SPROCKET, 120A27 3.5IN-BORE | 1 | EA | P | 53.35 |  | False
 |  |  | 5 | 110832 | P02 | REAR WHEEL SPLINED AXLE | 6 | EA | P | 117.03 |  | False
 |  | 4 |  | 115D-02 | 0 | PIPE PLUG 1/8-27 ALLEN HEAD | 2 | EA | P | 0.0001 |  | False
 |  | 4 |  | 12756192 | P01 | SHIM-BEARING CAP-.030 NOTE | 6 | EA | P | 1.83 |  | False
 |  | 4 |  | 14A-08ZI | 0 | LOCKWASHER 1/2 GR 8 Z&Y | 18 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0810ZI | 0 | HEX C/S 1/2-13 x 1-1/4 UNC GR | 6 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0812ZI | 0 | HEX C/S 1/2-13 x 1-1/2 UNC GR | 12 | EA | P | 0.0001 |  | False
 | 3 |  |  | 110841 | P01 | WHEEL AXLE ASSY-FR-3INBRG,#12 | 2 | EA | M |  |  | True
 |  | 4 |  | 100558 | P01 | KEY-3IN WHL END-3/4 X 4.25 | 1 | EA | P | 1.3613 |  | False
 |  | 4 |  | 100559 | P01 | OUTER BEARING, TANDEM WHEEL AX | 2 | EA | P | 49.56 |  | False
 |  | 4 |  | 100560 | P01 | OUTER BEARING RACE, TANDEM WHE | 2 | EA | P | 27.94 |  | False
 |  | 4 |  | 100562 | P01 | SEAL, OUTER, WHL AXLE,3IN | 1 | EA | P | 15.53 |  | False
 |  | 4 |  | 100564 | P03 | BROWNING BUSHING, TAPERED 3IN | 1 | EA | P | 77.1 |  | False
 |  | 4 |  | 100566 | P01 | HEX BOLT 1/2 X 2 FULLTHREAD GR | 3 | EA | P | 0.0001 |  | False
 |  | 4 |  | 105979 | P01 | OUTER BRG HSG,3IN WHL AXLE, C7 | 1 | EA | P | 114 |  | False
 |  | 4 |  | 110106 | P01 | WHEEL HUB W/STUDS PRESSED & L | 1 | EA | M |  |  | True
 |  |  | 5 | 100567 | P01 | STUD, WHEEL 5/8-18 X 2-1/2 | 8 | EA | P | 0.67 |  | False
 |  |  | 5 | 105971 | P02 | WHEEL HUB,3IN WHL END,1IN OFF | 1 | EA | P | 68.85 |  | False
 |  | 4 |  | 110830 | P01 | SHIM-BEARING CAP-.010 | 1 | EA | P | 2.25 |  | False
 |  | 4 |  | 110831 | P01 | SHIM-.005 THK-7.19 OD | 1 | EA | P | 1.8 |  | False
 |  | 4 |  | 110835 | P01 | CAP-INNER BRG FRONT (NEW BRAKE | 1 | EA | P | 42.2596 |  | False
 |  | 4 |  | 110847 | P01 | FRONT AXLE/SPROCKET WELDMENT-# | 1 | EA | M |  |  | True
 |  |  | 5 | 105976 | P02 | SPROCKET, 120A27 3.5IN-BORE | 1 | EA | P | 53.35 |  | False
 |  |  | 5 | 110833 | P01 | AXLE - FRONT WHEEL, NEW BRAKE | 1 | EA | P | 92 |  | False
 |  | 4 |  | 115D-02 | 0 | PIPE PLUG 1/8-27 ALLEN HEAD | 2 | EA | P | 0.0001 |  | False
 |  | 4 |  | 12756192 | P01 | SHIM-BEARING CAP-.030 NOTE | 6 | EA | P | 1.83 |  | False
 |  | 4 |  | 14A-08ZI | 0 | LOCKWASHER 1/2 GR 8 Z&Y | 18 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0810ZI | 0 | HEX C/S 1/2-13 x 1-1/4 UNC GR | 6 | EA | P | 0.0001 |  | False
 |  | 4 |  | 50A-0812ZI | 0 | HEX C/S 1/2-13 x 1-1/2 UNC GR | 12 | EA | P | 0.0001 |  | False
 | 3 |  |  | 12755891 | P02 | Install Cable Shift Base to ta | 1 | EA | P | 17.1712 |  | False
 | 3 |  |  | 14A-12ZI | 0 | LOCKWASHER 3/4 USS GR 8 ZINC | 16 | EA | P | 0.0001 |  | False
 | 3 |  |  | 50A-1218ZI | 0 | HEX C/S 3/4 x 2-1/4 UNC GR8 Z& | 16 | EA | P | 0.0001 |  | False