XLSX s3-us-west-2.amazonaws.com

Profit Margin BreakdownThis spreadsheet is created for you by Seller Nexus Team ().The spreadsheet provides an easy way of looking at your Amazon FBA product profitability.Feel free to modify it as you see fit. Hope it will help you in organising your Amazon sales analysis!Cells colored in YELLOW are intended to be inputs (zero if not applicaple to you)Inputs first!General# of units1000Total units ordered from supplier# of units sold to date335Sale Price$19.99The selling price on AmazonEstimated FBA fees (per unit)$5.85Cost per unit paid to Amazon. Amazon FBA Fee Calculator:

Advertising Spend$335Total Units Sold 210Promotions & GiveawaysPromotional Products Given Away20Giveaway Fees (per unit)$4Product Giveaway Price$2.99Production Costs (per Unit)Samples$300Enter your overall costs for all samples combined.Graphic Design Work$50Enter all graphic design work (label creation, photo manipulation, etc.)Photography$250Product photography costsAdditional Cost #1$10Enter any costs incurred getting product listing activeAdditional Cost #2$25Enter any costs incurred getting product listing activeTotal Production Costs (per Unit)$=SUM(E27:E31)Fixed CostsCost of Goods Sold$3500Enter total costs paid to product manufacturerShipping Costs: Importing from Overseas$1400Enter shiping costs associated with shipping from manufacturer to port in your countryShipping Costs: to Amazon Warehouses$900Enter shipping costs to get product from port to AMZ warehouseAdditional Cost #1$30Enter any additional costs incurred during the product sales (e.g. storage)Additional Cost #2$55Enter any additional costs incurred during the product sales (e.g. storage)Total Fixed Costs$=SUM(E35:E39)OutputProfit Margin per UnitCurrentOption 1Option 2Option 3Option 4Option 5Option 6Option 7Option 8Option 9=C14$=$E$14=E47+1=F47+1=G47+1=H47+1=I47+1=J47+1=K47+1=L47+1=M47+1FBA fees$4.254.715.185.646.16.396.686.967.257.54COGS per unit$=E35/$E$12*-1=E50=F50=G50=H50=I50=J50=K50=L50=M50Shipping per unit (Overseas + to AMZ warehouse)$=SUM(E36:E37)/$E$12*-1=E51=F51=G51=H51=I51=J51=K51=L51=M51PPC Cost$=E18/E19*-1=E52=F52=G52=H52=I52=J52=K52=L52=M52FBA Fees$=E48*-1=E53=F53=G53=H53=I53=J53=K53=L53=M53Total costs per unit$=SUM(E50:E53)=SUM(F50:F53)=SUM(G50:G53)=SUM(H50:H53)=SUM(I50:I53)=SUM(J50:J53)=SUM(K50:K53)=SUM(L50:L53)=SUM(M50:M53)=SUM(N50:N53)Profit Margin per Unit$=E47+E55=F47+F55=G47+G55=H47+H55=I47+I55=J47+J55=K47+K55=L47+L55=M47+M55=N47+N55Profit MarginREVENUEProducts Sold$12307Enter sales as per Amazon's Seller Cenral DashboardTotal Revenue$=E62EXPENSESSamples$=E27*-1Graphic Design$=E28*-1Product Photography$=E29*-1Mischellaneous$=SUM(E30:E31)*-1All Shipping Costs$=SUM(E36:E37)*-1COGS$=E35*(E13/E12)*-1Accounts only for the products sold thus far, not all COGS purchased upfrontProduct Giveaway$=E22*(E24-E23-E15-E35/E12)PPC Cost $=E13*(E18/E19)*-1Amazon FBA Fees$=E15*E13*-1Total Expenses=SUM(E66:E74)PROFIT MARGIN$=E63+E75 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download