e-commerce cost estimates
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTU
1
E-COMMERCE ESTIMATING WORKSHEET
2
DAVE SEAH - UPDATED JULY 8 2013 - ACCOMPANYING POST AT http://davidseah.com/P7916
3
4
HOW TO EDIT: Go to FILE menu and choose MAKE A COPY
5
You do not need to request access to edit the master document. If you can see this, you can make a copy.
6
7
This spreadsheet estimates the comparative costs between Shopify+Stripe+Shipwire and Amazon Pro-Merchant w/ FBA
8
I made it so I could get a rough idea whether it made sense to switch to Shopify etc, trying different values to see the break-even points.
9
I make several simplifications; unmodified, this spreadsheet will give inaccurate results for large order and item counts.
10
11
SAMPLE PRODUCT DATA
12
All the profit calculations below use these numbers. "cog" is "cost of goods": the cost of acquiring the item + shipping to the warehouse
13
14
EDIT ONLY THESE NUMBERS!TO MAKE EDITS, SEE INSTRUCTIONS ABOVE
15
unit priceunit cogunit weight
16
$14.00$5.001
17
18
# items/orderorders/month
19
1100
20
21
SHOPIFY + STRIPE + SHIPWIRE
22
Based on a reading of the shopify, stripe, and shipwire websites. I have not confirmed these numbers through use.
23
24
STOREFRONT - SHOPIFY
25
feepercentagefixed costdescription
26
monthly$29.00for up to 100 products, includes theme editing
27
transaction2%charged on value of transaction
28
29
PAYMENT PROCESSOR - STRIPE
30
feepercentagefixed costdescription
31
transaction fee2.9%$0.30changed on value of transaction
32
33
SHIPWIRE - FULFILLMENT
34
feepercentagefixed costdescription
35
storage$24.95min monthly storage fee (using minimum 64 cubic feet, or 1/2 palette)
36
per-order$2.85highest rate, incl. packaging/fill/customs (?) Rate starts to drop at 55 orders/mo.
37
additional pick$0.95guessed from the shipwire interactive configurator
38
39
profit per item
40
total order$14.00pulled from EXAMPLE PRODUCT
41
total weight1lbspulled from EXAMPLE PRODUCT
42
.. shopify cut$0.28
43
.. stripe cut$0.71
44
.. shipwire cut$2.85includes additional picks if multiple items in EXAMPLE PRODUCT
45
sss subtotal$3.84combination of above fees
46
net revenue$10.16order minus sss subtotal
47
net profit$5.16subtract cost of goods (which should include ship-in cost of item)
48
profit margin36.89%
49
50
profit per month
51
total orders100pulled from EXAMPLE PRODUCT
52
profit per order$5.16pulled from EXAMPLE PRODUCT
53
total profit$516.40using per-item profit times total orders
54
overhead$53.95monthly cost of shopify and shipwire
55
net profit$462.45monthly profit
56
57
58
AMAZON COST COMPARISON
59
The fees listed here apply to OFFICE PRODUCTS; see Amazon Seller Central for other categories.
60
61
AMAZON PRO MERCHANT (PROFESSIONAL SELLING ACCOUNT)
62
feepercentagefixed costdescription
63
monthly$39.99listing on amazon, webstore
64
referral15%amazon cut for market listing
65
var closing0.45 + 0.10/lbapplies only to media items
66
per-item$0.99waived for pro merchant
67
68
FULFILLMENT BY AMAZON (FBA)
69
feepercentagefixed costdescription
70
monthly storage$10.00based on computed volume; my stock is very compact
71
order handling$1.00one per order
72
pick & pack$1.00each unit incurs a pick fee
73
weight 1lb$0.45weight includes packaging, rounded up to whole pound
74
weight 2lb$0.99weight includes packaging, rounded up to whole pound
75
weight 2lb+0.99 + 0.38/lbweight includes packaging, rounded up to whole pound
76
77
profit per item
78
total order$14.00pulled from EXAMPLE PRODUCT
79
total weight1lbspulled from EXAMPLE PRODUCT
80
.. referral$2.10fee for selling through amazon
81
.. order handl$1.00per-order handling fee
82
.. pick&pack$1.00per-item pick&pack fee
83
.. weight$0.45using estimate of around 45 cents per pound
84
amz subtotal$4.55order minus sss subtotal
85
net revenue$9.45subtract cost of goods (which should include ship-in cost of item)
86
net profit$4.45
87
profit margin31.79%
88
89
profit per month
90
total orders100pulled from EXAMPLE PRODUCT
91
profit per order$4.45pulled from EXAMPLE PRODUCT
92
total profit$445.00using per-item profit times total orders
93
overhead$49.99monthly cost of amazon promerchant +monthly storage fee
94
net profit$395.01monthly profit
95
96
97
98
99
100
Loading...