Retail Math
A class planned to do $500,000 in sales but ended up doing $545,000. What was the % to plan?
9%
What are the 3 reasons you would get an Alert 1?
No plans, Low volume, and sales with no flow flag
What is the HOST used for?
Used to create Mappings and Orders using the MPH
If we hold our Sales AUR and Increase Sales $ what happens to our Units?
Units increase
What are the parameters for highlighting turns on Chain Weekly Sales?
A class had $12,000 in markdown dollars on $80,000 in sales. What is the MKD%
15%
What is the difference between WP, RP, OP, and AP
WP: working plan
RP: revised plan
OP: original plan
AP: approved plan
What is shrink?
Stolen goods
What happens to turns and receipts if BOP increases?
Turns slow and receipts decrease
How many months of history does a class need in order for it to be trended?
3 months
A class did $410,000 in sales this year and $400,000 last year. The non‑comp factor is 2%. What is the comp%
0.5%
What does it mean to “save to AIM”
AIM is the Arthur Information Manager – saving to AIM takes the WP in the open plans and moves it to the WP in the share plans
What is the Master Product Hierarchy starting at DV?
DV, SD, DG, DP, CG, CL, CA
This term describes the percentage of units sold versus units received
What is sell-thru
What are the three AVG unit metrics you can see on a 3D?
AVG BOP, AVG SLS, AVG RCPs
Calculate TY sales $ if our desired comp is 5%, LY sales are $250,000, and NCF is 2%.
$267,500
What are the three ways to extract data from Arthur?
DML, copy/paste, planning import wizard
What is the purpose of SA?
Allows the merchants to fill to a higher receipt plan in month without adding sales
What is the difference between sales growth and comp?
Sales growth measures total sales year over year and comp measures same store sales growth year over year
List the steps involved in balancing assuming we need to do an AUR check and run ALGO.
AUR check, RP/WP check, balance plans, check WPvRP, ALGO, missing plan check, flat plan check, adjust retail, alert 1, WP check, save to AIM
A class starts the month with $150,000 BOP inventory, has $60,000 in sales, $10,000 in markdowns, and receives $50,000 in receipts. What is the ending inventory?
$130,000
Why do we run ALGO?
To correctly set our inventory relationships at the store level based on Sales
What is the difference between an upfront and a closeout?
How do you find the Region Average % to Chain working with only sales $ and store counts?
Stores are classified as Comp Stores once they have been open for how many months? And why?
15 Months. We factor the first 3 months of a new stores sales as a Grand Opening spike.