0 0
Browse > Bookkeeping, Accounting and Tax > Financial Statements and Projections

COGS Margin Analysis Template

ABOUT THIS DOCUMENT

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.

Reads: 537 times
Used: 7 times
Pages: 2
Size: 23 kb
Format: Excel Spreadsheet

Text Version

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%

THIS DOCUMENT IS BEST FOR

Category:

Bookkeeping, Accounting and Tax


Sub-Category:

Financial Statements and Projections


Industry:

Any Business Type


Region:

United States - Any State


Get Unlimited Access to Our Complete Business Library

Plus

  • All Licenses and Permits For Your Business
  • Customized Legal and Business Forms and Agreements
  • Document Packages for Specific Situations
Learn More »

Document Recommendations

Sign-up for Docstoc Premium
X
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
X
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
X
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.

Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?