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.
Get Unlimited Access to Our Complete Business Library