SNEWS® Retail Merchandising Training 101: Online calculator makes it easier

Looking to quickly calculate gross margin %, mark-up %, GMROI, retail selling price, turns and more? As part of our popular SNEWS® Retail Merchandising Training 101 clinic series, we've created a package of on-line calculators to make the job just a bit easier. Just plug in the numbers where our calculators ask for them and presto...your answer awaits. Talk about being a smart buyer!
Author:
Updated:
Original:

The SNEWS® Retail Merchandising Calculator


Gross Margin %

(Gross Profit / Selling Price)

Gross Profit $

Selling Price $ Gross Margin %

Mark-up %

(Gross Profit / Product Cost)

Gross Profit $

Product Cost $ Mark-up %

If you know the product's cost and suggested retail, but need to see what the resulting "gross margin" will be, then:

((Selling Price - Product Cost) / Selling Price)

Selling Price $

Product Cost $ Gross Margin %

If you know your product cost and want to solve for the "retail selling price", then use this formula:

(Product Cost / (100% - (Gross Margin * 0.01)))

Product Cost $

Gross Margin % Retail Selling Price $

If you know your selling price threshold and want to solve for "target product cost", use this formula:

(Selling Price * (100% - Gross Margin))

Selling Price $

Gross Margin % Target Product Cost $

Gross Margin Return on Investment (GMROI)

(Turns * Gross Margin)

Turns #

Maintained Gross Margin % GMROI %

Stock-to-Sales Ratio

(Average or Current Inventory at Cost / Cost of Goods Sold)

Average (or current) Inventory at Cost $

Cost of Goods Sold $ Stock-to-Sales Ratio

Turn

(Cost of Goods Sold / Average Inventory at Cost) *Usually done on an annual basis or in retail dollars or units

Cost of Goods Sold $

Average Inventory at Cost $ Turn #

Related

SNEWS® Retail Merchandising Training 101: Understanding stock turnover

Last week, we debuted our new 10-part Retail Merchandising Training 101 series by covering the most basic of concepts -- knowing how to determine your gross profit or margin on the sale of an item (click here to read). Of course, we know that there might be some who imagine that ...read more

SNEWS® Retail Merchandising Training 101: Merchandise planning

Your merchandise plan will bring together everything we've taught so far -- initial product margin, maintained gross margin, turn goals and the various sales velocity metrics of sell-off percentage, sell-through, etc. -- into a master plan for every category of goods you sell for ...read more

SNEWS® Retail Merchandising Training 101: GMROI, sell-through, stock-to-sales ratios and other arcanery

So we've covered Gross Margin (How much will I make each time I sell my Gizmos?) and Stock Turnover (How often do I make this margin when I sell my Gizmos?). Now we'll take a look at the dynamic balance between those two metrics. There are a number of these factorings of margin ...read more

SNEWS® Retail Merchandising Training 101: History and Analysis

By now you have most of the essential building blocks of planning and managing your sales and inventory under your belts. While we know you'd rather be heading out for a paddle, trail run or to the climbing gym, you still have work to do…so sit back down. What follows is the part ...read more

SNEWS® Retail Buyer Training 101 article finder

This is an article finder to our 10-part Retail Buyer Training series produced by SNEWS®. ...read more

SNEWS® Retail Merchandising Training 101: Preseason strategies

June has arrived and by this point, you've: Summarized your spring season just in time as it drew to a close. You know how your categories performed, where your opportunities are, which vendors and categories are on the move and which are fading away, and where you made money. ...read more

SNEWS® Retail Merchandising Training 101: Traffic and Conversion

Conversion rate -- what an unfriendly term! Referring to customers as traffic? Not in my store! Many of us in specialty retail like to think of our clientele as friends, or at least patrons whose repeat business we rely upon. We train our staff to take as much time as each ...read more

SNEWS® Retail Merchandising Training 101: Sales efficiency and real estate

We've now covered all the basic merchandising calculations, planning and open-to-buy. Last time, we covered the ways our merchandise selections, location and promotions relate to the flow of customers in stores and how and when shoppers convert to buyers. In so doing, we see ...read more

SNEWS® Retail Merchandising Training 101: Open-To-Buy

In our previous retail merchandising training article, we gave you an overview and some examples of how to set up a merchandise plan (click here to read). This is typically done well in advance of the selling season, especially with those categories of merchandise that are ...read more