Your BOM displays the following columns of information: IPN/CPN, Manufacturer Part Number, Manufacturer, Supplier, Qty, Price, Extended Price, Excess Cost, and Risk Index.
- IPN/CPN
- Manufacturer Part Number
- Manufacturer
- Supplier
- Qty
- Price
- Extended Price
- Excess Cost
- Risk Index
IPN/CPN
The IPN (Internal Part Number) / CPN (Customer Part Number) column displays the IPN/CPN loaded in your file, and will indicates with a folder icon if this IPN already exists in your Part Master. Clicking on an IPN/CPN filters your list for that part, while clicking on the “Part Master” folder icon next to an IPN will take you to that part’s page in your part library.
It can also show you any "Possible Matches" of MPNs to IPNs in your Paster Master if the IPN is missing. Clicking on +Select IPN will open the Select IPN side bar on the right. It will show any available matches within your Part Master. More information can be read about this functionality in the article on IPN Auto Matching.
There may also be cube intelligence icon next to your IPN. This cube will open the IPN's Intelligence in a side bar for quick visibility of that part's details for more information.
Manufacturer Part Number
The Manufacturer Part Number (MPN) column displays the selected part as matched to your file, or any suggestions / corrections that you made. It may show the following information: Commodity, OPN, Rohs Code, CO2e (mg), Life Cycle, Xref Form Fit Function availability, and Suggestions availability.
Clicking on the MPN cell opens the part information modal, which may display the following tabs of information as available.
- Did you mean? (Suggestions)
- Xref, Form Fit Function Equivalents (Alternates)
- Functional Equivalents
- Part Master Alternates
- Where Used
More information on the Suggestions and Xrefs (Alternates) are available in their respective articles.
When considering MPNs for various reasons, it can be useful to know if a certain MPN + Manufacturer combination is already in your Part Master. Additional data from the Part Master can be helpful to decide if an alternate part is one they want to work with, potentially replacing another part.
Aliases are being leveraged to identify the Manufacturer, as this feature is using the combination of MPN and Manufacturer together to match with the MPN and Manufacturer that exists in Part Master. When an MPN with its Manufacturer together exist as an alternate within your Part Master, you will see the icon to the right of the MPN.
There may also be cube intelligence icon next to your MPN. This cube opens Part Intelligence in a side bar so you can have easy visibility of the component's details for more context.
Manufacturer
You can see the selected Manufacturer being used to populate the pricing for your part. When it was mapped during your BOM upload, you will see what your “Requested Manufacturer” was within the Manufacturer cell.
When there was no exact match for your part, within the Manufacturer/Supplier cells, you will see any "Suggestions" and ways as available to correct your part. More information is available in the Suggestions article.
Note: MPNs added from the suggestions modal are subject to the price cost settings in order to determine the manufacturer.
Supplier
You will see the Supplier column populated with the distributor selected to currently price the part in your list. As available when provided by the supplier, you may see additional information in the cell such as: Stock, LT (Lead Time in Weeks), Min, and Mult.
When provided, there is Supplier Intelligence, which can be accessed at the line level within your BOM by clicking on the cube icon next to the respective supplier. You can see displayed in the supplier's side bar the tabs of: Info, Contacts, and Line Card.
The Info tab provides insight regarding your supplier such as their "Response Time" and other applicable information. You can then view your Contacts for the suppler and their current Line Card.
Qty
In the Qty (Quantity) column, you will see your original "Requested Quantity" to the left and its corresponding "Orderable Quantity" on the right. As applicable, you will see the different quantity breaks from your uploaded mapped quantity columns or from the use of multipliers by the stacking vertically.
The orderable quantity is based on the minimum order quantity (MOQ) for the part number, the standard package quantity (Mult) and the required quantity (Req. Qty). When the line item’s Min or Mult are missing, then the Orderable Qty = Req. Qty.
You can update your multiple mapped quantities for a part by clicking into the specific line’s requested / orderable quantity in the Qty cell. Type in the new requested quantity and then click on Save.
When using multipliers, as seen in this example above, you will only be able to update your original mapped requested quantity within that cell. As needed, you can change your entire BOM’s multipliers by clicking on Project and then on Settings.
Price
In the Price column, you can see which of the different price sources found results. When a price source has results available, you’ll see the source icons highlighted with text. Then a source icon in a blue box with a check mark indicates which one is being used as the price source for that line item.
Clicking on the cell will display additional pricing information. The modal shows the part's MPN, IPN, currently selected Manufacturer / Supplier, its Risk Index, as well as its Available / Requested Quantity. Then there‘s five tabs of information as available from your price sources and also a market analysis. You will see the following tabs:
- Price Analysis
- Contract Pricing
- Purchase History
- Quote History
- Specific Pricing
- Web Pricing
When market analysis data is available, clicking on the Price Intelligence cube in the cell will open up the modal on the “Price Analysis” tab. This displays analytics of the selected part in a graph.
Utilizing this analysis, you can evaluate data displayed and if it’s listed as a “Great Price”, “Market Average” or “Above Market”. You can also change the Quantity to see how it impacts the part’s market analysis.
Clicking on any of the price icons in the Price cell that have results will open the modal on the tab display of that particular source.
Within the Contract Pricing tab, you can see any available contract pricing information that may include:
- Manufacturer Part Number
- Manufacturer
- Supplier
- Start Date
- Expire Date
- Stock
- Quantity
- Currency
- Price
- Quota
- Min
- Mult
- NC/NR
- Pkg Type
- Excess Cost
- Lead Time
The Purchase History tab provides historical information if the part was previously ordered. This includes:
- Manufacturer Part Number
- Manufacturer
- Supplier
- Purchase Order Date
- Stock
- Quantity
- Currency
- Price
- Min
- Mult
- NC/NR
- Pkg Type
- Excess Cost
- Lead Time
Click on the Quote History tab for information if a part is quoted within the Quoting module. This includes:
- Manufacturer Part Number
- CPN
- Manufacturer
- Supplier
- Date
- Start Date
- Stock
- Quantity
- Price
- Min
- Mult
- Lead Time
- Excess Cost
- Pkg Type
Similarly to other pricing info shown in the pricing tabs, the Specific Pricing tab (Customer/API) identifies if a negotiated API price exists. The data displayed can include:
- Manufacturer
- Suppliers/Description
- Price
- Stock
- MOQ
- Package Multiple
- Package Type
- Excess Cost
- Lead Time
Lastly, you’ll see the tab of Web Pricing, along with any tiered pricing, or other data as available. The part’s description and details shown are dependent on what each distributor has provided to Supplyframe.
Extended Price
The Extended Price column shows the total cost for that line item based on the selected Price and your requested Qty.
Excess Cost
The Excess Cost column displays the calculated excess cost for each of your line items when the minimum order quantity (MOQ) is not met. The formula for Excess Cost is (Orderable Qty - Requested Qty) * Price.
Risk Index
The Risk Index empowers you to define and use risk metrics when analyzing parts inside BOMs. There is a default Risk Index that will be used across BOMs, until a customized index is created by your admins. Within Risk Index results, a scale is used to convey the riskiness of the part:
- Low (green): 0 - 30
- Medium (orange): 31 - 60
- High (red): 61 - 100
You can click on a part's Risk Index result in order to open the side modal for more details. At the top of modal, you'll see the name of the specific Risk Index being used to calculate the results.
Then you'll see the MPN that the results are displayed for and the total Risk Index number. Below will be the different factors and their rankings for the specific Risk Index that were calculated in order to provide the assessment.
Please see this Risk Index article for more information.