Book.xlsx

	B	C	D	E	F	G	H	I	J	K
1	Online Sales Tracker
2
3
4
5
6
7
8
9
10
11
12
13
14
15	Item	Cost Per Item	Percent Markup	Total Sold	Total Revenue	Shipping Charge/Item	Shipping Cost/Item	Profit per Item (incl. shipping)	Returns	Total Income
16	[Item 1]	₹ 10.00	100.00%	15	₹ 300.00	₹ 10.00	₹ 5.75	₹ 14.25	2	₹ 196.75
17	[Item 2]	₹ 11.50	75.00%	18	₹ 362.25	₹ 10.00	₹ 5.75	₹ 12.88	1	₹ 224.63
18	[Item 3]	₹ 13.00	65.00%	20	₹ 429.00	₹ 10.00	₹ 6.25	₹ 12.20	0	₹ 244.00
19	[Item 4]	₹ 5.00	90.00%	50	₹ 475.00	₹ 5.00	₹ 3.50	₹ 6.00	0	₹ 300.00
20	[Item 5]	₹ 4.00	90.00%	42	₹ 319.20	₹ 5.00	₹ 3.25	₹ 5.35	3	₹ 218.40
21	Total				₹ 1,885.45				6	₹ 1,183.78
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