Module name

Assortment Analysis

Trigram: AA

v2011231225

Tutorial

Value

'Assortment Analysis' allows the user to count the number of new products in a market, the number of discontinued products, as well as the renewal rate of products in a market.

Data sources

Geographic territories

  • Metropolitan France data
  • Corsica (Option)
  • DROM-COM (Option): Guadeloupe, Reunion, Martinique, Guyane

Market

  • No limitation on the size of the markets
  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products

Status

Subscription

Sales & Marketing Essential

Objects found in the sheet

  • Functional cartridge
  • Time selector
  • Indicator buttons
  • Company selector
  • Hierarchical selector
  • Network selector
  • the Multiple Chart / Table Object allowing the display of the indicators listed below.

Indicators

  • Products wide assortment ( PWA ) : total number of active products based on GTIN. A product is considered 'active' provided it has been sold at least once over the time period PWA
  • New products assortment ( NPA ): total number of products active over the selected time period, but inactive over the previous time period
  • New products assortment rate ( NPAR ): Penetration rate of NPA over PWA. (3) = (2) / (1)
  • Ended products assortment ( EPA ): total number of inactive products over the time period
  • Ended products assortment rate ( EPAR ): churn rate of inactive products (5) = (4) / (1)
  • Renewal products assortment ( RPA ): Difference between new products and ended products. This gives you an indication on whether your number of products grows or decreases. (6) = (2) - (4)
  • Renewal products assortment rate ( RPAR ): Renewal rate of the assortment (7) = (6) / (1)

Options

N / A

Limitations

NA

Versions

Current version:

Assortment Analysis v2011231225

  • Changed the color definition of the bar chart as well as the line chart (Intenal Technical Improvement: From $ (v_DimSelect_AssAn) to '$ (v_DimSelect_AssAn)')

Old versions:

Assortment Analysis v2010011755

  • Switching for all bar-graphs and line-graphs from a 12-color palette (automatic mode) to a 100-color palette for more readability.

Assortment Analysis v2009301759

  • Replacement of the drop-down selector according to the Grid.

target9> Assortment_blank6200

  • Addition of the "Data Input" Warning within the traceability cartridge

Assortment Analysis v2006221015

  • Setting up conditional display for the Network selector.

AssortmentVank07 Target Analysis>

  • Module recipe version v2004271727 of the standard; no change compared to version v2004070930 of this module


Assortment Analysis v2004070930

  • Added value labels to the "Stack Bar".
  • Variability of the subscription within the cartridge.

Assortment Analysis v2003271932

  • Standardization of the placement of "Reload Time" on the SMA standard

Assortment Analysis v2001131044

  • Variability of the entire right-hand side (labels and explanations of the indicators).

Assortment Analysis v2001071433

  • Repositioning the selector according to the grid Removal of the Network filter (only on the TMA version)

Assortment Analysis v1911061111

  • Added help links to indicators within the sheet.

Assortment Analysis v1911051000

  • First standardized version of the sheet.
Did this answer your question?