VIEWS: 761 PAGES: 2 CATEGORY: Financial Statements and Projections POSTED ON: 12/14/2011
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.
"COGS Margin Analysis Template"