Materials Admin/Raw Materials

Materials Admin/Raw Materials

A raw material can be created and added to a 'Material Set'. 
Material Sets' are then linked to pricing component lines within operations, so they are included in quoting for cost and inventory purposes.
This is managed from ‘Material Admin’ under ‘Equipment’ in the ‘Configure the Factory’ screen.


Add new Material

To begin creating a new 'Raw Material', click the ‘+’ button.


A material creation dropdown will show. This is where you configure the details and pricing:



In this example we are creating a roll of gloss laminate:



Some fields of note: 

  1. Inventory Location - Choose a location for the material. This can be something general like the name of your company or if you have a full inventory warehouse configured, you can specify the exact location where this stock will be stored.
  2. Code - A code will be auto generated by IQ but it is always best to use a code that actually relates to the material as this 'code' is what you select inside the operation component screen to link so the clearer the name the easier it is to select later.
    Maximum code length is 100 characters 
  3. Description - Enter the full description of the material here.
  4. Calc type - Select the calculation type that best relates to the material being created (see further down in documentation for more info). In this case we are selecting 'Roll applied to Sheets' as this will look at the sheet (or Roll) size of the material being printed on to calculate the number of metres required to laminate the printed job.
  5. Extra mm per sheet - When some calculation types are selected, additional options are shown. In this case we have the option to enter an extra mm per sheet to allow for the gap between sheets when laminating. Enter a number here for the gap size or add 0 if you do not want to add any extra.
  6. Roll Width mm - This is another option triggered by the calculation type selected. Here we enter the width of the roll. This is used to determine what side of the sheet will need to be used as the leading edge. This is then used to calculate the correct number of metres required to produce the job.
  7. Order in units of - Select the quantity that the item is ordered in. In the case of a roll, we enter the cost of a single roll.  NOTE: If you select a charge unit type of /Roll or a length/area based unit type, you will get an extra field – Order ->Charge Unit Conversion Factor.  This allows you to enter the charge cost. For example, a roll of 50metres at $100 per roll, you would make the charge unit /1 to charge per metre. 100/50=$2 per metre.  This will also flow through to the purchasing of the item. If you order in 1 roll, on receipt of order, 50 metres will be added to inventory to allow for accurate stock pick/inventory management.
                        
  1. Charge in units of - With rolls, a unit selection of /1 equals either 1 linear metre / foot, or 1 square metre / foot, dependent on calculation type. Enter the price per metre.
  2. Default Supplier - Select the default supplier the item is ordered from. Once the item has been created, you can add additional suppliers from within the inventory section of IQ.
  3. Owned by - You can specify if the material is owned by the 'Factory' (you), 'Supplier' or 'Customer'.
  4. Weight - You can enter a weight for the item 'per unit'.
  5. Quantity on Hand - If you already have stock on hand when you create the material, you can enter the qty here. 




Checkboxes:
  1. Awaiting Delivery - This is just a flag you can check on if when creating the material and say the customer is sending it directly to you, you can mark it as awaiting delivery and you can filter this on the inventory screen for tracking purposes.
  2. Manage Stock Levels - Check this on if you want to manage the stock levels of the material. This allows you to do a 'pick' on the item from within a jobs 'Stock Pick' screen.
  3. Active - Turns the item from 'Active' to 'Inactive'.

At the top of the screen are some additional tabs:


Modifying Material Sets


Material Sets - When a material is created, a material set is generated using the items 'code.
You always need the material linked to at least one material set as the material set is what you link to within a pricing component line:


If an operation requires multiple materials, you can create your own material set (enter a name and 'add').
You can then go into multiple materials and add that new material set to its list.
One material can be linked to as many different materials sets as you require.

Price Modifier - If you want the materials on this set to have a default 20% added to their price, you can enter '1.2' into this field


Quantity Modifier – This field allows you to set the quantity per item of materials required for the material set.
In the below example, we have a material setup to be ordered ‘Per Unit’:


On the material set, we have configured ‘packs’ of screws. 
The quantity required can be set/selected depending on the item being quoted.


Against the operation component, we have 3 options linked to each material set:


On the quote you can select the required option:


The material will multiply per unit ordered and display throughout printIQ:





Calc Types




Sheet area {AreaLongUnitName}
Area of All Sheets, ignoring press spoils

Finish area {AreaLongUnitName}
Area of the finished job

Print Sheets
Count of all sheets

Operation Price
Quantity of 1

Per Unit
Job Quantity

Per Page
Job Quantity * Number of Pages

Job - {LengthLongUnitNameSingular} width
Job Quantity * Job Width

Job - {LengthLongUnitNameSingular} depth
Job Quantity * Job Depth

Job - {LengthLongUnitNameSingular} height
Job Quantity * Job Height

Job - {AreaLongUnitNameSingular} area
Job Quantity * Job Area

Job - {VolumeLongUnitNameSingular} volume
Job Quantity * Job volume

Job - {WeightLongUnitNameSingular} weight
Job Quantity * Job Weight

Job - perimeter
Job Quantity * Job Perimeter including any inner 'tiling'

Flat Per Page
Pages per item

Sheet - {LengthLongUnitNameSingular} length
Total Sheet Length + Any Defined Extra Per Sheet

Sheet - {LengthLongUnitNameSingular} width
Total Sheet Width + Any Defined Extra Per Sheet

