Sub Assembly
Column-by-column details for the Sub Assembly tab of the data load spreadsheet
Parts that are of type Sub Assembly are made in-house then later consumed into another production step or finished good.
Part Number
Required - Alpha Numeric
Syncs with QuickBooks - Inventory Item Name
Anything uniquely tracked in inventory needs it's own part number. Add your existing part numbers to this column of the upload sheet. If you will be creating new part numbers, keep them simple. Smart part numbers are not recommended. Generally, a part number should be created for WIP/Sub Assemblies if they are not always consumed the same day they are produced.
Description
Required - Alpha Numeric
Syncs with QuickBooks - Inventory Item Sales and Purchasing Description
The description field holds the full text human readable definition/name of the part.
Produced By UOM
Required - Alphabetic
Produced-by Unit of Measure, is the measure most often given to this part after it has been PRODUCED. For example: If a Sub Assembly part is produced by the tote, then it's 'Produced By UOM' = tote.
Cost per Produced By UOM
Required - Numeric
*Syncs with QuickBooks - Inventory Item Cost
How much does it cost to produce this sub assembly? This standard cost equals the value of both inventory and labor/direct overhead inputs.
Hard to calculate?
This is often a hard number to calculate. Going forward DataNinja will track this for you automatically for each run. Why do you need to fill this in with our best guess now? - If you have any inventory on hand at the time of your first physical inventory labeling, we need to make sure it gets a good ballpark valuation when synced to your finance system.
QC Sampling Plan Required?
Required - Y/N
Whenever this sub assembly is produced, will samples need to be recorded and evaluated against pass/fail criteria?
Part Class
Optional - Alpha Numeric
Syncs with QuickBooks - Inventory Item Category
Class fields are used to "tag" parts into strata for sorting, grouping, and reporting. Used to group parts by category i.e. Bulk, WIP, Upper Assembly etc.
Other Classifications/Categories
*Optional - Alpha Numeric**
Do you have additional allergens, Classifications, or Categories? Use this column to capture extra details not recorded elsewhere. Your Implementation Engineer will help make sure this data is captured.
Examples
WIP Liquid
Bulk Blend
Kit Assembly
Pre-Mix
Batch Blend
Updated over 1 year ago