Unit Cost Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEF
1
2
Duplicate this Document (Choose "File" at top left and choose "Make a Copy") to keep it forever...
3
4
My Product 1Total Batch CostTotal Cost per UnitInstructions
5
Number of units in this order (batch)
2000$12,242.06$6.12In general, you just need to fill out all the green cells.
6
7
Costs that apply to the whole batch
CostCost per Unit
1. Enter the number of units in this order (batch) in B3 (green cell)
8
Production Cost2000$9,500.00$4.75
9
Packaging & Extras2000$1,000.00$0.502. Enter all costs associated with the *whole* batch in C6-C9.
10
Shipping & Import Duty2000$1,128.03$0.56Delete the value in any green square that you don't need...
11
Other (wire fees, etc)2000$52.50$0.03for example "packing & Extras" may be zero for you.
12
13
Estimating Shipping to Amazon
# UnitsCostCost per Unit
3. Record the cost and # of units for at least 2 of your inbound shipments
14
Shipment 140$13.65$0.34(your shipments to Amazon) to get a solid average per-unit cost of
15
Shipment 2100$31.13$0.31your inbound re-shipping.
16
(Shipment 3)500$94.87$0.19
17
(Shipment 4)
(If you ship directly to amazon, just delete all values in green cells at left.)
18
(Shipment 5)
19
shipping avg >>
$0.28
4. The value in the purple cell, D3, is your Cost Per Unit for this product.
20
21
22
Consider duplicating this Sheet (click the little down arrow next to Product1 at the very bottom, choose "Duplicate") to have a tab for each of your products.
23
CPU Calculator by AmDash
Loading...
 
 
 
Product1