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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf selling on faq topics
- pdf fba for
- pdf amazon uk resource guide fba prep uk service for amazon sellers
- xlsx
- pdf fba step by step amazon web services
- pdf sell with amazon in the uk and eu a guide to import taxes
- pdf sales rank 03 01 16 full time fba
- pdf ista 6 amazon packaging solutions
- pdf getting started with fulfilment by amazon
- pdf tools we use and recommend online selling coach
Related searches
- west florida primary care west pensacola
- north west college west covina ca
- west coast college west covina
- world war 2 service records us army
- us world war 2 ships
- world war 2 us submarines
- us world war 2 aircraft
- world war 2 us deaths
- assistant s3 duty description oer
- article 2 section 2 of us constitution
- us navy world war 2 records
- world war 2 us medals