1st 4W ROS
Average of the first 4 weeks of Sales (after returns)
Adjusted Units
Any variance between Stock on Hand, PO Received, Sales Units and Returns within the week. Usually shrinkage/system processing delays
ASP (Average Selling Price)
Sales revenue before returns ex-tax, divided by sales units before returns
ATS (Available To Sell)
Stock U + Sales U AR, which is how you would calculate OSOH manually, however, ATS and OSOH have few differences.
ATS differs from OSOH in the following ways:
ATS includes inventory that was DELIVERED during the period (OSOH does not)
ATS excludes inventory that was returned or transferred out during the period (whereas this WILL show up in OSOH)
If there are no transfers or Intake ATS will equal OSOH.
Avg 4wk Cover
Stock U / Average of most recent 4 weeks Sales (after returns)
COGS
Cost of Good Sold $
CR% (G) (Conversion Rate % Gross)
Sales BR / Page views
CR% (N) (Conversion Rate % Net)
Sales AR / Page views
CTR% (Click Through Rate %)
Product List Clicks / Impressions
Discount AR
The difference between (units * sell price ex tax) and actual revenue - (promo discounts)
FM% (First Margin)
((RRP/1.1) - Cost Price)/(RRP/1.1)
FP ST%
Sales U AR FP/ ATS
Future Orders
The Sum of all units that are on a purchase order, to be delivered at a future date
GP% (Gross Profit)
GP$ divided by Sales$
Intake Units
Sales AR + Closing SOH - Opening SOH (for the applied time slice only)
Launch Date
is the date the item was launched in any given store or online.
For product that was launched when integrated with Style Arcade it is:
The date the product was published online (for online channels) OR
The first date the product appeared on a retail store's stock on hand
Therefore it will be normal to have the launch date change depending on
For product that was launched prior to integrating with Style Arcade, the launch date will be the first date the item was sold in a retail store (as we were not live, and therefore not capturing stock at a certain point in the past yet).
Launch Month
is the month the item was launched in any given store or online.
For product that was launched when on Style Arcade it is either the date of:
When the product was published online
The first date the product appeared on a retail store's stock on hand
For product that was launched prior to integrating with Style Arcade, the launch date will be the first date the item was sold in a retail store (as we were not live, and therefore not capturing stock at a certain point in the past yet).
Markdown AR
The different between (units * RRP ex tax) and (units * sell price ex tax) - (red pen discounts.
MD%
Discount currently being applied to the product based on the difference between the RRP and Current Selling Price
= 1 - (Selling Price / RRP)
Last 4W ROS
Last 4 Week Rate of Sale. Avg Sales Units over last 4 weeks
Last 6 Week Rating
Based on the Average Sell Through % of the most recent 6 weeks (last 5 weeks + current week)
Price Status
Price Status as at today
Full Price = Selling at full price or full RRP
Markdown = Item has a permanent discount applied
Promo = Item has a temporary discount applied (with a specific end date)
Products Count
Count of Products that made sales or held stock within time frame selected
Promo %
Displays the discount when an item is on Promotion (temporary discount)
Promo End Date
Specific end date that a Promotion is scheduled to end
Promo Price
When an item is on Promotion (temporary discount), this is the Promotional Price (including GST) = RRP – discount
Rating
This indicates the Average Weekly Sell Through of the product in the 1st 6 weeks since launch
Returns
Returned Units
Returns are attributed to the week they are returned/processed
RR%
Returned Units % of Sales Before Returns
RRP
Recommended Retail Price (including GST)
Sales $
Retail Sales $'s after returns and discounts
Sales AR
Unit Sales (After Returns)
Sales BR
Unit Sales (Before Returns)
Sell Price
When an item is on Markdown (permanent discount), this is the current Selling Price (including GST) = RRP – discount
Sell Through %
Sales AR / Intake units
SizeA(S)%- Size Availability Simple
Count of Sizes in Stock / Count of Total Sizes Bought
SizeA(W)% - Size Availability Weighted
Units Bought in Sizes Still Available / Total Units Bought
Spot Cover
Shows how many more weeks stock will last based on the sales velocity of the current week (calculation is Closing Stock U / current week's Sales AR)
and if the Sales AR for the week is zero then it will show actual Stock U
ST% - Sell Through %
Only shows when time slicing, and should show Sales AR for that period/CSOH of the previous week
Stock U
Stock on Hand Units
Stock at Retail ex GST
Stock at original retail ex GST. The calculation is (RRP ex GST rounded) x Stock Units
Total Intake U
Sales AR + Closing SOH - Opening SOH (up to the last date applied in the time slice)
Total MD$
Difference between:
- what the product would have sold for at full price (Sales U AR x RRP (ex tax)
- and what it actually sold for (Sales AR)
Sales U AR x RRP (ex tax) - Sales AR = Total Markdown $
Total MD%
Total MD$/(Sales U AR x RRP (ex tax))
Transferred U
What has been transferred into or out of the current channel/store
Wks Active
How many weeks a product was 'live' i.e how many weeks was it in stock and able to make sales after the launch date. If a product sells out and comes back into stock it will calculate from the original launch date. This also takes into account if a time filter is applied
Wks Age
How many weeks has the product been in the business since its 1st date of launch. Not affected by time filters