Copy of ecom pricing 2025.xlsx

	B	C	E	F	H	I
1
2	Ecom Pricing Sheet
3	Ecom Pricing Sheet
4
5	COST		CONFIG		SALES
6	Product cost	1,000.00	Quantity	120.00	PSP (product selling price)	2100
7	Delivery fees	0.00	Dead inventory rate	0%	Defective rate	0%
8	Confirmation fees	0.00	Sold	120	Return rate	20%
9	Packaging fees	65.00	Order intake	150	Refund	0%
10	Unitary fixed cost	6.67	Confirmation Rate	70%	Exchanges	0%
11	Fixed cost		Return fees	50.00
12	Rental	0.00	Ads cost	$1.00	Total revenue	252,000.00
13	الموظفين	0.00	USD to DZD rate	240.00	COGS	128,600.00
14	Communication	0.00			Dead inventory cost	0.00
15	Dev	0.00			Ads	51,428.57
16	Transportation	0.00			Refund cost	0.00
17	Other	800.00			Exchange cost	0.00
18	Total fixed fees	800.00			Return cost	1,500.00
19	Unit cost	1,071.67			Defective cost	0.00
20					Total cost	181,528.57
21
22	Legend				NET PROFIT	70,471.43
23		to be changed		.
24		automatic calculation			ROI	38.82%
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