[PREVIEW] PRO_Break-Even Calculator


1			Break-even calculator for Amazon sellers
2										Legend:	Editable
3										Legend:	Calculation

4
5
6		Product Name:	Tennis balls		Supplier Name:	China T Balls Factory		Break-Even Units (X)	Break-Even Sales (S)		Break-Even Mnths
7		Date:	3/30/2023		Selling Price:	$15.00		806	$12,085.00		8
8								806	$12,085.00		8
9
10	COGS ($ per Unit)				VARIABLE & FIXED COSTS (% per Unit)			BREAK-EVEN CHART
11
12	Enter all variable costs related to the product				Amazon Referral Fee	15%	per unit
13		Cost of Goods Sold	$2.95	per unit	Return rate	2.3%	per unit
14		(add any extra costs)	$0.05	per unit	Operating costs	15%	per unit
15		(add any extra costs)	$0.01	per unit	Sum of variable costs	32.3%
16		Inspection cost	$0.10	per unit		$4.85
17		Duties&Tariffs	$0.10	per unit
18		Freight cost	$0.25	per unit	Total Variable Costs	$4,845.00
19		Extra labor cost	$0.10	per unit
20		FBA Fees	$3.48		Quantity to order	1,000	units
21		Extra shipping to Amazon	$0.20	per unit	Est. Units sold per month	100	units
22		(add your own)		per unit
23		(add your own)		per unit	Total Cost and Margins
24		(add your own)		per unit	Total COGS Per Unit	$7.24
25					Gross Profit Per Unit	$7.76
26		Sum of COGS	$7.24		Gross Profit Margin	51.7%
27					Operating Profit Per Unit	$2.92
28		Total COGS	$7,240.00		Operating Margin	19.4%
29
30	Definitions							SUMMARY
31		Break-Even Units	Number of units you must sell to make back your total investment from the profits.					Selling price:	$15.00	✔️ Selling price is good
32		Break-Even Sales	Total amount in sales you must sell to make back your total investment from the profits.					Product cost is:	$7.24
33		Break-Even Mnths	Total number of months it will take to make back the investment from the profits.					Extra variable cost is:	$4.85
34		Cost of Goods Sold	Cost to make the product					Total product cost is:	$12.09
35		Inspection cost	Cost associated with any factory or product inspections					You are ordering QTY of:	1,000
36		Duties&Tariffs	Any additional import duties and tariffs that must be accounted for in the cost					Est sales per month is:	100
37		Freight cost	Cost of shipment					Gross Profit per unit is:	$7.76
38		Extra labor cost	If extra labor is required from your warehouse or from a packing service					Gross Profit margin is:	51.7%	✔️ Nice margins
39		FBA Fees	Per unit FBA fees for pick and pack					Total investment is:	$12,085
40		Extra shipping to Amazon	Extra costs to ship the item to Amazon					Months to break-even:	8	✔️ Break-even within the year
41		Amazon Referral Fee	The % fee for your Amazon product category
42		Return rate	The return rate for your account. Find it in your business sales report in seller central.
43		Operating costs	include if you want to calculate break even after accounting for returns. Delete if you want to calculate break even based on gross profit only. includes business and overhead expenses like:- Advertising, payroll, utilities, rent, legal, fees and interest, marketing, taxes, travel, rent/lease, maintenance, licenses, supplies, software, hardware
44		Total Cost Per Unit (C)	The total sum of the landed cost and extra variable costs
45		Profit Margin Per Unit (PM)	Profit in dollars
46		Profit Margin Ratio (PMR)	Profit as a percentage. If operating costs are excluded, it's closer to a gross profit margin. If operating costs are included, it is Operating Profit.
47
48
49
50
51
52
53
54
55