Walk analysis example.xlsx

	B	C	E	F	G	I	J	K	M	N	O	Q	R	S	T	U	V	W
1
2			b			e			e-b
3	LoB	Product	Value	sales	margin	Value	sales	margin	Value	sales	margin	Value (b)	sales	Mix	Value (e)		walk analysis

4	A	1	10	200	5.0%	20	400	5.0%	10	200	0%	10	20	20	20		Production Value	193
5	A	2	20	100	20.0%	25	200	12.5%	5	100	-8%	20	40	40	25		Value Buz mix by LoB	120
6	A	3	30	50	60.0%	25	500	5.0%	- 5	450	-55%	30	300	300	25		Value Buz mix within LoB	174
7	B	4	15	400	3.8%	5	250	2.0%	- 10	- 150	-2%	15	9	9	5		Margin	- 532
8	B	5	25	500	5.0%	45	700	6.4%	20	200	1%	25	35	35	45
9	B	6	50	500	10.0%	80	700	11.4%	30	200	1%	50	70	70	80		Check	0
10	B	7	35	600	5.8%	40	100	40.0%	5	- 500	34%	35	6	6	40
11	C	8	100	200	50.0%	150	300	50.0%	50	100	0%	100	150	150	150
12	C	9	200	300	66.7%	150	400	37.5%	- 50	100	-29%	200	267	267	150
13	C	10	300	400	75.0%	200	500	40.0%	- 100	100	-35%	300	375	375	200
14	Totale		785	3,250	24.2%	740	4,050	18.3%	-45	800	-91%	785	978	1,272	740
15
16	A	All	60	350	17.1%	70	1,100	6.4%	10	750	-11%	60	189	189	70
17	B	All	125	2,000	6.3%	170	1,750	9.7%	45	- 250	3%	125	109	109	170
18	C	All	600	900	66.7%	500	1,200	41.7%	- 100	300	-25%	600	800	800	500
19	Totale		785	3,250	24.2%	740	4,050	18.3%	-45	800	-32%	785	978	1,098	740
20
21
22
23
24
25
26
27
28
29														Base	Start_End	Pos	Neg	Labels
30												Value	785		785			785
31												sales	193	785		193		978
32												Value Buz mix by LoB	120	978		120		1,098
33												Value Buz mix within LoB	174	1,098		174		1,272
34												Margin	- 532	740			532	1,272
35												value (e)	740		740			740
36												Check	- 0
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100