Get the Flash Player to see this player.
Archipelago
Mary LakeThompson
Roger & Gallet
Mary LakeThompson
Archipelago

Equations to Calculate Retail Sales and Stock Print E-mail

Retail math is often used in various ways by store owners, managers, retail buyers and other retailing employees. It is used to evaluate inventory purchasing plans, analyze sales figures, add on markup and apply markdown pricing to plan stocks.

Although there are computer programs and other tools available, performing these retail math calculations often requires familiarity with formulas. Use the following equations and retail math formulas to track merchandise, measure sales performance and help create pricing strategies.

 

Acid-Test Ratio

Acid-Test Ratio = Current Assets - Inventory ÷ Current Liabilities

(Online Acid Test Calculator) 

 

Average Inventory

Average Inventory (Month) = (Beginning of Month Inventory + End of Month Inventory) ÷ 2

 

Basic Retailing Formula

Cost of Goods + Markup = Retail Price

Retail Price - Cost of Goods = Markup

Retail Price - Markup = Cost of Goods

 

Break-Even Analysis

Break-Even ($) = Fixed Costs ÷ Gross Margin Percentage

(Online Break Even Analysis Calculator) 

 

Contribution Margin

Contribution Margin = Total Sales - Variable Costs

 

Cost of Goods Sold

COGS = Beginning Inventory + Purchases - Ending Inventory

 

Gross Margin

Gross Margin = Total Sales - Cost of Goods

(Online Gross Margin Calculator) 

 

Gross Margin Return on Investment

GMROI = Gross Margin $ ÷ Average Inventory Cost

 

Initial Markup

Initial Markup % = (Expenses + Reductions + Profit) ÷ (Net Sales + Reductions)

 

Inventory Turnover (Stock Turn)

Turnover = Net Sales ÷ Average Retail Stock

 

Maintained Markup

MM $ = (Original Retail - Reductions) - Cost of Goods Sold

MM % = Maintained Markup $ ÷ Net Sales Amount

 

Margin %

Margin % = (Retail Price - Cost) ÷ Retail Price

 

Markup

Markup $ = Retail Price - Cost

Markup % = Markup Amount ÷ Retail Price

 

Net Sales

Net Sales = Gross Sales - Returns and Allowances

 

Open to Buy

OTB (retail) = Planned Sales + Planned Markdowns + Planned End of Month Inventory -

Planned Beginning of Month Inventory

 

Percentage Increase/Decrease

% Increase/Decrease = Difference Between Two Figures ÷ Previous Figure

 

Quick Ratio

Quick Ratio = Current Assets - Inventory ÷ Current Liabilities

 

Reductions

Reductions = Markdowns + Employee Discounts + Customer Discounts + Stock

Shortages

 

Sales per Square Foot

Sales per Square Foot = Total Net Sales ÷ Square Feet of Selling Space

 

Stock to Sales Ratio

Stock-to-Sales = Beginning of Month Stock ÷ Sales for the Month

 
< Prev   Next >
ORCHARD STREET ASSOCIATES SERVICE, SOLUTIONS, INFORMATION & REORDERS
Phone: 800-360-2678 Fax:866-762-8400 SOLUTIONS@OSAGIFT.COM
Copyright © 2007 -2009 Orchard Street Associates - Joomla Template By Joomladesigns.co.uk   additional graphic design sicadesign.net