Job sheet - Components

The Components sheet is the Bill of Materials or the recipe for taking components from stock for inventory control and reordering purposes.

In this sheet, you can add every part/component used for this product, the waste %, your Description and a formula to calculate what is needed from stock when an order is processed.

Note: There needs to be a value in cell "C1" for the BOM to start calculating

Open

Explaining the layout

•Row 1 consists on the inventory codes (these can be exported from BUZ then Copy and Paste with Transpose)

•Row 2 consists of the wastage percentage (we start with 10%, so 1.1 is entered, as you use BUZ and start to get a more accurate wastage % you can change this)

•Row 3 consists of the inventory description (these can be exported from BUZ then Copy and Paste with Transpose)

•From Row 4 down are formulas calculating the stock deduction. This formula includes the wastage percentage  (as per example →)

Open

More about the layout

Generally, the first few columns relate to the Order Id and line item

For this example

• Column A =Data!AW11 (Line Item Number)

• Column B =Data!AV11 (Order Item Product Key Identifier)

Next will be the material

• Column C is the formula for fabric =Data!$BD11

• Column D contains the formula to calculate material M2 =Data!BA11*Data!BB11/1000000)

Components

The remaining Columns E+ will have every possible option available for the product. There are various formulas that you can use to determine the quantity required.

More information about this can be found here

.