Retail Math and Merchandise Planning

The numbers retailers buy and sell by: markup and markdown, gross margin, sell-through, stock turn, GMROI, sales per square foot, open-to-buy and assortment planning.

SLS-253 Year 2 3 credits 12 lessons · 4 h 36 min ▶ Video lessons coming soon

Last updated

Offered by HSM University · Sales

This is the American version of this course. See the Canadian version.

What you'll learn

  • Read a store's profit and loss statement, explain how net sales, cost of goods sold, gross margin and operating profit relate, and separate sales tax from the store's sales.
  • Calculate markup on cost and on retail, convert between them, price an item from a target markup, and find the initial markup a department needs.
  • Calculate markdown dollars, off-retail and markdown percentages, and maintained markup, and explain when markdowns are worth taking and the rules on regular-price claims.
  • Build gross margin from initial markup, reductions, cash discounts and workroom costs, and explain the mix effect and how promotions affect margin dollars.
  • Calculate cumulative and weekly sell-through in units and dollars, compare it with a planned curve, and decide which items to reorder, move or mark down.
  • Calculate stock turn at cost and at retail, average inventory, days of inventory and weeks of supply, and use them to judge how much stock to hold.
  • Calculate GMROI, break it into margin and speed, compare departments and items, and identify ways to improve it.
  • Calculate sales and gross margin per square foot (and per square meter), a space productivity index, and estimate the effect of moving space between departments.
  • Use the merchandise planning equation to calculate planned purchases and open-to-buy at retail and at cost, and respond when a department is overbought.
  • Plan an assortment's breadth and depth, count SKUs, allocate units using sell-through history, and set good, better and best price lines.
  • Compare cost-based, competition-based and value-based pricing, estimate price elasticity, evaluate bundles and promotions on margin dollars, and follow the rules on honest price display.
  • Build and check a season plan for a department: sales, reductions, margin, stock, purchases, open-to-buy, assortment, prices and checkpoints.

Course content

12 lessons · 4 h 36 min total · final exam

  1. 1 Why retail math matters 20 min · quiz
  2. 2 Markup 25 min · quiz
  3. 3 Markdowns 22 min · quiz
  4. 4 Gross margin 25 min · quiz
  5. 5 Sell-through 23 min · quiz
  6. 6 Stock turn and weeks of supply 25 min · quiz
  7. 7 GMROI 26 min · quiz
  8. 8 Sales per square foot 21 min · quiz
  9. 9 Open-to-buy 25 min · quiz
  10. 10 Assortment planning 21 min · quiz
  11. 11 Pricing strategy in stores 20 min · quiz
  12. 12 Case study: planning a season 23 min · quiz
  13. E Final exam 20 questions

Requirements

Recommended background. You can start any course at any time.

Description

The numbers retailers buy and sell by: markup and markdown, gross margin, sell-through, stock turn, GMROI, sales per square foot, open-to-buy and assortment planning.

Part of the Business stream, typically taken in year 2.