Pineapple Necklace Calculation

	A	B	C
1
2	CALCULATION	PINEAPPLE NECKLACE
3	POSITION	Affiliate	Ads
4	Listed Selling Price	34.99	34.99
5	Discount or Affiliate Commission (15%)	5.25
6	Actual Selling Price	29.74	34.99
7	Product costs	7.32	7.32
8	Transaction Fee PayPal (3.4%)	1.01	1.19
9	Currency Change (2%)	0.59	0.70
10	Shopify Transaction fee (2 % [Basic Plan])	0.59	0.70
11	Returns (8 %)	0.59	0.59
12	Tax (19% [Germany])	5.65	6.65
13	Shipping Costs	0.00	0.00
14	Assumed Acquire Costs (eg. Facebook, Free Prod.)	1.46	7.00
15	Other fix costs (eg. Shopify, Apps)	1.16	1.16
16	Total costs	23.63	25.30
17	Profit	11.36	9.69
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