Calculation details

Sell out

Current turnover: (sum of sales values since the start of the simulation) + If DV Current Strata > 0, (average of sales values since the start of the simulation / panel period x number of days between the last date of last value data and the date of movement of the product), otherwise 0 + (average of sales values following the selection / average of DV Panel following the selection / panel period x weight DV current strata x number of days between the date of movement and the end date of the simulation)

CA Scenario: (sum of sales values since the start of the simulation) + If DV Current Strata > 0, (average of sales values since the start of the simulation / panel period x number of days between the last date of last value data and the date of movement of the product), otherwise 0 + (average of sales values following the selection / average of DV Panel following the selection / panel period x DV scenario strata weight x number of days between the date of movement and the end date of the simulation x coefficient of increase in diffusion OR DV ranges x free coefficients)

Gross turnover evolution: scenario turnover - current turnover

Current profitability: current turnover x sell-out profitability of the product (brand or global)

Profitability scenario: CA scenario x sell-out profitability of the product (brand or global)

Gross profitability evolution: scenario profitability - current profitability

Current volume: (sum of sales volume since the start of the simulation) + If DV Current Strata > 0, (average of sales volume since the start of the simulation / panel period x number of days between the last date of the last value data and the date of movement of the product), otherwise 0 + (average of sales volume following the selection / average of DV Panel following the selection / panel period x weight DV current strata x number of days between the date of movement and the end date of the simulation)

Volume Scenario: (sum of sales volume since the start of the simulation) + If DV Current Strata > 0, (average of sales volume since the start of the simulation / panel period x number of days between the last date of last value data and the date of movement of the product), otherwise 0 + (average of sales volume following the selection / average of DV Panel following the selection / panel period x DV weight of scenario strata x number of days between the date of movement and the end date of the simulation x coefficient of increase in diffusion OR DV ranges x free coefficients)

Gross volume evolution: scenario turnover - current turnover

Sell in

Current turnover: (sum of sales values since the start of the simulation) + If DV Acc > 0, (average of sales values since the start of the simulation / sell in period x number of days between the last date of last value data and the date of movement of the product), otherwise 0 + (average of sales values following the selection / DV Acc / sell in period x weight of current DV strata x number of days between the date of movement and the end date of the simulation)

CA Scenario: (sum of sales values since the start of the simulation) + If DV Acc > 0, (average of sales values since the start of the simulation / sell in period x number of days between the last date of last value data and the date of movement of the product), otherwise 0 + (average of sales values following the selection / DV Acc / sell in period x DV weight of scenario strata x number of days between the date of movement and the end date of the simulation x coefficient of increase in diffusion OR DV ranges x free coefficients)

Gross turnover evolution: scenario turnover - current turnover

Current profitability: current turnover x sell-in profitability of the product (brand or global)

Profitability scenario: CA scenario x profitability in out of the product (brand or global)

Gross profitability evolution: scenario profitability - current profitability

Current volume: (sum of sales volume since the start of the simulation) + If DV Acc > 0, (average sales volume since the start of the simulation / sell in period x number of days between the last date of the last value data and the product movement date), otherwise 0 + (average sales volume following the selection / DV Acc / sell in period x DV weight current strata x number of days between the movement date and the end date of the simulation)

Volume Scenario: (sum of sales volume since the start of the simulation) + If DV Acc > 0, (average of sales volume since the start of the simulation / sell in period x number of days between the last date of last value data and the date of movement of the product), otherwise 0 + (average of sales volume following the selection / DV Acc / sell in period x DV weight current strata x number of days between the date of movement and the end date of the simulation x coefficient of increase in diffusion OR DV ranges x free coefficients)

Gross volume evolution: scenario turnover - current turnover