Sales Elasticity Analysis

Seasonally adjusted price-elasticity modelling tool.

parameters input
Price
(rub)		 Sell-in price
(rub)
Brand 1 0.5 HM 22.65 16.44
Brand 1 0.5 SM 22.89 15.77
Brand 1 1.0 HM 37.41 20.54
Brand 1 1.0 SM 38.28 21.4
Brand 1 2.0 HM 32.91 24.75
Brand 1 2.0 SM 33.01 24.61
Brand 2 2.0 SM 65.58 44.1
Brand 3 0.5 HM 37.67 23.07
Brand 3 0.5 SM 37.78 22.95
Brand 3 1.5 HM 49.76 39.55
Brand 3 1.5 SM 49.66 39.63
Brand 3 2.0 HM 68.35 48.91
Brand 3 2.0 SM 67.48 47.25
Brand 4 0.5 HM 36.59 22.45
Brand 4 0.5 SM 37.21 22.47
Brand 4 1.5 HM 49.74 39.71
Brand 4 1.5 SM 49.32 39.52
Brand 5 0.33 HM 33.52 16.48
Brand 5 0.33 SM 35.45 16.53
Brand 5 1.0 HM 33.08 31.53
Brand 5 1.5 HM 50.15 39.34
Brand 5 1.5 SM 49.87 39.68
Brand 5 2.0 HM 65.94 49.34
Brand 5 2.0 SM 67.23 48.57
Brand 6 0.5 HM 33.67 23.56
Brand 6 0.5 SM 32.8 23.45
Brand 6 1.5 HM 49.52 40.29
Brand 6 1.5 SM 49.56 39.77
Brand 6 2.0 HM 70.06 49.4
Brand 6 2.0 SM 68.83 48.19
Brand 7 0.25 HM 51.18 36.24
Brand 7 0.25 SM 53.66 35.39
Brand 7 0.449 HM 62.55 49.79
Brand 7 0.449 SM 62.23 51.55
Brand 8 0.449 HM 40.58 24.33
Brand 8 0.449 SM 38.26 23.99
Output forecast
Value
(qty)		 Profit
(rub)		 Elasticity
coefficient
Brand 1 0.5 HM 24.51 152.18
-0.09
Brand 1 0.5 SM 25.57 182.05
-0.08
Brand 1 1.0 HM 11.12 187.6
-0.05
Brand 1 1.0 SM 13.64 230.3
-0.04
Brand 1 2.0 HM 30.46 248.55
-0.07
Brand 1 2.0 SM 26.09 219.13
-0.05
Brand 2 2.0 SM 16.39 352.14
-0.03
Brand 3 0.5 HM 6.97 101.82
-0.07
Brand 3 0.5 SM 8.6 127.54
-0.04
Brand 3 1.5 HM 19.98 204.03
-0.06
Brand 3 1.5 SM 18.62 186.77
-0.04
Brand 3 2.0 HM 13.66 265.57
-0.05
Brand 3 2.0 SM 14.36 290.5
-0.03
Brand 4 0.5 HM 12.22 172.82
-0.08
Brand 4 0.5 SM 12.79 188.53
-0.07
Brand 4 1.5 HM 25.36 254.35
-0.05
Brand 4 1.5 SM 21.73 212.93
-0.04
Brand 5 0.33 HM 15.77 268.75
-0.06
Brand 5 0.33 SM 14.46 273.67
-0.07
Brand 5 1.0 HM 64.29 99.65
-0.05
Brand 5 1.5 HM 110.54 1194.95
-0.06
Brand 5 1.5 SM 77.64 791.2
-0.04
Brand 5 2.0 HM 107.98 1792.49
-0.05
Brand 5 2.0 SM 78.83 1470.88
-0.04
Brand 6 0.5 HM 8.59 86.81
-0.06
Brand 6 0.5 SM 10.4 97.21
-0.05
Brand 6 1.5 HM 13.2 121.79
-0.05
Brand 6 1.5 SM 12.44 121.8
-0.03
Brand 6 2.0 HM 9.9 204.49
-0.04
Brand 6 2.0 SM 10.26 211.73
-0.03
Brand 7 0.25 HM 25.45 380.29
-0.05
Brand 7 0.25 SM 21.21 387.54
-0.04
Brand 7 0.449 HM 99.26 1266.54
-0.05
Brand 7 0.449 SM 75.47 806.05
-0.03
Brand 8 0.449 HM 60.88 989.23
-0.08
Brand 8 0.449 SM 76.37 1089.83
-0.06
sales and promo history
for Brand 1 0.5 HM
Price elasticity
for Brand 1 0.5 HM
sales cleaning
for Brand 1 0.5 HM