Below is a bucket list of all of the Metrics Toolio comes out of the box with. If you want to learn more about metrics before diving into this list, please see the Metrics - Overview article first. You can see these Metrics in the Grid Format as well.
Gross Sales Ticket
Topline sales prior to returns and allowances (i.e. markdowns and discounts). Measured in ticket value.
Formula:
{gross_sales_retail} + {markdown} + {discount}
Gross Sales Retail
Topline sales prior to returns, but after allowances (i.e. markdowns and discounts). Measured in retail value.
Actualization:
{sale__sales_retail}
Gross Sales Units
Topline sales prior to returns. Measured in units.
Actualization:
{sale__sales_units}
Original Forecast Units
Actualization:
{sale__sales_units}
Gross Sales Cost
Topline sales prior to returns. Measured in cost value.
Actualization:
{sale__sales_cost}
Gross Sales AUC
Average Unit Cost of Gross Sales
Formula:
{gross_sales_cost} / {gross_sales_units}
Gross Sales AUR
Average Units Retail (i.e. retail value) of Gross Sales
Formula:
{gross_sales_retail} / {gross_sales_units}
Gross Sales AIR
Average Initial Inventory at Retail (i.e. ticket value) of Gross Sales
Formula:
{gross_sales_ticket} / {gross_sales_units}
Gross Sales Margin
Formula:
{gross_sales_retail} - {gross_sales_cost}
Gross Sales Margin %
Formula:
({gross_sales_retail} - {gross_sales_cost}) / {gross_sales_retail}
Gross Sales Margin Dilution
Formula:
(({gross_sales_ticket} - {gross_sales_cost}) / {gross_sales_ticket}) - (({gross_sales_retail} - {gross_sales_cost}) / {gross_sales_retail})
Markdown
Markdowns are price reductions on items. These are reductions that are marked on the price tags, so they are also known as redlines. Markdowns cover all reductions that happen prior to the point of sale (POS).
Actualization:
{sale__markdown}
Markdown %
Formula:
{markdown} / {gross_sales_ticket}
Discount
Discounts are one-time price reductions applied at the point of sale (POS). Employee discounts or special promos for a weekend are some examples of these.
Actualization:
{sale__discount}
Discount %
Formula:
{discount} / {gross_sales_ticket}
Returns Ticket
Returns, measured in ticket value.
Actualization:
{sale__returns_ticket}
Returns Retail
Returns, measured in retail value.
Actualization:
{sale__returns_retail}
Returns Units
Actualization:
{sale__returns_units}
Returns Cost
Actualization:
{sale__returns_cost}
Returns AUC
Formula:
{returns_cost} / {returns_units}
Returns AUR
Formula:
{returns_retail} / {returns_units}
Returns AIR
Formula:
{returns_ticket} / {returns_units}
Returns Margin
Formula:
{returns_retail} - {returns_cost}
Returns Margin %
Formula:
({returns_retail} - {returns_cost}) / {returns_retail}
Returns Rate Retail
Formula:
{returns_retail} / {gross_sales_retail}
Returns Rate Units
Formula:
{returns_units} / {gross_sales_units}
Returns Rate Cost
Formula:
{returns_cost} / {gross_sales_cost}
Returns Rate Margin
Ratio of the margin that was returned and margin that was in gross sales. This gives an idea of whether more or less profitable items are being returned.
Formula:
{returns_margin} / {gross_sales_margin}
Net Sales Ticket
Formula:
{gross_sales_ticket} - {returns_ticket}
Net Sales Retail
Formula:
{gross_sales_retail} - {returns_retail}
Net Sales Units
Formula:
{gross_sales_units} - {returns_units}
Net Sales Cost
Formula:
{gross_sales_cost} - {returns_cost}
Net Sales AUC
Formula:
{net_sales_cost} / {net_sales_units}
Net Sales AUR
Formula:
{net_sales_retail} / {net_sales_units}
Net Sales AIR
Formula:
{net_sales_ticket} / {net_sales_units}
Net Sales Margin
Formula:
{net_sales_retail} - {net_sales_cost}
Net Sales Margin %
Formula:
({net_sales_retail} - {net_sales_cost}) / {net_sales_retail}
BOP Ticket
Beginning of period inventory measured at ticket value.
Actualization:
{inventory__total_ticket}
BOP Retail
Beginning of period inventory measured in retail value.
Actualization:
{inventory__total_retail}
BOP Units
Actualization:
{inventory__units}
Current Inventory
Actualization:
{inventory__units}
BOP Cost
Actualization:
{inventory__total_cost}
BOP AUC
Formula:
{bop_cost} / {bop_units}
BOP AUR
Formula:
{bop_retail} / {bop_units}
BOP AIR
Formula:
{bop_ticket} / {bop_units}
BOP Margin
Formula:
{bop_retail} - {bop_cost}
BOP Margin %
Formula:
({bop_retail} - {bop_cost}) / {bop_retail}
BOP IMU
Initial Markup of the Inventory
Formula:
({bop_ticket} - {bop_cost}) / {bop_ticket}
EOP Ticket
End of period inventory, measured in ticket value.
Actualization:
{inventory__total_ticket}Formula:
{bop_ticket} + {receipts_ticket} - {gross_sales_retail} - {markdown} - {discount} + {returns_ticket} + {transfer_receipts_ticket} + {adjustment_ticket}
EOP Retail
End of period inventory, measured in retail value.
Actualization:
{inventory__total_retail}Formula:
{bop_retail} + {receipts_retail} - {gross_sales_retail} + {returns_retail} + {transfer_receipts_retail} + {adjustment_retail}
EOP Units
End of period inventory, measured in units.
Actualization:
{inventory__units}Formula:
{bop_units} + {receipts_units} - {gross_sales_units} + {returns_units} + {transfer_receipts_units} + {adjustment_units}
EOP Cost
End of period inventory, measured in cost value.
Actualization:
{inventory__total_cost}Formula:
{bop_cost} + {receipts_cost} - {gross_sales_cost} + {returns_cost} + {transfer_receipts_cost} + {adjustment_cost}
EOP AUC
End of period inventory, average unit cost.
Formula:
{eop_cost} / {eop_units}
EOP AUR
End of period inventory, average unit retail.
Formula:
{eop_retail} / {eop_units}
EOP AIR
End of period inventory, average initial retail.
Formula:
{eop_ticket} / {eop_units}
EOP Margin
Formula:
{eop_retail} - {eop_cost}
EOP Margin %
Formula:
({eop_retail} - {eop_cost}) / {eop_retail}
EOP IMU
Initial Markup of the Ending Inventory
Formula:
({eop_ticket} - {eop_cost}) / {eop_ticket}
Average Inventory Retail
Formula:
AVERAGE({bop_retail})
Average Inventory Cost
Formula:
AVERAGE({bop_cost})
Average Inventory Units
Formula:
AVERAGE({bop_units})
On Order AUC
Formula:
{on_order_cost} / {on_order_units}
On Order AUR
Formula:
{on_order_retail} / {on_order_units}
On Order AIR
Formula:
{on_order_ticket} / {on_order_units}
On Order Margin
Formula:
{on_order_retail} - {on_order_cost}
On Order Margin %
Formula:
({on_order_retail} - {on_order_cost}) / {on_order_retail}
Receipts AUC
Formula:
{receipts_cost} / {receipts_units}
Receipts AUR
Formula:
{receipts_retail} / {receipts_units}
Receipts AIR
Formula:
{receipts_ticket} / {receipts_units}
Receipts Margin
Formula:
{receipts_retail} - {receipts_cost}
Receipts Margin %
Formula:
({receipts_retail} - {receipts_cost}) / {receipts_retail}
Receipts IMU
Initial Markup for the receipts
Formula:
({receipts_ticket} - {receipts_cost}) / {receipts_ticket}
IMU
Initial Markup percentage applied on products to get to Gross Sales Ticket
Formula:
({gross_sales_retail} + {markdown} + {discount} - {gross_sales_cost}) / ({gross_sales_retail} + {markdown} + {discount})
Initial Margin
Initial Markup applied on products to get to Gross Sales Ticket
Formula:
{gross_sales_ticket} - {gross_sales_cost}
Net ST Retail
Sell Through %, measured in retail value. This is a measure of the % of beginning inventory and receipts have been sold in the time period.
Formula:
({gross_sales_retail} - {returns_retail}) / ({bop_retail} + {receipts_retail})
Net ST Units
Formula:
({gross_sales_units} - {returns_units}) / ({bop_units} + {receipts_units})
Net ST Cost
Formula:
({gross_sales_cost} - {returns_cost}) / ({bop_cost} + {receipts_cost})
Net WOS Retail
Weeks of Supply remaining, measured in retail value.
Formula:
{eop_retail} / (AVERAGE({gross_sales_retail}) - AVERAGE({returns_retail}))
Net WOS Units
Formula:
{eop_units} / (AVERAGE({gross_sales_units}) - AVERAGE({returns_units}))
Net WOS Cost
Formula:
{eop_cost} / (AVERAGE({gross_sales_cost}) - AVERAGE({returns_cost}))
Net Turn Retail
Inventory Turn, measured in retail value.
Formula:
({gross_sales_retail} - {returns_units}) / AVERAGE({bop_retail})
Net Turn Units
Formula:
({gross_sales_units} - {returns_units}) / AVERAGE({bop_units})
Net Turn Cost
Formula:
({gross_sales_cost} - {returns_cost}) / AVERAGE({bop_cost})
GMROI
Gross Margin Return on Inventory Investment
Formula:
({gross_sales_retail} - {gross_sales_cost}) / AVERAGE({bop_cost})
Open to Buy Ticket
Formula:
{receipts_ticket__plan} - {on_order_ticket__act} - {receipts_ticket__act}
Open to Buy Retail
Open To Buy, measured in retail value. This give an indicator of how much more should be invested to meet the receipts targets to meet the desired end of period inventory position.
Formula:
{receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act}
Open to Buy Units
Formula:
{receipts_units__plan} - {on_order_units__act} - {receipts_units__act}
Open to Buy Cost
Open To Buy, measured in cost value. This give an indicator of how much more should be invested to meet the receipts targets to meet the desired end of period inventory position. This is typically the appropriate way to look at Open to Buy, since cash-flow will be happening in Cost.
Formula:
{receipts_cost__plan} - {on_order_cost__act} - {receipts_cost__act}
Open to Buy Margin
Formula:
({receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act} ) - ({receipts_cost__plan} - {on_order_cost__act} - {receipts_cost__act})
Open to Buy Margin %
Formula:
(({receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act}) - ({receipts_cost__plan} - {on_order_cost__act} -{receipts_cost__act})) / ({receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act})
Open to Buy AUC
Formula:
({receipts_cost__plan} - {on_order_cost__act} - {receipts_cost__act}) / ({receipts_units__plan} - {on_order_units__act} - {receipts_units__act})
Open to Buy AUR
Formula:
({receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act}) / ({receipts_units__plan} - {on_order_units__act} - {receipts_units__act})
Open to Buy AIR
Formula:
({receipts_ticket__plan} - {on_order_ticket__act} - {receipts_ticket__act}) / ({receipts_units__plan} - {on_order_units__act} - {receipts_units__act})
New Styles
Actualization:
IS_IN_TIME_PERIOD('{product_2__first_sale_date}') ? '{variant__product_id}' : null
Styles per Week
Actualization:
'{variant__product_id}'
New Choices
Actualization:
IS_IN_TIME_PERIOD('{variant__choice_first_sale_date}') ? (CHOICE_DEFINITIONS_CONCAT) : null
Choices per Week
Actualization:
CHOICE_DEFINITIONS_CONCAT
New SKUs
Actualization:
IS_IN_TIME_PERIOD('{variant__first_sale_date}') ? '{variant__variant_id}' : null
SKUS per Week
Actualization:
'{variant__variant_id}'
FWD WOS Retail
Forward weeks of supply remaining, based on future weeks' planned sales and current period's BOP. If there are more than 52 weeks of supply, forward weeks of supply will be capped at 52.
Formula:
FWOS({bop_retail},{gross_sales_retail})
FWD WOS Units
Forward weeks of supply remaining, based on future weeks' planned sales and current period's BOP. If there are more than 52 weeks of supply, forward weeks of supply will be capped at 52.
Formula:
FWOS({bop_units},{gross_sales_units})
FWD WOS Cost
Forward weeks of supply remaining, based on future weeks' planned sales and current period's BOP. If there are more than 52 weeks of supply, forward weeks of supply will be capped at 52.
Formula:
FWOS({bop_cost},{gross_sales_cost})
Gross ST Retail
Formula:
{gross_sales_retail} / ({bop_retail} + {receipts_retail})
Gross ST Units
Formula:
{gross_sales_units} / ({bop_units} + {receipts_units})
Gross ST Cost
Formula:
{gross_sales_cost} / ({bop_cost} + {receipts_cost})
Gross WOS Ticket
Formula:
{eop_ticket} / (AVERAGE({gross_sales_retail}) + AVERAGE({markdown}) + AVERAGE({discount}))
Gross WOS Retail
Weeks of Supply remaining, measured in gross retail value.
Formula:
{eop_retail} / AVERAGE({gross_sales_retail})
Gross WOS Units
Formula:
{eop_units} / AVERAGE({gross_sales_units})
Gross WOS Cost
Formula:
{eop_cost} / AVERAGE({gross_sales_cost})
Gross Turn Retail
Inventory Turn, measured in gross retail value.
Formula:
{gross_sales_retail} / AVERAGE({bop_retail})
Gross Turn Units
Formula:
{gross_sales_units} / AVERAGE({bop_units})
Gross Turn Cost
Formula:
{gross_sales_cost} / AVERAGE({bop_cost})
Average per Week
Formula:
AVERAGE({gross_sales_units})
New Choices Productivity Units
Formula:
{gross_sales_units} / {new_choices}
Weekly Choice Productivity
Formula:
AVERAGE({gross_sales_units}) / {total_choices}
New Styles Productivity Units
Formula:
{gross_sales_units} / {new_styles}
Weekly Styles Productivity
Formula:
AVERAGE({gross_sales_units}) / {total_styles}
Total Allowances
Formula:
{markdown} + {discount}
Total Allowances %
Formula:
({markdown} + {discount}) / {gross_sales_ticket}
Receipts Ticket
Purchase Orders that are received in the given time period, measured in ticket value.
Actualization:
{receipt__received_units} * {receipt__unit_ticket}
Receipts Retail
Purchase Orders that are received in the given time period, measured in retail value.
Actualization:
{receipt__received_units} * {receipt__unit_retail}
Receipts Units
Actualization:
{receipt__received_units}
Receipts Cost
Actualization:
{receipt__received_units} * {receipt__unit_cost}
On Order Ticket
Purchase Orders that are meant to be received in given time period, measured in ticket value.
Actualization:
Math.max({purchase_order_item_2__order_units} - {receiptUnitsTotal},0) ? Math.max(({purchase_order_item_2__order_units} * {purchase_order_item_2__unit_ticket}) - {receiptTicketTotal},0) : 0
On Order Retail
Purchase Orders that are meant to be received in given time period, measured in retail value.
Actualization:
Math.max({purchase_order_item_2__order_units} - {receiptUnitsTotal},0) ? Math.max(({purchase_order_item_2__order_units} * {purchase_order_item_2__unit_retail}) - {receiptRetailTotal},0) : 0
On Order Units
Actualization:
Math.max({purchase_order_item_2__order_units} - {receiptUnitsTotal},0)
On Order Cost
Actualization:
Math.max({purchase_order_item_2__order_units} - {receiptUnitsTotal},0) ? Math.max(({purchase_order_item_2__order_units} * {purchase_order_item_2__unit_cost}) - {receiptCostTotal},0) : 0
Average Daily Sales Ticket
Formula:
(AVERAGE({gross_sales_retail}) + AVERAGE({markdown}) + AVERAGE({discount})) / 7.00
Average Daily Sales Retail
Formula:
AVERAGE({gross_sales_retail}) / 7.00
Average Daily Sales Cost
Formula:
AVERAGE({gross_sales_cost}) / 7.00
Average Daily Sales Units
Formula:
AVERAGE({gross_sales_units}) / 7.00
Days of Cover Ticket
Formula:
{gross_wos_ticket} * 7
Days of Cover Retail
Formula:
{gross_wos_retail} * 7
Days of Cover Cost
Formula:
{gross_wos_cost} * 7
Days of Cover Units
Formula:
{gross_wos_units} * 7
ATS Ticket
Formula:
{bop_ticket} + {receipts_ticket}
ATS Retail
Formula:
{bop_retail} + {receipts_retail}
ATS Cost
Formula:
{bop_cost} + {receipts_cost}
ATS Units
Formula:
{bop_units} + {receipts_units}
Adjustment Ticket
Adjustment Retail
Adjustment Cost
Adjustment Units
Adjustment Ticket Rate
Formula:
{adjustment_ticket} / {bop_ticket}
Adjustment Retail Rate
Formula:
{adjustment_retail} / {bop_retail}
Adjustment Cost Rate
Formula:
{adjustment_cost} / {bop_cost}
Adjustment Unit Rate
Formula:
{adjustment_units} / {bop_units}
Adjustment AIR
Formula:
{adjustment_ticket} / {adjustment_units}
Adjustment AUR
Formula:
{adjustment_retail} / {adjustment_units}
Adjustment AUC
Formula:
{adjustment_cost} / {adjustment_units}
Gross Stock to Sales Retail
Stock to Sales measured in retail
Formula:
AVERAGE({bop_retail}) / AVERAGE({gross_sales_retail})
Gross Stock to Sales Units
Stock to Sales measured in units
Formula:
AVERAGE({bop_units}) / AVERAGE({gross_sales_units})
Gross Stock to Sales Cost
Stock to Sales measured in cost
Formula:
AVERAGE({bop_cost}) / AVERAGE({gross_sales_cost})
Transfer Receipts Ticket
Actualization:
{transfer_order__transferReceiptsTicket}
Transfer Receipts Retail
Actualization:
{transfer_order__transferReceiptsRetail}
Transfer Receipts Units
Actualization:
{transfer_order__transferReceiptsUnits}
Transfer Receipts Cost
Actualization:
{transfer_order__transferReceiptsCost}
Transfer Receipts AIR
Formula:
{transfer_receipts_ticket} / {transfer_receipts_units}
Transfer Receipts AUR
Formula:
{transfer_receipts_retail} / {transfer_receipts_units}
Transfer Receipts AUC
Formula:
{transfer_receipts_cost} / {transfer_receipts_units}
In Transit to Place Ticket
Formula:
{transfer_receipts_ticket} - {transfer_receipts_ticket}
In Transit to Place Retail
Formula:
{transfer_receipts_retail} - {transfer_receipts_retail}
In Transit to Place Units
Formula:
{transfer_receipts_units} - {transfer_receipts_units}
In Transit to Place Cost
Formula:
{transfer_receipts_cost} - {transfer_receipts_cost}
In Transit to Ship Ticket
In Transit to Ship Retail
In Transit to Ship Units
In Transit to Ship Cost
In Transit Ticket
Actualization:
{transfer_order__inTransitTicket}
In Transit Retail
Actualization:
{transfer_order__inTransitRetail}
In Transit Units
Actualization:
{transfer_order__inTransitUnits}
In Transit Cost
Actualization:
{transfer_order__inTransitCost}
Demand Ticket
Demand Units
Demand Retail
Demand Cost
Safety Stock Units
Order Cycle Units
Min. Pres. Units
Effective Safety Stock Units
Ideal Stock Units
Excess Units
Shortfall Units
Potential Lost Sales Units
Missed Opportunity Ticket
Formula:
({demand_ticket} - {gross_sales_retail} - {markdown} - {discount}) < 0 ? 0 : ({demand_ticket} - {gross_sales_retail} - {markdown} - {discount})
Missed Opportunity Units
Formula:
({demand_units} - {gross_sales_units}) < 0 ? 0 : ({demand_units} - {gross_sales_units})
Missed Opportunity Retail
Formula:
({demand_retail} - {gross_sales_retail}) < 0 ? 0 : ({demand_retail} - {gross_sales_retail})
Missed Opportunity Cost
Formula:
({demand_cost} - {gross_sales_cost}) < 0 ? 0 : ({demand_cost} - {gross_sales_cost})
Gross Sales Lift Units
Like For Like Gross Sales Units
Like For Like Gross Sales Retail
Like For Like Gross Sales Cost
Bookings Ticket
Topline sales prior to returns and allowances (i.e. markdowns and discounts). Measured in ticket value.
Actualization:
{booking__total_ticket}
Bookings Retail
Topline sales prior to returns, but after allowances (i.e. markdowns and discounts). Measured in retail value.
Actualization:
{booking__total_retail}
Bookings Units
Topline sales prior to returns. Measured in units.
Actualization:
{booking__units}
Bookings Cost
Topline sales prior to returns. Measured in cost value.
Actualization:
{booking__total_cost}
Bookings Fill Rate Units
Average Unit Cost of Gross Sales
Formula:
{gross_sales_units} / {bookings_units}
Dependent Ticket
Dependent Retail
Dependent Units
Dependent Cost
Constrained Dependent Ticket
Constrained Dependent Retail
Constrained Dependent Units
Constrained Dependent Cost
Sales Returns Ticket
Actualization:
{sale__returns_ticket}
Sales Returns Retail
Actualization:
{sale__returns_retail}
Sales Returns Units
Actualization:
{sale__returns_units}
Sales Returns Cost
Actualization:
{sale__returns_cost}
Sales Returns Margin
Formula:
{sales_returns_retail} - {sales_returns_cost}
Sales Returns Rate Retail
Formula:
{sales_returns_retail} / {gross_sales_retail}
Sales Returns Rate Units
Formula:
{sales_returns_units} / {gross_sales_units}
Sales Returns Rate Cost
Formula:
{sales_returns_cost} / {gross_sales_cost}
Sales Returns Rate Margin
Ratio of the margin that was returned from sales and margin that was in gross sales. This gives an idea of whether more or less profitable items are being returned.
Formula:
{sales_returns_margin} / {gross_sales_margin}
ROS
Formula:
{gross_sales_units}
Sales Returns AUC
Formula:
{sales_returns_cost} / {sales_returns_units}
Sales Returns AUR
Formula:
{sales_returns_retail} / {sales_returns_units}
Sales Returns AIR
Formula:
{sales_returns_ticket} / {sales_returns_units}
Potential Lost Sales Retail
Formula:
{potential_lost_sales_units} * (({gross_sales_retail}) / {gross_sales_units})
Potential Lost Sales Cost
Formula:
{potential_lost_sales_units} * (({gross_sales_cost}) / {gross_sales_units})
Potential Lost Sales Margin
Formula:
{potential_lost_sales_retail} - {potential_lost_sales_cost}
Potential Lost GM%
Formula:
{potential_lost_sales_margin} / {potential_lost_sales_retail}
Is Markdown
Markdown Lift %
Gross Sales ACR
Gross Sales Current Retail
Constrained Sales Ticket
Constrained Sales Retail
Constrained Sales Units
Constrained Sales Cost
Gross Sales FP Ticket
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_ticket})
Gross Sales FP Retail
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_retail})
Gross Sales FP Units
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_units})
Gross Sales FP Cost
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_cost})
Gross Sales FP AUC
Average Unit Cost of Gross Sales
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_cost} / {gross_sales_units})
Gross Sales FP AUR
Average Units Retail (i.e. retail value) of Gross Sales
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_retail} / {gross_sales_units})
Gross Sales FP AIR
Average Initial Inventory at Retail (i.e. ticket value) of Gross Sales
Formula:
({is_markdown}) != 0 ? 0 : ({gross_sales_ticket} / {gross_sales_units})
Gross Sales MD Ticket
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_ticket})
Gross Sales MD Retail
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_retail})
Gross Sales MD Units
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_units})
Gross Sales MD Cost
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_cost})
Gross Sales MD AUC
Average Unit Cost of Gross Sales
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_cost} / {gross_sales_units})
Gross Sales MD AUR
Average Units Retail (i.e. retail value) of Gross Sales
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_retail} / {gross_sales_units})
Gross Sales MD AIR
Average Initial Inventory at Retail (i.e. ticket value) of Gross Sales
Formula:
({is_markdown}) == 0 ? 0 : ({gross_sales_ticket} / {gross_sales_units})
BOP FP Ticket
Formula:
({is_markdown}) != 0 ? 0 : ({bop_ticket})
BOP FP Retail
Formula:
({is_markdown}) != 0 ? 0 : ({bop_retail})
BOP FP Units
Formula:
({is_markdown}) != 0 ? 0 : ({bop_units})
BOP FP Retail
Formula:
({is_markdown}) != 0 ? 0 : ({bop_cost})
BOP MD Ticket
Formula:
({is_markdown}) == 0 ? 0 : ({bop_ticket})
BOP MD Retail
Formula:
({is_markdown}) == 0 ? 0 : ({bop_retail})
BOP MD Units
Formula:
({is_markdown}) == 0 ? 0 : ({bop_units})
BOP MD Retail
Formula:
({is_markdown}) == 0 ? 0 : ({bop_cost})
EOP FP Ticket
End of period inventory, measured in ticket value.
Formula:
({is_markdown}) != 0 ? 0 : ({bop_ticket} + {receipts_ticket} - {gross_sales_retail} - {markdown} - {discount} + {returns_ticket} + {transfer_receipts_ticket} + {adjustment_ticket})
EOP FP Retail
End of period inventory, measured in retail value.
Formula:
({is_markdown}) != 0 ? 0 : ({bop_retail} + {receipts_retail} - {gross_sales_retail} + {returns_retail} + {transfer_receipts_retail} + {adjustment_retail})
EOP FP Units
End of period inventory, measured in units.
Formula:
({is_markdown}) != 0 ? 0 : ({bop_units} + {receipts_units} - {gross_sales_units} + {returns_units} + {transfer_receipts_units} + {adjustment_units})
EOP FP Cost
End of period inventory, measured in cost value.
Formula:
({is_markdown}) != 0 ? 0 : ({bop_cost} + {receipts_cost} - {gross_sales_cost} + {returns_cost} + {transfer_receipts_cost} + {adjustment_cost})
EOP MD Ticket
End of period inventory, measured in ticket value.
Formula:
({is_markdown}) == 0 ? 0 : ({bop_ticket} + {receipts_ticket} - {gross_sales_retail} - {markdown} - {discount} + {returns_ticket} + {transfer_receipts_ticket} + {adjustment_ticket})
EOP MD Retail
End of period inventory, measured in retail value.
Formula:
({is_markdown}) == 0 ? 0 : ({bop_retail} + {receipts_retail} - {gross_sales_retail} + {returns_retail} + {transfer_receipts_retail} + {adjustment_retail})
EOP MD Units
End of period inventory, measured in units.
Formula:
({is_markdown}) == 0 ? 0 : ({bop_units} + {receipts_units} - {gross_sales_units} + {returns_units} + {transfer_receipts_units} + {adjustment_units})
EOP MD Cost
End of period inventory, measured in cost value.
Formula:
({is_markdown}) == 0 ? 0 : ({bop_cost} + {receipts_cost} - {gross_sales_cost} + {returns_cost} + {transfer_receipts_cost} + {adjustment_cost})
Inventory Markdown
Inventory Devaluation
Inventory Devaluation %
Inventory Markdown Units