BOM Compare: Bill of Materials Management Follow

Once a program is created, and a Bill of Materials (BOM) is ingested, the user can click on the BOM management sub-tab to view all versions and revisions and if desired and can edit the latest version.

Note: Users must have editing rights and "check out" to take these actions.

View BOM Revision

Once in the most recent BOM Revision, the user can hover over the program title and see a tooltip which provides a quick reference summary of information such as Product Family, Reference Cost Quarter, Expected Rollout Date, Forecast, Current Stage and Target Cost.

Within the BOM Revision view, the user can diagnose the BOM for missing information and correct those attributes to ensure an accurate BOM.

Scrolling to the right in the BOM revision view, there is a "Comment" column allowing the user to add their latest comment at a part level either from the UI or from the Excel upload. The user must use the check-out feature to make comments.

Details for the user are also available in an Excel download from this screen.

Note: We offer benchmark opportunities for the following:

• Customer Part Number (CPN) Level
  • Alternative CPN opportunity
  • Lowest CM/ODM Cost opportunity
  • Multisource opportunity
• Manufacturer Part Number (MPN) Level
  • Benchmark opportunity (90^th Percentile / Best-in-Class)
  • Part Match opportunity
  • Internal MPN Lowest Cost opportunity

The LevaData Recommended Cost column will now show the Target Cost (i.e. the lowest cost calculated from the above six opportunities).

At Sub-Assembly (SA) level it is the extended aggregation of the LevaData Recommended Cost of all CPNs underneath the Sub Assembly

Note: If the Sub-Assembly has sourcing (MPN) information, Target Cost will be prioritized as follows:

1. Aggregation of SA MPNs
2. Roll-up of CPNs underneath

At CPN Level

It will be the lowest cost amongst Alternative CPN, Lowest CM/ODM Cost, Multisource, weighted average Benchmark (90^th Percentile), weighted average Part Match and weighted average Internal MPN Lowest Costs.

At MPN Level

It will be the lowest cost amongst Benchmark (90^th Percentile), Part Match and Internal MPN Lowest Costs.

Note:

• MPN Level LD Recommended Cost = Min Target Cost (MPN lowest, benchmark, part match)
• CPN Level LD Recommended Cost = Min Target Cost (Alternative CPN, Lowest CM/ODM, Multisource, weighted average Benchmark (90^th Percentile), weighted average Part Match and weighted average Internal MPN Lowest Costs)
• Sub-Assembly Level LD Recommended Cost
  • With Sourcing Information = sum (weighted avg of MPNs LD Recommended Cost * Quantity)
  • Without Sourcing information / with CPN information = sum (CPNs LD Recommended Cost * Quantity)

Users will also be able to view the Max Opportunity shown in this screenshot below (Note: highest opportunity is derived from lowest target cost) at Unit Product Forecast level as well as Total Product Forecast level (Total Product Forecast is the number entered by the user while configuring the Program).

This Excel spreadsheet will not be in the Structured BOM format, as this will increase the number of columns to a great deal; however, the individual lever target costs are included.

Note: Any changes in the master part record (see: BOM Compare: Dashboard & Overview) can be synced to BOMs in active programs and users can compare and confirm changes.

Highlighting Changes and Errors in the BOM

Show Errors option is in both the BOM overview and checkout page. Users can disable or enable showing errors using the Show Errors checkbox. When the Show Errors checkbox is enabled, the errors are highlighted with a red-colored border. In addition, the grid filters the parts that only contain errors along with its parent and children in the sub-assembly.

Show Changes highlights the recent changes with a light-blue-colored border and also filters the modified parts with its parent and children in the sub-assembly.

Additional Filters for View BOM

Three filters are available to help rapidly analyze the BOM and identify CPN with missing cost or where there is discrepancy between contract manufacturer-provided cost and internal cost secured for sourcing team, for full details on these filters, please see: What filters are available to uncover costing issues in my bill of materials?

Structured vs. Flattened Bill of Materials View

• Structured BOM provides a display of all parts that are directly or indirectly used in a parent item. Structured BOM is the default BOM view. It is most useful when you are trying to compose a bill of materials and will be using some sub-assemblies as well as some parts.
• Flattened BOM is a list of all parts from all levels of the Structured BOM listed together with total quantities. Users can toggle to the Flattened BOM view in the interface. It is most useful when you are trying to source all of the parts and build all of the components in-house.
• For a full overview, please see: How can I analyze my bill of materials in a flattened view?

Flattened BOM

A flattened Bill of Materials (BOM) combines like items in a single line and aggregates its quantity factoring in its usage in the BOM thereby providing users with an alternate view of the BOM to complete the action at hand with agility.

Toggle View

Users can switch between structured and flattened BOM views using the “Switch BOM View” menu on the BOM management page. This preference is preserved after toggled so that the last selected BOM view type is maintained when the user logs back in or navigates back to BOM Management from other areas of the platform.

Flattened BOM Checkout

Uses can check out the Flattened BOM to edit the sourcing attributes of parts.

Download/Export the Flattened BOM to Excel Workbook

Users can (1) navigate to BOM Management and (2) while toggled to the flattened view of the BOM and (3) select Download BOM. The user will receive an Excel Workbook organized in the flattened BOM view.

Notes:

1. For any edit to the BOM structure, the user must switch to the Structured BOM view.
2. Users can edit sourcing attributes on the part in either view. Autofill from Parts Data Management (PDM) is also available for both structured and flattened BOM type. Please note that you can only edit sourcing attributes but not add a new source from the flattened BOM view.
3. User can expand Customer Part Number (CPN) to see MPN associated with CPN.