Retail Math & Merchandising
Work out markups, markdowns, sell-through, stock turn and GMROI, an open-to-buy plan, store KPIs and shrink for a fashion and home retailer, with every cell checked as you go.
- One-time payment
- 14-day money-back guarantee
- Secure checkout with Stripe
What you'll build
What you will be able to do
Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.
- Price Wrenfield's fall range, express each markup on retail and on cost, and convert between the two.
- Work out the initial markup the knitwear buyer must place on goods to reach the season's profit plan, then check what was actually maintained.
- Log the January clearance, state each markdown on the original and on the sale price, and report the month's markdown %.
- Rank six fall styles by sell-through and weeks of supply and let a formula flag which ones need a markdown.
- Average the knitwear stock over the season and measure how often it turned and how much gross margin each dollar of stock earned.
- Build the spring open-to-buy for knitwear month by month and tell the buyer how much she may still order, at retail and at cost.
- Compare Wrenfield's four stores on space productivity, conversion, transaction value and units per transaction.
- Reconcile the spring stock count against the books and find which department loses the most stock.
About this course
Buying and merchandising decisions come down to a handful of ratios, and this course makes them second nature. You convert between markup on cost and markup on retail, plan initial markup and track what remains after markdowns. Sell-through and weeks of supply tell you which lines are moving, while inventory turnover and GMROI show whether stock earns its keep. You build an open-to-buy plan at both retail and cost, measure sales per square foot alongside basket metrics, and reconcile a stock count to calculate shrinkage. Designed for assistant buyers, merchandise planners, store managers and retail management students who want confidence with the core calculations.
Curriculum
Course content
8 lessons · 8 labs · 1.8 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
Certificate
Finish with a certificate you can verify
Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.
- Names the course, your score and the date of issue
- A verification link for your CV or LinkedIn profile
- 12 questions, 75% to pass, unlimited retries.
A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.
Before you buy
Questions about this course
Is this a subscription?
No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.
What exactly do I get?
All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.
Can I get a refund?
Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.
When can I start?
Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.
Do I need Excel or other software?
No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.
Is the certificate an official qualification?
No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.
Full details are in our Terms · hello@tutorvo.com
