COGS Margin Analysis Template

Document Sample
COGS Margin Analysis Template Powered By Docstoc
					COGS Margin Analysis

                                                           Product A    Product B
                                 SRP                            $9.99       $19.99
Wholesale/Mark Up            50% Delivered                      $5.00       $10.00
                              1% Returns                        $0.05        $0.10
Net Cost                         Gross, net of Returns          $4.95        $9.90

                             10% Markdowns                      $0.50       $1.00

% to Gross, Net of Returns         Net Sales                    $4.45       $8.90

                              5%   Duty                         $0.25       $0.50
                              8%   US Warehouse - 8%            $0.40       $0.80
                             10%   Freight from Supplier        $0.15       $0.30
                              3%   Other Logistics              $0.15       $0.30
                              3%   Sales Commission             $0.13       $0.27
                                   Total Cost                   $1.08       $2.17

                                 Net USD                        $3.36       $6.73
Target Margin                55% COGS                           $1.51       $3.03
                                 Gross Profit                   $1.85       $3.70
                                 Margin                           55%         55%
Product C
    $4.99
    $2.50
    $0.02
    $2.47

    $0.25

    $2.22

    $0.12
    $0.20
    $0.08
    $0.07
    $0.07
    $0.54

    $1.68
    $0.76
    $0.92
      55%
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:761
posted:12/14/2011
language:Latin
pages:2
Description: This template spreadsheet allows a company to calculate target Cost of Goods Sold (COGS) based on what a product's suggested retail price (SRP) and targets margins are. Inputs are required for all value fields in red. Based on a product's SRP and target margin, the optimal COGS will appear in the boxed cell. This calculation let a company know how much it needs to pay for an item in order to meet its target margins and SRP.