ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
GetPivotData
2
4
USD in 000s2015
Act		2016
Act		Var. Abs.
16 vs. 15		Var. %
16 vs. 15
5
6
Volume59,838 55,736 (4,101)-6.9%
7
8
Gross Sales55,549 52,597 (2,951)-5.3%
9
Discounts(3,600)(3,288)311 -8.6%
10
Net Sales51,949 49,309 (2,640)-5.1%
11
Cost of goods sold(27,712)(27,337)375 -1.4%
12
Gross Profit24,238 21,973 (2,265)-9.3%
13
Distribution(1,386)(1,417)(31)2.3%
14
Warehousing(554)(495)59 -10.7%
15
Full Delivered Margin22,298 20,061 (2,237)-10.0%
16
17
KPIs
18
Gross Profit %46.7%44.6%
19
FDM %42.9%40.7%
20
21
Net Sales per Unit0.870.88
22
Gross Profit per Unit-0.46-0.49
23
FDM per Unit0.410.39
24
25
26
27
28
29
30
31
32
33
34
35
36
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
101