ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
namesluginputformuladefinition
2
Gross Sales Ticketgross_sales_ticket{gross_sales_retail} + {markdown} + {discount}Topline sales prior to returns and allowances (i.e. markdowns and discounts). Measured in ticket value.
3
Gross Sales Retailgross_sales_retail{sale__sales_retail}Topline sales prior to returns, but after allowances (i.e. markdowns and discounts). Measured in retail value.
4
Gross Sales Unitsgross_sales_units{sale__sales_units}Topline sales prior to returns. Measured in units.
5
Original Forecast Unitsoriginal_forecast_units{sale__sales_units}
6
Original AI Forecast Unitsoriginal_ai_forecast_units{sale__sales_units}
7
Gross Sales Costgross_sales_cost{sale__sales_cost}Topline sales prior to returns. Measured in cost value.
8
Gross Sales AUCgross_sales_auc{gross_sales_cost} / {gross_sales_units}Average Unit Cost of Gross Sales
9
Gross Sales AURgross_sales_aur{gross_sales_retail} / {gross_sales_units}Average Units Retail (i.e. retail value) of Gross Sales
10
Gross Sales AIRgross_sales_air{gross_sales_ticket} / {gross_sales_units}Average Initial Inventory at Retail (i.e. ticket value) of Gross Sales
11
Gross Sales Margingross_sales_margin{gross_sales_retail} - {gross_sales_cost}
12
Gross Sales Margin %gross_sales_margin_percentage({gross_sales_retail} - {gross_sales_cost}) / {gross_sales_retail}
13
Gross Sales Margin Dilutiongross_sales_margin_dilution(({gross_sales_ticket} - {gross_sales_cost}) / {gross_sales_ticket}) - (({gross_sales_retail} - {gross_sales_cost}) / {gross_sales_retail})
14
Markdownmarkdown{sale__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).
15
Markdown %markdown_percentage{markdown} / {gross_sales_ticket}
16
Discountdiscount{sale__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.
17
Discount %discount_percentage{discount} / {gross_sales_ticket}
18
Returns Ticketreturns_ticket{sale__returns_ticket}Returns, measured in ticket value.
19
Returns Retailreturns_retail{sale__returns_retail}Returns, measured in retail value.
20
Returns Unitsreturns_units{sale__returns_units}
21
Returns Costreturns_cost{sale__returns_cost}
22
Returns AUCreturns_auc{returns_cost} / {returns_units}
23
Returns AURreturns_aur{returns_retail} / {returns_units}
24
Returns AIRreturns_air{returns_ticket} / {returns_units}
25
Returns Marginreturns_margin{returns_retail} - {returns_cost}
26
Returns Margin %returns_margin_percentage({returns_retail} - {returns_cost}) / {returns_retail}
27
Returns Rate Ticketreturns_rate_ticket{returns_ticket} / ({gross_sales_retail}+{discount}+{markdown})
28
Returns Rate Retailreturns_rate_retail{returns_retail} / {gross_sales_retail}
29
Returns Rate Unitsreturns_rate_units{returns_units} / {gross_sales_units}
30
Returns Rate Costreturns_rate_cost{returns_cost} / {gross_sales_cost}
31
Returns Rate Marginreturns_rate_margin{returns_margin} / {gross_sales_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.
32
Net Sales Ticketnet_sales_ticket{gross_sales_ticket} - {returns_ticket}
33
Net Sales Retailnet_sales_retail{gross_sales_retail} - {returns_retail}
34
Net Sales Unitsnet_sales_units{gross_sales_units} - {returns_units}
35
Net Sales Costnet_sales_cost{gross_sales_cost} - {returns_cost}
36
Net Sales AUCnet_sales_auc({gross_sales_cost} - {returns_cost}) / ({gross_sales_units} - {returns_units})
37
Net Sales AURnet_sales_aur({gross_sales_retail} - {returns_retail}) / ({gross_sales_units} - {returns_units})
38
Net Sales AIRnet_sales_air({gross_sales_ticket} - {returns_ticket}) / ({gross_sales_units} - {returns_units})
39
Net Sales Marginnet_sales_margin({gross_sales_retail} - {returns_retail}) - ({gross_sales_cost} - {returns_cost})
40
Net Sales Margin %net_sales_margin_percentage(({gross_sales_retail} - {returns_retail}) - ({gross_sales_cost} - {returns_cost})) / ({gross_sales_retail} - {returns_retail})
41
BOP Ticketbop_ticket{inventory__total_ticket}Beginning of period inventory measured at ticket value.
42
BOP Retailbop_retail{inventory__total_retail}Beginning of period inventory measured in retail value.
43
BOP Unitsbop_units{inventory__units}
44
Current Inventorycurrent_inventory_units{inventory__units}
45
BOP Costbop_cost{inventory__total_cost}
46
BOP AUCbop_auc{bop_cost} / {bop_units}
47
BOP AURbop_aur{bop_retail} / {bop_units}
48
BOP AIRbop_air{bop_ticket} / {bop_units}
49
BOP Marginbop_margin{bop_retail} - {bop_cost}
50
BOP Margin %bop_margin_percentage({bop_retail} - {bop_cost}) / {bop_retail}
51
BOP IMUbop_imu({bop_ticket} - {bop_cost}) / {bop_ticket}Initial Markup of the Inventory
52
EOP Ticketeop_ticket{inventory__total_ticket}{bop_ticket} + {receipts_ticket} - {gross_sales_retail} + {returns_ticket} + {transfer_receipts_ticket} + {adjustment_ticket}End of period inventory, measured in ticket value.
53
EOP Retaileop_retail{inventory__total_retail}{bop_retail} + {receipts_retail} - {gross_sales_retail} + {returns_retail} + {transfer_receipts_retail} + {adjustment_retail} - {discount} - {inventory_markdown}End of period inventory, measured in retail value.
54
EOP Unitseop_units{inventory__units}{bop_units} + {receipts_units} - {gross_sales_units} + {returns_units} + {transfer_receipts_units} + {adjustment_units}End of period inventory, measured in units.
55
EOP Costeop_cost{inventory__total_cost}{bop_cost} + {receipts_cost} - {gross_sales_cost} + {returns_cost} + {transfer_receipts_cost} + {adjustment_cost}End of period inventory, measured in cost value.
56
EOP AUCeop_auc{eop_cost} / {eop_units}End of period inventory, average unit cost.
57
EOP AUReop_aur{eop_retail} / {eop_units}End of period inventory, average unit retail.
58
EOP AIReop_air{eop_ticket} / {eop_units}End of period inventory, average initial retail.
59
EOP Margineop_margin{eop_retail} - {eop_cost}
60
EOP Margin %eop_margin_percentage({eop_retail} - {eop_cost}) / {eop_retail}
61
EOP IMUeop_imu({eop_ticket} - {eop_cost}) / {eop_ticket}Initial Markup of the Ending Inventory
62
Average Inventory Retailaverage_inventory_retailAVERAGE({bop_retail})
63
Average Inventory Costaverage_inventory_costAVERAGE({bop_cost})
64
Average Inventory Unitsaverage_inventory_unitsAVERAGE({bop_units})
65
On Order AUCon_order_auc{on_order_cost} / {on_order_units}
66
On Order AURon_order_aur{on_order_retail} / {on_order_units}
67
On Order AIRon_order_air{on_order_ticket} / {on_order_units}
68
On Order Marginon_order_margin{on_order_retail} - {on_order_cost}
69
On Order Margin %on_order_margin_percentage({on_order_retail} - {on_order_cost}) / {on_order_retail}
70
Receipts AUCreceipts_auc{receipts_cost} / {receipts_units}
71
Receipts AURreceipts_aur{receipts_retail} / {receipts_units}
72
Receipts AIRreceipts_air{receipts_ticket} / {receipts_units}
73
Receipts Marginreceipts_margin{receipts_retail} - {receipts_cost}
74
Receipts Margin %receipts_margin_percentage({receipts_retail} - {receipts_cost}) / {receipts_retail}
75
Receipts IMUreceipts_imu({receipts_ticket} - {receipts_cost}) / {receipts_ticket}Initial Markup for the receipts
76
IMUimu({gross_sales_retail} + {markdown} + {discount} - {gross_sales_cost}) / ({gross_sales_retail} + {markdown} + {discount})Initial Markup percentage applied on products to get to Gross Sales Ticket
77
Initial Margininitial_margin{gross_sales_ticket} - {gross_sales_cost} Initial Markup applied on products to get to Gross Sales Ticket
78
Net ST Retailst_retail({gross_sales_retail} - {returns_retail}) / ({bop_retail} + {receipts_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.
79
Net ST Unitsst_units({gross_sales_units} - {returns_units}) / ({bop_units} + {receipts_units})
80
Net ST Costst_cost({gross_sales_cost} - {returns_cost}) / ({bop_cost} + {receipts_cost})
81
Net WOS Retailwos_retail{eop_retail} / (AVERAGE({gross_sales_retail}) - AVERAGE({returns_retail}))Weeks of Supply remaining, measured in retail value.
82
Net WOS Unitswos_units{eop_units} / (AVERAGE({gross_sales_units}) - AVERAGE({returns_units}))
83
Net WOS Costwos_cost{eop_cost} / (AVERAGE({gross_sales_cost}) - AVERAGE({returns_cost}))
84
Net Turn Retailturn_retail({gross_sales_retail} - {returns_units}) / AVERAGE({bop_retail})Inventory Turn, measured in retail value.
85
Net Turn Unitsturn_units({gross_sales_units} - {returns_units}) / AVERAGE({bop_units})
86
Net Turn Costturn_cost({gross_sales_cost} - {returns_cost}) / AVERAGE({bop_cost})
87
GMROIgmroi({gross_sales_retail} - {gross_sales_cost}) / AVERAGE({bop_cost})Gross Margin Return on Inventory Investment
88
Open to Buy Ticketopen_to_buy_ticket{receipts_ticket__plan} - {on_order_ticket__act} - {receipts_ticket__act}
89
Open to Buy Retailopen_to_buy_retail{receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act}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.
90
Open to Buy Unitsopen_to_buy_units{receipts_units__plan} - {on_order_units__act} - {receipts_units__act}
91
Open to Buy Costopen_to_buy_cost{receipts_cost__plan} - {on_order_cost__act} - {receipts_cost__act}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.
92
Open to Buy Marginopen_to_buy_margin({receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act} ) - ({receipts_cost__plan} - {on_order_cost__act} - {receipts_cost__act})
93
Open to Buy Margin %open_to_buy_margin_percentage(({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})
94
Open to Buy AUCopen_to_buy_auc({receipts_cost__plan} - {on_order_cost__act} - {receipts_cost__act}) / ({receipts_units__plan} - {on_order_units__act} - {receipts_units__act})
95
Open to Buy AURopen_to_buy_aur({receipts_retail__plan} - {on_order_retail__act} - {receipts_retail__act}) / ({receipts_units__plan} - {on_order_units__act} - {receipts_units__act})
96
Open to Buy AIRopen_to_buy_air({receipts_ticket__plan} - {on_order_ticket__act} - {receipts_ticket__act}) / ({receipts_units__plan} - {on_order_units__act} - {receipts_units__act})
97
New Stylesnew_stylesIS_IN_TIME_PERIOD('{product_2__first_sale_date}') ? '{variant__product_id}' : nullOnly used in Merchandise Plan. It shows the distinct number of Styles that were sold within the given time frame.
98
Styles per Weektotal_styles'{variant__product_id}'Only used in Merchandise Plan. It shows the total number of Styles that were sold within a week. When aggregated over time, the average per week is taken
99
New Choicesnew_choicesIS_IN_TIME_PERIOD('{variant__choice_first_sale_date}') ? (CHOICE_DEFINITIONS_CONCAT) : nullOnly used in Merchandise Plan. It shows the distinct number of choices that were sold within the given time frame.
100
Choices per Weektotal_choicesCHOICE_DEFINITIONS_CONCATOnly used in Merchandise Plan. It shows the total number of choices that were sold within a week. When aggregated over time, the average per week is taken