If you have a Commodity IQ (CIQ) subscription, we provide access to commodity trends and intelligence in Supplyframe CPQ.
This information is visible only when CIQ is enabled within your account. Please contact Support if you need assistance activating this feature.
Accessing Commodity IQ
To access CIQ data within CPQ, click on the Commodity Intelligence Cube buttons in the Quoted column of the List View page:
CIQ trend data are presented in a side panel that opens on the right hand side of your screen:
We also show the Commodity Intelligence Cube in the Item Details page of parts in your catalog:
To learn more about commodities, click OPEN IN COMMODITY IQ to see additional details. Note that this is only available for categories and not sub-categories.
CIQ Details
You can read information on the different indicators of CIQ as provided below.
CIQ Dimensions
Key electronics and related supply chain dimensions across commodities are curated by industry professionals, including category/commodity, procurement, and supply chain leadership, and finalized by integrating Supplyframe analysis and partner expert inputs. Dimensions represent at-volume and contracted supply chain activity and are forecast on a rolling four-quarter basis.
Electronic Component Supply Chain Indicators
Commodity indicators are normalized, indexed signals and activities across the Supplyframe Design-to-Source Intelligence (DSI) Network, which include inputs from electronics distributors, manufacturers, EMS providers, original equipment manufacturers, and other partners.
Forecasts for Commodity IQ contextual analytics are performed using a time-series methodology, and the forecast model employed is a triple-exponential smoothing formula known as the Holt-Winters method. This method incorporates an exponentially weighted moving average that accounts for seasonality.
Commodity IQ users can select either the Holt-Winters or the SARIMA method and change the forecast period from one to six months. Like Holt-Winters, the SARIMA method is one of the most widely used forecasting methods for univariate time series estimates. This method features an autoregressive integrated moving average with seasonality and trend accountability.
Design Index (Visibility in CIQ only) and Demand Index express billions of normalized, indexed signals and activities across the Supplyframe DSI network, with a baseline of 100 representing the 2020 monthly median for each commodity and sub-commodity. The Design Index represents engineering design cycle patterns via activities such as CAD model downloads. The Demand Index represents sourcing patterns via activities such as e-commerce transactions and RFQs.
Price Index is calculated from the average daily lowest price for any given manufacturer part number (MPN), which is baselined against the monthly median for the MPN and aggregated for commodity and sub-commodity views.
Inventory Index is calculated from the average daily inventory for any given MPN, which is baselined against the monthly median for the MPN and aggregated for commodity and sub-commodity views.
Lead Time Index is calculated from the average daily lead time for any given MPN, which is baselined against the monthly median for the MPN and aggregated for commodity and sub-commodity views. The At-Volume Lead Time Trend expresses contracted lead time quotes, purchases, and deliveries based on thousands of MPNs for each commodity across millions of data points and is banded by week time frames.
All indicators are not necessarily available across all Commodity IQ sub-commodities.