CUSTOMER MARGIN CALCULATOR

Sellout forecasting, margin and revenue calculation.

parameters input (2019W40 - 2019W52 /2020W1 - 2020W13)
forecast features additional features margin features
FACINGS REGULAR SELLOUT PRICE LEAFLET DISCOUNT PROMO WEEKS NUMBER OF STORES SELLIN DISCOUNT REGULAR SELLIN PRICE
Brand 1 Multi 7.56 53.53 0.3 12.0 4 380.68 0.24 27.14
Brand 1 Single 8.12 39.75 0.31 11.0 2 793.67 0.22 19.59
Brand 2 Multi 2.29 69.87 0.28 12.0 5 789.13 0.32 37.76
Brand 2 Single 3.02 42.86 0.26 5.0 4 318.59 0.26 28.31
Brand 3 Multi 7.73 90.02 0.32 13.0 4 665.46 0.18 46.9
Brand 3 Single 5.3 41.78 0.2 11.0 2 522.02 0.2 25.0
Brand 4 Multi 4.0 79.33 0.35 10.0 7 622.88 0.28 45.92
Brand 4 Single 6.31 48.89 0.23 13.0 5 500.46 0.26 26.17
Brand 5 Multi 9.43 81.4 0.32 13.0 5 465.35 0.2 41.01
Brand 5 Single 6.1 42.07 0.15 11.0 4 425.27 0.16 23.93
Brand 6 Multi 8.27 88.14 0.31 13.0 5 997.6 0.18 46.99
Brand 6 Single 3.0 44.33 0.21 13.0 1 576.28 0.22 23.72
Brand 7 Single 10.22 104.32 0.32 13.0 5 241.39 0.34 58.35
Brand 8 Single 1.56 56.17 0.31 13.0 6 933.19 0.27 32.94
forecast output (2019W40 - 2019W52 / 2020W1 - 2020W13 )
VOLUME LITRES VALUE QUANTITY FRONT MARGIN %
Historical quarter Forecasted quarter Index % Historical quarter Forecasted quarter Index % Historical quarter Forecasted quarter Increase
absolute
Brand 1 Multi 2 901 867.66 2 887 808.88 99.52 1 825 074.0 1 816 232.0 99.52 45.05 45.09 0.04
Brand 1 Single 1 214 396.96 2 006 508.0 165.23 2 168 566.0 3 583 050.0 165.23 45.04 45.17 0.13
Brand 2 Multi 2 526 268.68 2 550 520.74 100.96 2 235 636.0 2 257 098.0 100.96 48.85 48.88 0.03
Brand 2 Single 689 340.33 745 295.88 108.12 1 406 817.0 1 521 012.0 108.12 33.95 33.95 0.0
Brand 3 Multi 2 055 693.6 3 191 160.96 155.24 1 202 160.0 1 866 176.0 155.24 37.17 37.17 0.0
Brand 3 Single 314 281.1 458 680.67 145.95 641 390.0 936 083.0 145.95 40.16 40.16 0.0
Brand 4 Multi 799 857.45 1 187 586.9 148.47 503 055.0 746 910.0 148.47 37.32 37.35 0.03
Brand 4 Single 280 646.52 270 523.12 96.39 572 748.0 552 088.0 96.39 48.56 48.56 0.0
Brand 5 Multi 19 708 771.73 24 041 101.46 121.98 12 091 271.0 14 749 142.0 121.98 40.73 40.73 0.0
Brand 5 Single 1 340 875.8 1 189 314.28 88.7 3 047 445.0 2 702 987.0 88.7 43.72 43.73 0.01
Brand 6 Multi 1 314 864.48 2 035 048.64 154.77 787 344.0 1 218 592.0 154.77 36.64 36.64 0.0
Brand 6 Single 172 034.59 238 425.67 138.59 351 091.0 486 583.0 138.59 47.17 47.17 0.0
Brand 7 Single 2 661 944.67 2 454 850.65 92.22 6 190 569.0 5 708 955.0 92.22 45.71 45.71 0.0
Brand 8 Single 1 861 431.24 1 778 337.12 95.54 3 960 492.0 3 783 696.0 95.54 37.96 37.96 0.0
TOTAL 37 842 274.81 45 035 162.97 119.01 36 983 658.0 41 928 604.0 113.37 42.12 41.97 -0.15
waterfall analysis for Brand 1 Single