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 Information
                                                                                                                                    Notes
               Number of units                                         1000Total units ordered from supplier
               Units sold to date                                        335
               Retail Price                              $                        19.99  The selling price on Amazon. 
               Cost of Goods Sold                        $                          3.50  Cost of goods sold, this does not include shipping.
               Estimated FBA Fees (per unit)             $                          5.85  Cost per unit paid to Amazon. Amazon FBA Fee Calculator: 
                                                                             https://sellercentral.amazon.com/hz/fba/profitabilitycalculator/index?lang=en_US
               Promotional Products Given Away                            20
               Total Landed Cost per Product             $                          5.89  Landed Cost includes COGS + all shipping costs to get product to AMZ warehouse. 
                                                                              Upfront Costs (per product)
                   Samples                            $                           300  Enter your overall costs for all samples combined.
                   Graphic Design Work               $                              50  Enter all graphic design work (label creation, photo manipulation, etc)
                   Photography                        $                           250  Product photography costs.
               Additional Miscellanous Costs: 
                   Cost #1                           $                              10  Enter any costs incurred getting product listing active.
                   Cost #2                           $                              25 
               Total Upfront Costs                    $                           635 
                                                                                          Fixed Costs
                   Cost of Goods Sold                $                        3,500  Enter total costs paid to product manufacturer.
                   Shipping Costs
                     Importing from Overseas         $                        1,400  Enter shiping costs associated with shipping from manufacturer to port in your country.
                     Shipping to Amazon Warehouses  $                           900 Enter shipping costs to get product from port to AMZ warehouse.
               Additional Costs                                         Storage, 
                   Cost #1                           $                              30 
                   Cost #2                           $                              55 
               Total Fixed Costs                     $                        5,885 
                                                                                        Variable Costs
                   Advertising                       $                          1.60  Advertising cost per unit
                   Promotion                         $                        10.36  Includes product giveaways and coupons, per unit.
                   FBA Fees (per unit)               $                          5.85 
                                                                       Net Margin at Different Various Price Points 
               Retail Price                              $                        19.99   $                   23.99 
               FBA Fees                                  $                          4.25   $                     6.10 
               COGS                                      $                        3,500   $                   3,500 
               Shipping (Includes overseas + to AMZ wa  $                        2,300   $                   2,300 
               Total Landed Cost                         $                        5,800   $                   5,800 
               Landed Cost, Per Unit                     $                          5.80   $                     5.80 
               PPC Cost                                  $                          1.60   $                     1.60 
               FBA Fees                                  $                          4.25   $                     6.10 
               Cost Per Unit                             $                        11.65   $                   13.50 
               Net Margin Per Unit                       $                          8.34   $                   10.49 
                                                                                     Gross Margin Calculation
                                                       REVENUE
                                                            Product Sold      $                12,307 
                                                       Total Revenue          $                12,307 
                                                       EXPENSES
                                                            Samples           $                      300 
                                                            Graphic Design    $                        50 
                                                        Product Photogra $                      250 
                                                        Mischellaneous   $                        35 
                                                        All Shipping Costs $                   2,300 
                                                        COGS             $                   1,173 
                                                        Product Giveaway $                      207 
                                                        PPC Cost         $                      534 
                                                        Amazon FBA Fees $                   1,960 
                                                    Total Expenses       $                   6,809 
                                                    GROSS MARGIN         $                   5,498