XLSX www.junglescout.com

This spreadsheet is intended to help you organize and understand the expenses and profits associated with your Amazon FBA product. There is example data included to help illustrate how the spreadsheet works. This is a template that you can alter to fit your specific needs. All text in GREEN is a formula, and will calculate automatically. All text in RED is the text that you should enter specific to your product. If it does not apply to you, simply enter 0.Hope that this helps you in your FBA journey!Basic InformationAdvertisingPromotion and GiveawaysTotal Advertising Spend335Cost of Goods Sold (per unit)=D27NotesTotal Units Sold 210Amazon FBA Fees (per unit)=D64Number of units1000Total units ordered from supplierAd Spend Per Unit=J22/J23Giveaway Fees (per unit)4Units sold to date335Product Giveaway Price2.99Retail Price 19.99The selling price on Amazon. Total Cost per Promotional Giveaway=-(M25-M22-M23-M24)Cost of Goods Sold=D49/D24Cost of goods sold, this does not include shipping.Estimated FBA Fees (per unit)5.85Cost per unit paid to Amazon. Amazon FBA Fee Calculator: Products Given Away20Total Landed Cost per Product=(D56)/D24Landed Cost includes COGS + all shipping costs to get product to AMZ warehouse. Upfront Costs (per product)Samples300Enter your overall costs for all samples combined.Graphic Design Work50Enter all graphic design work (label creation, photo manipulation, etc)Photography250Product photography costs.Additional Miscellanous Costs: Cost #110Enter any costs incurred getting product listing active.Cost #225Total Upfront Costs=SUM(D37:D42)Fixed CostsCost of Goods Sold3500Enter total costs paid to product manufacturer.Shipping CostsImporting from Overseas1400Enter shiping costs associated with shipping from manufacturer to port in your country.Shipping to Amazon Warehouses900Enter shipping costs to get product from port to AMZ warehouse.Additional CostsStorage, Cost #130Cost #255Total Fixed Costs=SUM(D49:D55)Variable CostsAdvertising=J24Advertising cost per unitPromotion=M26Includes product giveaways and coupons, per unit.FBA Fees (per unit)=D28Net Margin at Different Various Price PointsRetail Price19.9923.9927.99FBA Fees4.256.17.25COGS=$D$49=$D$49=$D$49Shipping (Includes overseas + to AMZ warehouse)=SUM($D$51:$D$52)=SUM($D$51:$D$52)=SUM($D$51:$D$52)Total Landed Cost=SUM(D74:D76)=SUM(E74:E76)=SUM(F74:F76)Landed Cost, Per Unit=D77/$D$24=E77/$D$24=F77/$D$24PPC Cost=$J$24=$J$24=$J$24FBA Fees=D73=E73=F73Cost Per Unit=SUM(D83,D82,D79)=SUM(E83,E82,E79)=SUM(F83,F82,F79)Net Margin Per Unit=D72-D85=E72-E85=F72-F85Gross Margin CalculationREVENUEProduct Sold12307Enter sales per Amazon's Seller Central Dashboard.Total Revenue=SUM(E95)EXPENSESSamples=D37Graphic Design=D38 ................
................

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

Google Online Preview   Download