What are the expected values for the default BOM Template? Follow
After creating or opening an existing program in the BOM Dashboard of BOM Awareness, users will need to Add BOM in BOM Management to populate the first revision of their Bill of Materials.
When Add BOM is selected, the user must create a revision format (e.g., Rev-1, Rev A, etc.) and identify a source for the BOM.
If you are not copying an existing BOM, you will have to download the BOM template, fill it out, and then upload that file to create the first revision of your BOM.
The template is available once you click "Select Source"
LevaData Bill of Materials Template Structure
LevaData currently supports a Horizontal BOM format. The Horizontal BOM has one row record per item. When you configure a new BOM Program, you can choose a Product Family. This should be your Level 0 record input in the first row of the template. The Product is then Level 1.
Your CPN > MPN items are loaded in at Level 2 with the CPNs forming a unique row under the heading Part Number, and then any unique supplier/manufacturer/MPN combinations beyond that being individual vertical items against that horizontal row. An illustrative example is depicted below:
Let's discuss the details of this and provide an example template file for you to review.
Basic Fields for Standard Bill of Materials
The BOM Template has numerous columns underneath which you can add rows of information with the following values. Bold fields listed in the table below are columns that must exist in the template. However, depending on the field, it may be acceptable to leave the cell blank (Null values allowed).
| Header Column Field | Description |
|---|---|
|
Level (Required) |
Hierarchical number of the Product Family/Assembly > Product/Sub-Assembly > CPN 0. Product Family / Assembly (Required) 1. Product / Sub-Assembly (Required) 2. CPN > for each CPN, associated MPNs are loaded horizontally in the supplier/manufacturer/parts fields. |
|
Part Number (Required) |
Your organization's part number for this item. |
|
Description (Required) |
Description of the Part. Null values are allowed. |
| Revision | Revision Number of the Part. Leave blank if you are uploading BOM for the first time as the system will assign it a Revision based on your configuration. |
| Sub Commodity | The sub- commodity / category of the part. |
| Commodity | The commodity / category of the part. |
| Commodity Manager | The name of the individual who manages this commodity. |
| Unit of Measure | Unit of measure for pricing purposes, (e.g. each, carton, reel, etc.) |
|
Quantity (Required) |
Usage quantity for this part. |
| Reference Designator | Text field for part identifiers. Reference Designators typically start with a device character and then a number (e.g. Resistor #3 = R3) |
|
Cost Rollup Flag (Required) |
Should the cost of the item be included in the cost of the product?
|
| Maturity Level |
Lifecycle stage of the part, rated from 1-5.
|
| Comments | Any comments to add about the part. |
Optional Fields for Alternate Parts and Costs for Multiple Suppliers / Manufacturers
After filling out all of the main row items from Level to Comments, you are able to fill out associated entries for up to seven individual supplier/manufacturer combinations. This can be done to itemize the alternate parts you have already sourced for your Bill of Materials.
Supplier / Manufacturer / Part Fields
You can include up to 7 individual supplier/manufacturer combinations in the default template. The value listed as # in the below table is meant to be iterative - i.e. you can have a matching set of all information below for each of your unique supplier/manufacturer combinations from 1 to 7.
| Header Column Field | Description |
|---|---|
|
Supplier # (Required to Autofill Insights) |
Name of the supplier. |
| Supplier Item Number # | The supplier's part number. |
| Supplier Item Name # | The supplier's part name. |
|
Manufacturer # (Required to Autofill Insights) |
Name of the manufacturer. |
|
MPN # (Required to Autofill Insights) |
The manufacturer's part number. |
| Manufacturer Item Name # | The manufacturer's part name. |
|
Cost # (Required for Savings Opportunities) |
The cost of the part. If you include this in your BOM, then savings opportunities can be calculated against what you are currently paying. |
|
Split % # (Required to Add up to 100 at Each Individual Level) |
The share of purchasing you assign to this supplier/manufacturer part combination at your customer part number level. Percent number value from 0-to-100. If you have multiple unique Supplier/Manufacturer/MPN in a row against one CPN, then Supplier/Manufacturer/MPN 1 should be in own unique column and Supplier/Manufacturer/MPN 2 should be in own unique column and their split should add up to 100.
|
| Comments # | Any comments to add about this part combination. |
Example BOM
The file "Demo BOM Test" attached to this article (or available by clicking the link in quotes) is a structured BOM with demo data that can be uploaded into your tenant. You can modify this sample with your own parts in order to conduct a test of the feature.
The Demo BOM Test demonstrates the unique part numbers by level on each row:
When a unique supplier/manufacturer/MPN combination is present against any given CPN row, those values are broken out into their own individual columns so that they can be uniquely identified and have their cost attributes analyzed by the LevaData Platform.
In the platform these unique supplier/manufacturer/MPN combinations with their unique costs presented as nested line items:
Then when Production Parts Autofill is run, the BOM cost items are calculated automatically by the LevaData Platform. Providing you with Benchmarks, Leadtimes, and available links to lowest costs available on Distributor websites.
LevaData Platform Cost Fields
These values will generally be populated if you have ran the BOM through LevaData BOM Awareness before, but otherwise will likely be empty. You are not expected to fill these values out, they can be re-populated on a new BOM Revision by using Production Parts Autofill (PPA). Using PPA after BOM upload will also overwrite any existing benchmark cost and leadtime values with updated data from the platform.
| Header Column Field | Description |
|---|---|
| 90th % Benchmark # | Estimate of price point where 90% of the market has your price or higher. |
| Average Benchmark # | Average price paid for this part across all platform data. |
| eBenchmark MPN+FFF Benchmark # | The price target when comparing your MPN price against the average discounted price that the community achieves compared to distribution pricing for the same MPN, or for a cluster of Form, Fit, and Function (FFF) MPNs. |
| Distributor Lowest Cost | Determines the lowest authorized distributor price. |
| Manufacturer Median Leadtime # | Market leadtimes for this manufacturer part number. |
| Customer Median Leadtime # | Your leadtimes for this manufacturer part number. |
| Leadtime Difference # | The difference between your stated leadtime and the market listed leadtime. |
If you want to learn more about how these part insights are used across the LevaData Platform, review:
Wrapping Up
Once you have completed mapping your BOM to the BOM Template, you can save the file and upload it into the LevaData Platform via the same BOM Source Upload BOM area where you Downloaded the Standard Template.
Once finished, you will be able to review, modify, autofill, and compare your BOM using BOM Awareness.
Comments
0 comments
Please sign in to leave a comment.