Component Utilization Reporting

Component Utilization Report Use Cases

  1. If you're running a CMT program, you can use a Utilization Report to gather all the projected material needs per Supplier across a Season, Collection, or other subset of products.
  2. By reporting on everywhere a given Component (or group of Components) is used, you can simplify change management.
  3. By reviewing "unused" Component utilizations on your Utilization Reports, you can quickly identify mistakes and/or Products where BOM work may not have been completed.

Navigating the Component Utilization Report LIbrary 

  1. You can access the report Library through a new dedicated icon in the Global Navigation
  2. Utilization Reports created by anyone on your team live within this library and are accessible to all
  3. You can search for a specific report by name at the top
  4. You can also sort your various reports by Name or Date Created
  5. Hovering over the 3-dot Overflow Icon at the right side of each report name opens a menu with the following options:
    1. Duplicate Report
    2. Edit Report
    3. Delete Report
  6. Open any report by clicking its name

Creating a new Component Utilization Report

  1. Click the “+” (add icon) within the Utilization Report Library
  2. Add a report Name (required)
  3. Add the Component Types you wish to report on
  4. Optionally refine your results by linking values from your filterable Component Custom Fields (Ex. limit your report to show Utilizations for just one particular Component Supplier or Country of Origin)
  5. You must either refine the content by Component Type or a Component Custom Field to generate the report
  6. Optionally, further refine your results by linking values from your Product Taxonomy and Product Custom Fields (Ex. limit your report to show Utilizations for just one Product Season/Year or just one Factory)
  7. Click the Create button and the report will be generate, open, and save to your Library

Navigating and Interpreting your Component Utilization Report

  1. Your report has a unique section for each Component which matches the report criteria.
    1. The Component Name and Component Code appear as headers for the section
    2. Clicking the header bar will collapse & expand the Component Section as needed
    3. You can also “Expand All” or “Collapse All” sections at the top of the page, depending on your needs
  2. The sort order of the report is alphabetical by Component Name
    1. The various utilizations for each unique Component Variant are sorted alphabetically by Variant Name, nested within each Component section
  3. The Utilization Report pulls data from the Component Record, the Product Summary and the Product BOM into one table.  The columns map as follows:
    1. Component Variant Name & Component Variant Code
    2. Product Name & Product Variant (Colorway)
    3. Product Style Number
    4. Consumption Quantity per the Product BOM
    5. Component Unit of Measure
    6. Component Variant Price
    7. Component Cost per Unit
  4. By clicking the Product Name in the table, you’ll be navigated to that Product’s BOM
  5. By default, the report  will only display utilizations where you’ve made a Component Variant selection within the BOM.  However, you can optionally “Show Unused Rows” at the top of the page - this allows you to see where the Component has been added to the BOM but no Variant has been selected.
  6. The 3-dot Overflow Icon at top right of the page allows you export your report to CSV
Watch this Live Training where our Director of Client Experience, Victoria Brewer, explains how to create, analyze and export these reports! 

Still need help? Contact Us Contact Us