formula59.xlsx

	A	B	C	D	E	F	G	O	P	Q	R	S	T	V	W
1	Products	Cost	Margin	Price	units	Sales	7	Products	Cost	Margin %	Price	units	Sales	Calculation of Weighted Average Margin
2	Product 7	128	19%	$157,44	1	$157,44		Product 1	369	9%	$406	3	$1 217,70	22%	78%
3	Product 8	204	13%	$234,60	2	$469,20		Product 2	164	27%	$225	2	$449,36
4	Product 9	162	17%	$196,02	1	$196,02		Product 3	260	17%	$315	3	$943,80
5	Product 10	216	32%	$317,52	3	$952,56		Product 4	492	29%	$689	5	$3 444,00
6	Product 11	401	18%	$489,22	4	$1 956,88		Product 5	286	32%	$418	1	$417,56
7	Product 12	369	21%	$464,94	5	$2 324,70		Product 6	119	31%	$173	1	$172,55
8	Product 13	185	17%	$222,00	5	$1 110,00		Product 7	128	19%	$157	1	$157,44
9	Product 14	123	12%	$138,99	3	$416,97		Product 8	204	13%	$235	2	$469,20
10	Product 15	282	33%	$423,00	3	$1 269,00		Product 9	162	17%	$196	1	$196,02
11								Product 10	216	32%	$318	3	$952,56
12								Product 11	401	18%	$489	4	$1 956,88
13								Product 12	369	21%	$465	5	$2 324,70
14								Product 13	185	17%	$222	5	$1 110,00
15								Product 14	123	12%	$139	3	$416,97
16								Product 15	282	33%	$423	3	$1 269,00
17
18
19
20
21
22
23
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