A B C D E F G H I J K L M N O P Q R S T U
1 Market share model
2
3 Inputs
4 Our current market share 45%
5
6 Parameters of triangular distribution of change in our market share - depends on who has a big promotional campaign
7 Minimum Most likely Maximum
8 Neither -0.03 0 0.03
9 Both -0.05 0 0.05
10 Only us -0.01 0.02 0.06
11 Only them -0.06 -0.02 0.01
12
13 Promotional campaigns (1 if promote, 0 if not) - enter any patterns you want to test in the following two rows
14 Quarter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
15 Us 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1
16 Them 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0
17
18 Simulation
19 Possible changes in our market share
20 Quarter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
21 Neither promote
22 Both promote
23 Only we promote
24 Only they promote
25
26 Tracking our market share
27 Beginning market share
28 Change in our market share
29 Ending market share