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 37 min ▶ Video lessons coming soon
Last updated
Offered by HSM University · Sales
This is the Canadian version of this course. See the American 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 metre), 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 37 min total · final exam
- 1 Why retail math matters 20 min · quiz
- 2 Markup 25 min · quiz
- 3 Markdowns 22 min · quiz
- 4 Gross margin 25 min · quiz
- 5 Sell-through 23 min · quiz
- 6 Stock turn and weeks of supply 25 min · quiz
- 7 GMROI 26 min · quiz
- 8 Sales per square foot 22 min · quiz
- 9 Open-to-buy 25 min · quiz
- 10 Assortment planning 21 min · quiz
- 11 Pricing strategy in stores 20 min · quiz
- 12 Case study: planning a season 23 min · quiz
- 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.