amazon-earnings.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2
3	Non-fba	Amazon Earnings Tool: Category Item(s).
4
5	Item	Book
6	Increaser & Price	$10.00	$4.98	14.98	24.98	34.98	44.98	54.98	64.98	74.98	84.98	94.98	104.98	114.98	124.98	134.98	144.98	154.98	164.98	174.98	184.98	194.98	204.98
7	Shipping	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99	3.99
8
9	fee	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80	1.80
10	Referral %	0.15	0.75	2.25	3.75	5.25	6.75	8.25	9.75	11.25	12.75	14.25	15.75	17.25	18.75	20.25	21.75	23.25	24.75	26.25	27.75	29.25	30.75
11	item: in cents	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60	0.60
12	fee total		3.15	4.65	6.15	7.65	9.15	10.65	12.15	13.65	15.15	16.65	18.15	19.65	21.15	22.65	24.15	25.65	27.15	28.65	30.15	31.65	33.15
13
14	Pre-earnings		5.82	14.32	22.82	31.32	39.82	48.32	56.82	65.32	73.82	82.32	90.82	99.32	107.82	116.32	124.82	133.32	141.82	150.32	158.82	167.32	175.82
15
16	Shipping & Supplies	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25	-4.25
17	If Higher shipping: ie., -6.5																					-6.50	-6.50
18	Revenue Earnings		1.57	10.07	18.57	27.07	35.57	44.07	52.57	61.07	69.57	78.07	86.57	95.07	103.57	112.07	120.57	129.07	137.57	146.07	154.57	160.82	169.32
19
20	Product	%
21	Cost	0.30	1.49	4.49	7.49	10.49	13.49	16.49	19.49	22.49	25.49	28.49	31.49	34.49	37.49	40.49	43.49	46.49	49.49	52.49	55.49	58.49	61.49
22
23	Adjusted Earnings		0.08	5.58	11.08	16.58	22.08	27.58	33.08	38.58	44.08	49.58	55.08	60.58	66.08	71.58	77.08	82.58	88.08	93.58	99.08	102.33	107.83
24
25	per lot of										84.98
26	100	cost	$149	$449	$749	$1,049	$1,349	$1,649	$1,949	$2,249	$2,549	$2,849	$3,149	$3,449	$3,749	$4,049	$4,349	$4,649	$4,949	$5,249	$5,549	$5,849	$6,149
27		earnings	$8	$558	$1,108	$1,658	$2,208	$2,758	$3,308	$3,858	$4,408	$4,958	$5,508	$6,058	$6,608	$7,158	$7,708	$8,258	$8,808	$9,358	$9,908	$10,233	$10,783
28
29			fill in colors					Monthly		lot amount	shipments per day				Multiple Products		price to profits for each.
30		1.00	Lowest priced item					to business we go:		100	3					w/Rent,etc
31			Labels					Lots	100	Cost	Earnings			product name	1	2	3	4	5
32			Costs: %, $ or lot					product price	$84.98	$2,549	$4,408			lot# (I31)	50	100
33									Basic costs			halt a cost		price	14.98	84.98
34		Yes, it’s pretty cool for 1 product & bulk lot sold over a month.							0.40	rent	$1,100	1100		cost	225	2549
35									0.04	utilities	$102			profit	252	900
36		Multiple products ie., 5 items at 5 different prices,							0.50	staff	$1,800	1800				w/basic costs
37		1 main product: must keep basic costs: rent util, staff,ads.							0.50	ad budget	$200	200
38		Include returns costs on each product separately.							0.12	returns	$306
39		The other products: halt their basic costs at 0, except their returns.								subtotal	$3,508
40		Multiple product columns, put in the specifics for each:												Multiple Products
41		Results for: lot#, price, cost, profit: fields O33-S39						Actual Business Profit:			$900			Actual Business Profit:		$1,152		more than 5
42		The happy business appears to be selling a higher priced product.
43
44															This section is for quick data reference of all products, (lot size, cost per lot, profit)
45															once each profit value has been calculated on the left
46															you shouldn’t need to update it until the costs or lot sizes change.
47
48
49
50
51	written by:	Therese Vaux de la Fontaine
52	Zayvra.com	Shareware donate			Tutorial
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