Roll Applied to Sheets
Roll Applied to Items
Calculation applies to both items and sheets, ‘items’ applies to individual items, ‘sheets’ to the whole printed sheets

Take the Material Width Defined
If the material width covers the sheet across the long edge (MatWidth > LongEdge)
material goes across the long edge, length is (ShortEdge + extra) * Quantity
else
material goes across the short edge, length is (LongEdge + Extra) * Quantity

Roll Applied to Sheets w/ slit
Roll Applied to Items w/ slit
Calculation applies to both items and sheets, ‘items’ applies to individual items, ‘sheets’ to the whole printed sheets

Take the Material Width Defined
If the material has no overhang over the long edge (MatWidth >= LongEdge)
material goes across the short edge, length is (LongEdge + Extra) * Quantity
else
material goes across the long edge, length is (ShortEdge + extra) * Quantity

Plate Finish Area {AreaLongUnitName}
Job Area * Number of Plates * NUp

Plate Sheet Area {AreaLongUnitName}
Sheet Area * Number of Plates

Plate per unit
Number of plates

Tile - Join {LengthLongUnitNameSingular}
Length of all joined edges for tiles

Shape Output
Reference a Calculated Shape output by name, this value * quantity

Items Along Perimeter
Items Along Component Defined Length

These use the same calculation, Perimeter is Width * 2 + Depth * 2,
Component Defined uses Width * WidthMultiplier + Depth * DepthMultiplier from the component record
Options are roundup or round down and apply to total or apply to each edge.

if applying to all calculate how many items fit along the full length then round
    Number of Items per unit = ROUND(((Width * WidthMultiplier + Depth * DepthMultiplier) / Gap)
else calculate and round each edge separately
    Number of Items per unit = (ROUND(Width / Gap) * WidthMultiplier) + (ROUND(Depth / Gap) * DepthMultiplier)

Total Items = Number of Items * Quantity

You can set a default quantity to be added in addition to the calculated quantity.
Using the fields:
Extra total items - Sets an additional quantity to add to the calculation 'per item'
Extra items per edge - Sets an additional quantity to add to the calculation 'per edge' configured on a component (defined using component options 'Component Length Width/Depth Multiple')

Job - {LengthLongUnitNameSingular} from component
Job Width * ComponentWidthMultiplier + JobDepth * ComponentDepthMultiplier

Number of Packs
Material calculation based on the number of packs configured when using 'Packs' functionality on quotes

Job - Assembled Perimeter
Job Quantity * Job Perimeter excluding any inner 'tiling'


Notes on calc types
Calculation types below do not work with Job Based Operations:
  1. Sheet area {AreaLongUnitName}
  2. Finish area {AreaLongUnitName}
  3. Print Sheets
  4. Sheet - {LengthLongUnitNameSingular} length
  5. Sheet - {LengthLongUnitNameSingular} width
  6. Roll Applied to Sheets
  7. Roll Applied to Sheets w/ slit
  8. Roll Applied to Items w/ slit
  9. Roll Applied to Items w/ slit
  10. Roll Applied to Items
  11. Plate Sheet Area {AreaLongUnitName}
  12. Plate Finish Area {AreaLongUnitName}
  13. Plate per unit
  14. Cylinder Plate Area

Export/Import

You can use the Export and Import options to export all or a filtered set of materials from the Materials Admin board to CSV.

Details of the materials can be changed and / or the pricing updated before importing the CSV back into printIQ to update those materials.
[refer to the Bulk Materials Upload screen for a detailed description of the calculation requirements to set up the Calculation Types]  

 



GL Account

The CSV also exports the inventory expense GL Account Code, if set on the Inventory Record.
Clearing the contents on the CSV (if set) and uploading would remove the expense GL accounts against that inventory record for the material.




Material Categories 

Material categories are a comma separated list of category names in the CSV.
New categories will be added automatically and any existing categories on the material that are not on the CSV when it is re-uploaded will be removed from that material. 



The material with three categories above shows up as...



Material Sets 

Material sets are downloaded to the export CSV.
They are listed as comma separated values (when there is more than one material set defined)
Each material set in the CSV has three fields  - Material Set Name, Price Modifier and Quantity Modifier...



The material with two Material Sets above displays as...





    • Related Articles

    • Inventory Items

      This is where you create and manage all inventory items that are not directly related to an individual job. Inventory > Items. From here you have several options you can use to search on the items to require to view:     From the main screen, you can ...
    • Material and Labour Sets

        The following procedure outlines how to setup a new material or Labour set in PrintIQ. All this is managed from Admin>Configure Factory scroll to the bottom to find the Advanced Materials section. Open Advanced Material and Labour Sets.     Go to ...
    • Creating Paper Stocks, Materials and Sales Items linked to the same Inventory Item

      Creating linked Inventory Items. While creating inventory (stock) items that are linked to the same stock item you first need to divide your stock into two types. Paper Stocks, Material Stocks The difference between the types is listed below in the ...
    • Bulk Upload IQstore Items

      IQ Store Items can be created and modified in bulk using the sales item import / export options on the IQStore Admin screen toolbar. Download the CSV Selecting Import from the drop-down menu will open a file selector to select the CSV for upload. The ...
    • Transfer into inventory workflow

      Production based jobs can often involve the top-up/fulfilment of inventory items. With this workflow, a quote or a job's dispatch option is set to ‘Inventory Transfer’. Inventory Transfer QUOTE – Select ‘Inventory Transfer’: At the job stage, the ...