How can I import and analyze transformation costs for my bill of materials? Follow

The cost of building a product includes the cost of direct materials and transformation. Transformation is also known as Manufacturing Value Add (MVA) or Value Added Manufacturing costs (VAM). Within BOM Compare, users are able to track transformation costs along with BOM costs in one central location and understand their impacts on overall product costs for all new programs loaded into the LevaData Platform.

• Watch: How can I import and analyze transformation costs for my bill of materials? (2:36)

Transformation Cost (MVA)

Import MVA from Spreadsheet

1. Within the NPI Module, click into any Program name in NPI Dashboard

   

2. Within that Program, navigate to the BOM Management tab and select latest BOM revision.

   

3. Click on the sub-tab View Transformation, you can review the Transformation types and Transformation costs:

   

4. Selecting the Download button on the far right of the interface allows you to export the table data to an Excel Workbook and modify it

   

5. This file will be pre-populated with Transformation Type, Transformation Cost Amount and Roll Up Flag (Leave as 1, do not change). Note: Setting Roll Up Flag to 0 / No will prevent the transformation cost from appearing in Transformation Analytics view.

   

6. You can modify this Excel Workbook and add additional rows with Transformation Costs by Name (Column A) and their amount (Column B) with Roll Up Flag (Column C) input as 1 for each additional item:

   

7. After you have finished any changes you wish to make, save the file, then click into Please select file section of File Upload on the right of the interface, select your Excel Workbook, and finalize the upload by clicking the blue arrow adjacent on the right:

   

8. After the file is successfully uploaded, the new MVA costs are displayed in the View Transformation sub-tab and are sorted by cost amount by default:

   

9. Note: If you need to make further changes/updates, you can modify the Excel Workbook and re-upload.

View MVA Analytics

1. Click into any Program name in NPI Dashboard

   

2. Expand the Cost Profile Widget to drill into Cost Details while also noting that...
3. Current Cost is now a sum of Material Cost and Transformation Cost

   

4. Click on View Transformation sub-tab to see an expanded view of Transformation Cost along with a pie chart graph displaying percentage of distribution.
5. Hovering over an element in the pie chart graph brings up a pop-up tooltip with the individual slice of information.
6. On the right is a table with the same data accounting of Transformation Costs. The table can be exported to an Excel Workbook with the button in the upper right. Note: Any transformation cost with roll up flag set to 0/No is not going to be shown in the analysis view.