Spreadsheet: 866948d1713863388-returning-a-list-of-parts-from-reference-date-costing-book-example
Sheet: Assembly

Assembly | SalesDescription | Purchasedescription | Type | ItemCost | Quantity | Unit of measure | Price
PRODUCT LEVEL
0801 | Sandpit
TOP LEVEL ASSEMBLY
0801 | COMP 0801/Sandpit 1.64m lengths | Pack of 4 1.64m connecting pieces |  | Assembly | 1
0801 | COMP 0801/Sandpit Bolt Pack | [NAME] for Covered Sandpit 0801 |  | Assembly | 1
0801 | COMP 0801/Sandpit Lid | Individual Lid for Covered Sandpit 0801 |  | Assembly | 2
0801 | COMP 0801/Sandpit Leg Frame | Individual Leg Frame for Covered Sandpit 0801 |  | Assembly | 4
0801 | COMP 0801/Sandpit side panel | Individual Side panel for covered Sandpit 0801 |  | Assembly | 4
SUB-ASSEMBLY
COMP 0801/Sandpit 1.64m lengths | 001640/32x95 | 1.64m length of 32mmx95mm timber profile |  | Assembly | 4
COMP 0801/Sandpit Bolt Pack | RAW Plantex Liner | Plantex Liner 2m wide roll | Plantex Liner 2m wide roll | NonInventory | 2
COMP 0801/Sandpit Bolt Pack | RAW 5.0x70/WS | 5.0x70mm Wood Screw | 5.0x70mm Wood Screw | NonInventory | 120
COMP 0801/Sandpit Bolt Pack | RAW 30mm [NAME] | 30mm [NAME] | 30mm [NAME] | NonInventory | 40
COMP 0801/Sandpit Bolt Pack | 000200/32x95 | 0.2m length of 32mmx95mm timber profile |  | Assembly | 4
COMP 0801/Sandpit Leg Frame | 000400/32X95 | 0.4m length of 32mmx95mm timber profile |  | Assembly | 2
COMP 0801/Sandpit Leg Frame | 000800/32X95 | 0.8m length of 32mmx95mm timber profile |  | Assembly | 2
COMP 0801/Sandpit Leg Frame | RAW 5.0x60/WS | 5.0x60mm Wood Screw | 5.0x60mm Wood Screw | NonInventory | 12
COMP 0801/Sandpit Lid | 001640/32x95 | 1.64m length of 32mmx95mm timber profile |  | Assembly | 8
COMP 0801/Sandpit Lid | 000800/32X95 | 0.8m length of 32mmx95mm timber profile |  | Assembly | 2
COMP 0801/Sandpit Lid | RAW 5.0x60/WS | 5.0x60mm Wood Screw | 5.0x60mm Wood Screw | NonInventory | 32
COMP 0801/Sandpit side panel | 001500/32X95 | 1.5m length of 32mmx95mm timber profile |  | Assembly | 4
COMP 0801/Sandpit side panel | 000400/32X95 | 0.4m length of 32mmx95mm timber profile |  | Assembly | 2
COMP 0801/Sandpit side panel | RAW 5.0x60/WS | 5.0x60mm Wood Screw | 5.0x60mm Wood Screw | NonInventory | 16
SUB-SUB_ASSEMBLY
001640/32x95 | RAW 32mm X 95mm | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | NonInventory | 1.64
000200/32x95 | RAW 32mm X 95mm | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | NonInventory | 0.2
000400/32X95 | RAW 32mm X 95mm | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | NonInventory | 0.4
000800/32X95 | RAW 32mm X 95mm | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | NonInventory | 0.8
001500/32X95 | RAW 32mm X 95mm | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | NonInventory | 1.5
RAW MATERIALS
NOTE: This data is on a separate tab which will be used to reference and be updated as cost prices change.
RAW 32mm X 95mm | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths | Tanalised 5th Grade Scandinavian Redwood 32mm x 95mm, pencil edged (all four corners after planing), 4.5m lengths |  |  |  | [NAME] (m) | 2.85
RAW Plantex Liner | Plantex Liner 2m wide roll | Plantex Liner 2m wide roll |  |  |  | [NAME] (m) | 0.7763
RAW 5.0x70/WS | 5.0x70mm Wood Screw | 5.0x70mm Wood Screw |  |  |  | each (ea) | 0.065
RAW 5.0x80/WS | [NAME] Screw | [NAME] Screw |  |  |  | each (ea) | 0.073
RAW 30mm [NAME] | 30mm [NAME] | 30mm [NAME] |  |  |  | each (ea) | 0.004