Levels
4
83 exploded lines
Material
$298,153
44 leaf lines
Labour
$123,782
1,049 h at $118.00
Standard cost
$421,935
Rolled up, never typed
List / margin
$585,000
27.9% at list
7 lines in this structure are below their reorder point
RAW-RHS-250X150X9, CHN-FEED-32B, SPR-FEED-32B-19, RAW-TUBE-219X16, RAW-SHS-200X200X10, CON-WIRE-FCAW and 1 more. The requirements run will tell you which of those actually have to be ordered this week.
Multi-level explosion
Quantity per parent, quantity for one Bournedrill S350, and the cost each level carries.
Make Buy Subcontract
| Lvl | Part No. | Description | Qty / parent | Qty / unit | UoM | Source | Supplier / work centre | Unit cost | Extended | Free |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BD-S350 | Bournedrill S350 | 1 | 1 | ea | Make | Assembly Bay | $421,935 | $421,935 | 0 |
| 1 | ASM-MST-500 | Mast & Feed Assembly — 500 series | 1 | 1 | ea | Make | Fabrication Bay 1 | $46,394 | $46,394 | — |
| 2 | FAB-MST-BOX-1000 | Mast Box Section — 1000, welded Shared section, cropped to 6.5 m | 1 | 1 | ea | Make | Robotic Weld Cell | $13,246 | $13,246 | — |
| 3 | RAW-RHS-250X150X9 | RHS 250 × 150 × 9 Grade 350 | 12.4 | 12.4 | m | Buy | InfraBuild Steel Centre | $148 | $1,835 | 46 |
| 3 | RAW-PL-BIS80-16 | Bisalloy 80 Plate 16 mm | 86 | 86 | kg | Buy | Bisalloy Steels | $5 | $417 | 3,014 |
| 3 | CON-WIRE-ER70S | MIG Wire ER70S-6 1.2 mm | 14 | 14 | kg | Buy | Cigweld | $12 | $165 | 424 |
| 3 | SUB-LASER-PL | Laser Profiling — plate nest | 1 | 1 | ea | Subcontract | Laser Cutting Services QLD | $680 | $680 | 0 |
| 2 | ASM-FEED-CYL | Feed Cylinder Assembly | 1 | 1 | ea | Make | Hydraulics & Electrical | $8,132 | $8,132 | — |
| 3 | HYD-CYL-100X60X2400 | Hydraulic Cylinder 100/60 × 2400 | 1 | 1 | ea | Buy | Parker Hannifin Australia | $6,850 | $6,850 | 7 |
| 3 | HYD-HOSE-R2-12 | Hose 3/4" 2-wire R2 | 3.2 | 3.2 | m | Buy | Hydraulink Brisbane South | $42 | $133 | 378 |
| 3 | HYD-FIT-JIC-12 | JIC Fitting 3/4" straight | 4 | 4 | ea | Buy | Hydraulink Brisbane South | $22 | $87 | 472 |
| 2 | ASM-CHAIN-FEED | Feed Chain & Sprocket Set | 1 | 1 | ea | Make | Fabrication Bay 2 | $4,937 | $4,937 | — |
| 3 | CHN-FEED-32B | Feed Chain 32B duplex | 9.5 | 9.5 | m | Buy | Renold Australia | $214 | $2,033 | 43 |
| 3 | SPR-FEED-32B-19 | Sprocket 32B 19T | 2 | 2 | ea | Buy | Renold Australia | $328 | $656 | 4 |
| 3 | BRG-SPH-22320 | Spherical Roller Bearing 22320 | 2 | 2 | ea | Buy | Motion Australia (CBC Bearings) | $416 | $832 | 15 |
| 2 | BOP-SLIDE-UHMW | UHMW Slide Pad | 6 | 6 | ea | Buy | Blackwoods | $76 | $456 | 80 |
| 2 | FST-BOLT-M24-100 | Bolt M24 × 100 8.8 | 0.4 | 0.4 | pk100 | Buy | Blackwoods | $384 | $154 | 12 |
| 1 | ASM-BKT-DRV | Bucket Drive Assembly | 1 | 1 | ea | Make | Assembly Bay | $47,214 | $47,214 | — |
| 2 | GBX-THD-500 | THD Gearbox — 500 series Bucket drive shares the 500-series gearbox | 1 | 1 | ea | Make | Assembly Bay | $10,925 | $10,925 | — |
| 3 | MCH-GEAR-SPUR-42T | Spur Gear 42T — 4140, hardened | 1 | 1 | ea | Make | CNC Machining | $3,738 | $3,738 | — |
| 4 | RAW-4140-200RD | 4140 Round Bar Ø200 | 38 | 38 | kg | Buy | Bohler Uddeholm Australia | $14 | $540 | 1,188 |
| 4 | SUB-HT-4140 | Heat Treatment — 4140, harden & temper | 1 | 1 | ea | Subcontract | Bodycote Australasia | $420 | $420 | 0 |
| 4 | SUB-GEAR-HOB | Gear Hobbing — external | 1 | 1 | ea | Subcontract | Brisbane Gear & Hobbing | $890 | $890 | 0 |
| 3 | BRG-TAPER-32218 | Taper Roller Bearing 32218 | 4 | 4 | ea | Buy | Motion Australia (CBC Bearings) | $248 | $992 | 18 |
| 3 | SEA-KIT-GBX | Gearbox Seal Kit | 1 | 1 | ea | Buy | Motion Australia (CBC Bearings) | $184 | $184 | 21 |
| 3 | CON-OIL-HYD-46 | Hydraulic Oil ISO 46 | 12 | 12 | L | Buy | Viva Energy Australia | $6 | $77 | 2,714 |
| 3 | FST-BOLT-M16-60 | Bolt M16 × 60 8.8 | 0.24 | 0.24 | pk100 | Buy | Blackwoods | $146 | $35 | 17 |
| 2 | MCH-KELLY-BAR-3 | Kelly Bar Section — 3 m | 2 | 2 | ea | Make | CNC Machining | $4,027 | $8,053 | — |
| 3 | RAW-TUBE-219X16 | Seamless Tube 219 × 16 | 3.1 | 6.2 | m | Buy | Bohler Uddeholm Australia | $326 | $2,021 | 12 |
| 3 | SUB-HT-4140 | Heat Treatment — 4140, harden & temper | 1 | 2 | ea | Subcontract | Bodycote Australasia | $420 | $840 | 0 |
| 2 | HYD-MOT-A6VM-160 | Hydraulic Motor A6VM 160 cc | 1 | 1 | ea | Buy | Bosch Rexroth Australia | $7,400 | $7,400 | 9 |
| 2 | BRG-SPH-22320 | Spherical Roller Bearing 22320 | 2 | 2 | ea | Buy | Motion Australia (CBC Bearings) | $416 | $832 | 15 |
| 2 | MCH-PIN-SET-1000 | Pin & Bush Set — 1000 series | 1 | 1 | ea | Make | CNC Machining | $1,949 | $1,949 | — |
| 3 | RAW-EN8-90RD | EN8 Round Bar Ø90 | 26 | 26 | kg | Buy | Bohler Uddeholm Australia | $9 | $231 | 546 |
| 3 | SUB-HT-4140 | Heat Treatment — 4140, harden & temper | 1 | 1 | ea | Subcontract | Bodycote Australasia | $420 | $420 | 0 |
| 1 | ASM-PWR-QSF38 | Power Pack — Cummins QSF3.8 | 1 | 1 | ea | Make | Hydraulics & Electrical | $63,604 | $63,604 | — |
| 2 | ENG-CUM-QSF38 | Cummins QSF3.8 — 97 kW | 1 | 1 | ea | Buy | Cummins South Pacific | $22,400 | $22,400 | 4 |
| 2 | HYD-PMP-A10VO-140 | Variable Pump A10VO 140 cc | 2 | 2 | ea | Buy | Bosch Rexroth Australia | $7,420 | $14,840 | 6 |
| 2 | FAB-TNK-HYD-450 | Hydraulic Tank 450 L, welded | 1 | 1 | ea | Make | Fabrication Bay 2 | $5,210 | $5,210 | — |
| 3 | RAW-PL-350-12 | Plate 12 mm Grade 350 | 168 | 168 | kg | Buy | InfraBuild Steel Centre | $2 | $412 | 4,380 |
| 3 | CON-WIRE-ER70S | MIG Wire ER70S-6 1.2 mm | 9 | 9 | kg | Buy | Cigweld | $12 | $106 | 424 |
| 3 | SUB-LASER-PL | Laser Profiling — plate nest | 1 | 1 | ea | Subcontract | Laser Cutting Services QLD | $680 | $680 | 0 |
| 2 | HYD-COOL-3B | Cooler Pack — 3 bank | 1 | 1 | ea | Buy | Parker Hannifin Australia | $5,400 | $5,400 | 6 |
| 2 | HYD-FLT-RET-10 | Return Line Filter — 10 µm | 2 | 2 | ea | Buy | Hydraulink Brisbane South | $340 | $680 | 18 |
| 2 | ENG-AIRCLN | Air Cleaner Assembly | 1 | 1 | ea | Buy | Cummins South Pacific | $620 | $620 | 7 |
| 2 | ELE-ALT-24V-100 | Alternator 24 V 100 A | 1 | 1 | ea | Buy | Blackwoods | $960 | $960 | 7 |
| 2 | ELE-BATT-N200 | Battery N200 24 V set | 1 | 1 | ea | Buy | Blackwoods | $485 | $485 | 11 |
| 2 | HYD-HOSE-R2-12 | Hose 3/4" 2-wire R2 | 14 | 14 | m | Buy | Hydraulink Brisbane South | $42 | $581 | 378 |
| 2 | HYD-FIT-JIC-12 | JIC Fitting 3/4" straight | 18 | 18 | ea | Buy | Hydraulink Brisbane South | $22 | $392 | 472 |
| 1 | ASM-CHS-TRK-D3 | Tracked Chassis — D3 class | 1 | 1 | ea | Make | Fabrication Bay 1 | $86,446 | $86,446 | — |
| 2 | TRK-UC-D3 | Undercarriage — D3 class | 1 | 1 | ea | Buy | Track & Undercarriage Australia | $29,800 | $29,800 | 2 |
| 2 | HYD-MOT-GFT17 | Track Drive GFT17 Reduction Gear | 2 | 2 | ea | Buy | Bosch Rexroth Australia | $8,900 | $17,800 | 5 |
| 2 | FAB-CHS-FRAME-500 | Chassis Frame — 500 class, welded | 1 | 1 | ea | Make | Robotic Weld Cell | $15,774 | $15,774 | — |
| 3 | RAW-PL-350-20 | Plate 20 mm Grade 350 | 280 | 280 | kg | Buy | InfraBuild Steel Centre | $2 | $658 | 7,920 |
| 3 | RAW-SHS-200X200X10 | SHS 200 × 200 × 10 Grade 350 | 7.2 | 7.2 | m | Buy | InfraBuild Steel Centre | $172 | $1,238 | 17 |
| 3 | CON-WIRE-FCAW | Flux-Cored Wire 1.6 mm | 15 | 15 | kg | Buy | Cigweld | $16 | $246 | 84 |
| 3 | SUB-LASER-PL | Laser Profiling — plate nest | 2 | 2 | ea | Subcontract | Laser Cutting Services QLD | $680 | $1,360 | 0 |
| 2 | MCH-PIN-SET-1000 | Pin & Bush Set — 1000 series | 1 | 1 | ea | Make | CNC Machining | $1,949 | $1,949 | — |
| 3 | RAW-EN8-90RD | EN8 Round Bar Ø90 | 26 | 26 | kg | Buy | Bohler Uddeholm Australia | $9 | $231 | 546 |
| 3 | SUB-HT-4140 | Heat Treatment — 4140, harden & temper | 1 | 1 | ea | Subcontract | Bodycote Australasia | $420 | $420 | 0 |
| 1 | ASM-CTRL-IQAN | Control & Electrical — IQAN | 1 | 1 | ea | Make | Hydraulics & Electrical | $33,288 | $33,288 | — |
| 2 | ELE-PLC-IQAN-MD4 | Parker IQAN MD4 Display | 1 | 1 | ea | Buy | Parker Hannifin Australia | $4,950 | $4,950 | 4 |
| 2 | ELE-LOOM-1000 | Wiring Loom — 1000 series | 1 | 1 | ea | Buy | Blackwoods | $3,850 | $3,850 | 3 |
| 2 | HYD-VLV-BANK-6S | Valve Bank — 6 section, proportional | 1 | 1 | ea | Buy | Parker Hannifin Australia | $7,600 | $7,600 | 5 |
| 2 | HYD-HOSE-R2-12 | Hose 3/4" 2-wire R2 | 42 | 42 | m | Buy | Hydraulink Brisbane South | $42 | $1,743 | 378 |
| 2 | HYD-FIT-JIC-12 | JIC Fitting 3/4" straight | 56 | 56 | ea | Buy | Hydraulink Brisbane South | $22 | $1,221 | 472 |
| 1 | FAB-DECK-PLT | Deck & Walkway Plate Set | 1 | 1 | ea | Make | Fabrication Bay 2 | $8,714 | $8,714 | — |
| 2 | RAW-PL-350-12 | Plate 12 mm Grade 350 | 240 | 240 | kg | Buy | InfraBuild Steel Centre | $2 | $588 | 4,380 |
| 2 | CON-WIRE-ER70S | MIG Wire ER70S-6 1.2 mm | 11 | 11 | kg | Buy | Cigweld | $12 | $130 | 424 |
| 2 | SUB-LASER-PL | Laser Profiling — plate nest | 1 | 1 | ea | Subcontract | Laser Cutting Services QLD | $680 | $680 | 0 |
| 1 | FAB-GUARD-SET | Guarding Set, powder coated | 1 | 1 | ea | Make | Fabrication Bay 2 | $6,157 | $6,157 | — |
| 2 | RAW-PL-350-12 | Plate 12 mm Grade 350 | 95 | 95 | kg | Buy | InfraBuild Steel Centre | $2 | $233 | 4,380 |
| 2 | SUB-LASER-PL | Laser Profiling — plate nest | 1 | 1 | ea | Subcontract | Laser Cutting Services QLD | $680 | $680 | 0 |
| 2 | SUB-PC-GUARD | Powder Coat — guarding set | 1 | 1 | ea | Subcontract | Queensland Powder Coating | $760 | $760 | 0 |
| 1 | CON-PNT-2PK-NAVY | 2-Pack Enamel — Bournedrill Navy | 16 | 16 | L | Buy | Dulux Protective Coatings | $68 | $1,088 | 48 |
| 1 | CON-PNT-2PK-RED | 2-Pack Enamel — Signal Red | 4 | 4 | L | Buy | Dulux Protective Coatings | $72 | $288 | 66 |
| 1 | CON-PRIMER-ZN | Inorganic Zinc Primer | 11 | 11 | L | Buy | Dulux Protective Coatings | $54 | $594 | 116 |
| 1 | CON-OIL-HYD-46 | Hydraulic Oil ISO 46 | 280 | 280 | L | Buy | Viva Energy Australia | $6 | $1,792 | 2,714 |
| 1 | CON-GRS-EP2 | EP2 Lithium Grease | 6 | 6 | kg | Buy | Viva Energy Australia | $12 | $74 | 122 |
| 1 | CON-THRD-LOC-243 | Threadlocker 243, 250 ml | 2 | 2 | ea | Buy | Blackwoods | $86 | $172 | 18 |
| 1 | ACC-BIT-AUG-600 | Auger Head 600 mm Supplied with a 600 mm head | 1 | 1 | ea | Make | Fabrication Bay 2 | $2,329 | $2,329 | — |
| 2 | RAW-PL-BIS80-16 | Bisalloy 80 Plate 16 mm | 36 | 36 | kg | Buy | Bisalloy Steels | $5 | $175 | 3,014 |
| 2 | CON-WIRE-FCAW | Flux-Cored Wire 1.6 mm | 5 | 5 | kg | Buy | Cigweld | $16 | $82 | 84 |
| 2 | SUB-HT-4140 | Heat Treatment — 4140, harden & temper | 1 | 1 | ea | Subcontract | Bodycote Australasia | $420 | $420 | 0 |
Where the material money goes
Bought and subcontracted content only — $147,359.49 bought, $8,250.00 outside operations.
| Part No. | Description | Supplier | Qty | Unit | Extended | Share |
|---|---|---|---|---|---|---|
| TRK-UC-D3 | Undercarriage — D3 class | Track & Undercarriage Australia | 1 ea | $29,800 | $29,800 | 19.2% |
| ENG-CUM-QSF38 | Cummins QSF3.8 — 97 kW | Cummins South Pacific | 1 ea | $22,400 | $22,400 | 14.4% |
| HYD-MOT-GFT17 | Track Drive GFT17 Reduction Gear | Bosch Rexroth Australia | 2 ea | $8,900 | $17,800 | 11.4% |
| HYD-PMP-A10VO-140 | Variable Pump A10VO 140 cc | Bosch Rexroth Australia | 2 ea | $7,420 | $14,840 | 9.5% |
| HYD-VLV-BANK-6S | Valve Bank — 6 section, proportional | Parker Hannifin Australia | 1 ea | $7,600 | $7,600 | 4.9% |
| HYD-MOT-A6VM-160 | Hydraulic Motor A6VM 160 cc | Bosch Rexroth Australia | 1 ea | $7,400 | $7,400 | 4.8% |
| HYD-CYL-100X60X2400 | Hydraulic Cylinder 100/60 × 2400 | Parker Hannifin Australia | 1 ea | $6,850 | $6,850 | 4.4% |
| HYD-COOL-3B | Cooler Pack — 3 bank | Parker Hannifin Australia | 1 ea | $5,400 | $5,400 | 3.5% |
| ELE-PLC-IQAN-MD4 | Parker IQAN MD4 Display | Parker Hannifin Australia | 1 ea | $4,950 | $4,950 | 3.2% |
| SUB-LASER-PL | Laser Profiling — plate nest | Laser Cutting Services QLD | 6 ea | $680 | $4,080 | 2.6% |
Where used
Top-level item — it isn't a component of anything else.