This appendix contains a complete list of Oracle Retail Analytics metrics. See Chapter 6, "Metrics" for additional information about metrics.
Table C-1 Cost/Profit Metrics
Metric | Definition |
---|---|
Supplier Base Cost |
Initial cost without additional charges added, such as handling or shipping charges, sales tax, or deals or discounts for an item/location. |
Supplier Net Cost |
Initial base cost after any trade, cash, or off-invoice discounts for an item/location. This calculation can be used as an accurate idea of the real cost of a purchase. |
Supplier Net Net Cost |
Bottom line cost of an item after all discounts, fees, and charges have been calculated. It is net cost less any bill-back amounts for an item/location. |
Supplier Dead Net Cost |
Primary supplier's net net cost, less any rebate amounts for an item/location. |
Supplier Base Profit |
Difference between sales revenue generated by an item and its base cost. |
Supplier Net Profit |
Bottom line profit, calculated from money left over after paying all expenses and taxes. This is calculated from the primary supplier's net cost for an item/location. |
Supplier Net Net Profit |
Profit calculated from the primary supplier's net net cost for an item/location. |
Supplier Dead Net Profit |
Net result of all revenues and costs from every business activity. It is profit calculated from the primary supplier's dead net cost for an item/location. |
Supp Base Cost |
Initial base cost prior to any deals or discounts. |
Table C-2 Markdowns Metrics
Metric | Definition |
---|---|
Mkdn Amt |
Amount by which a seller reduces the price for an item to make it desirable to customers. This is the difference between the original retail and selling price. |
Clr Mkdn Amt |
Amount of reduction to the original selling price for reasons such as decline in overall prices of goods, excessive competition, special sale, damaged merchandise, or excess supply. |
Pro Mkdn Amt |
Amount of temporary reduction to a selling price to boost sales. This markdown is normally for a specified period of time, at the end of which the product price is raised back to the normal selling price. |
Pmt Mkdn Amt |
Amount of permanent reduction to the selling price of inventory. This type of markdown is used to remove slow-selling merchandise or replace out-of-date merchandise. |
Mkup Amt |
Extra amount a retailer charges a customer for an item, over and above what the retailer paid the supplier. This is the difference between the selling price and original retail. |
Mkdn Cancelled Amt |
Value of a clearance markdown amount that has been cancelled. |
Mkup Cancelled Amt |
Value of a markup amount that has been cancelled. A markup cancellation is used to correct an unintentional error in a previous markup. |
Mkdn Qty |
Quantity of units on clearance, promotion, and permanent markdown. |
Clr Mkdn Qty |
Quantity of units on clearance markdown. |
Pro Mkdn Qty |
Quantity of units on promotion markdown. |
Pmt Mkdn Qty |
Quantity of units on permanent markdown. |
Mkup Qty |
Quantity of inventory units on clearance, promotion, and permanent markup. |
Mkdn Cancelled Qty |
Quantity of units on which the markdown has been cancelled. |
Mkup Cancelled Qty |
Quantity of units on which the markup has been cancelled. |
Mkdn to Sales Amt |
Ratio of the markdown amount as a fraction of gross sales amount. The lower ratio depicts the efficiency of the marketing and pricing strategies of a retailer. This metric determines the sales driven by markdowns. |
Mkdn Amt LW |
Last week's value of markdowns. |
Clr Mkdn Amt LW |
Last week's value of clearance markdowns. |
Pro Mkdn Amt LW |
Last week's value of promotion markdowns. |
Pmt Mkdn Amt LW |
Last week's value of permanent markdowns. |
Mkup Amt LW |
Last week's value of markups. |
Mkdn Qty LW |
Last week's quantity of units on markdown. |
Clr Mkdn Qty LW |
Last week's quantity of units on clearance markdown. |
Pro Mkdn Qty LW |
Last week's quantity of units on promotion markdown. |
Pmt Mkdn Qty LW |
Last week's quantity of units on permanent markdown. |
Mkup Qty LW |
Last week's quantity of units on markup. |
Mkdn Amt LY |
Last year's value of markdowns. |
Clr Mkdn Amt LY |
Last year's value of clearance markdowns. |
Pro Mkdn Amt LY |
Last year's value of promotion markdowns. |
Pmt Mkdn Amt LY |
Last year's value of permanent markdowns. |
Mkup Amt LY |
Last year's value of markups. |
Mkdn Qty LY |
Last year's quantity of units on markdown. |
Clr Mkdn Qty LY |
Last year's quantity of units on clearance markdown. |
Pro Mkdn Qty LY |
Last year's quantity of units on promotion markdown. |
Pmt Mkdn Qty LY |
Last year's quantity of units on permanent markdown. |
Mkup Qty LY |
Last year's quantity of units on markup. |
Mkdn Amt WTD |
Week-to-date value of markdowns. |
Clr Mkdn Amt WTD |
Week-to-date value of clearance markdowns. |
Pro Mkdn Amt WTD |
Week-to-date value of promotion markdowns. |
Pmt Mkdn Amt WTD |
Week-to-date value of permanent markdowns. |
Mkup Amt WTD |
Week-to-date value of markups. |
Mkdn Qty WTD |
Week-to-date quantity of units on markdown. |
Clr Mkdn Qty WTD |
Week-to-date quantity of units on clearance markdown. |
Pro Mkdn Qty WTD |
Week-to-date quantity of units on promotion markdown. |
Pmt Mkdn Qty WTD |
Week-to-date quantity of units on permanent markdown. |
Mkup Qty WTD |
Week-to-date quantity of units on markup. |
Mkdn to Sales Amt WTD |
Week-to-date ratio of markdown amount as a fraction of gross sales amount. |
Mkdn Amt MTD |
Month-to-date value of markdowns. |
Clr Mkdn Amt MTD |
Month-to-date value of clearance markdowns. |
Pro Mkdn Amt MTD |
Month-to-date value of promotion markdowns. |
Pmt Mkdn Amt MTD |
Month-to-date value of permanent markdowns. |
Mkup Amt MTD |
Month-to-date value of markups. |
Mkdn Qty MTD |
Month-to-date quantity of units on markdown. |
Clr Mkdn Qty MTD |
Month-to-date quantity of units on clearance markdown. |
Pro Mkdn Qty MTD |
Month-to-date quantity of units on promotion markdown. |
Pmt Mkdn Qty MTD |
Month-to-date quantity of units on permanent markdown. |
Mkup Qty MTD |
Month-to-date quantity of units on markup. |
Mkdn to Sales Amt MTD |
Month-to-date ratio of markdown amount as a fraction of gross sales amount. |
Mkdn Amt YTD |
Year-to-date value of markdowns. |
Clr Mkdn Amt YTD |
Year-to-date value of clearance markdowns. |
Pro Mkdn Amt YTD |
Year-to-date value of promotion markdowns. |
Pmt Mkdn Amt YTD |
Year-to-date value of permanent markdowns. |
Mkup Amt YTD |
Year-to-date value of markups. |
Mkdn Qty YTD |
Year-to-date quantity of units on markdown. |
Clr Mkdn Qty YTD |
Year-to-date quantity of units on clearance markdown. |
Pro Mkdn Qty YTD |
Year-to-date quantity of units on promotion markdown. |
Pmt Mkdn Qty YTD |
Year-to-date quantity of units on permanent markdown. |
Mkup Qty YTD |
Year-to-date quantity of units on markup. |
Mkdn to Sales Amt YTD |
Year-to-date ratio of markdown amount as a fraction of gross sales amount. |
Pro Mkdn Amt LY LW |
Last week's value of promotion markdowns for last year. |
Mkdn Amt LY WTD |
Week-to-date value of markdowns for last year. |
Clr Mkdn Amt LY WTD |
Week-to-date value of clearance markdowns for last year. |
Pro Mkdn Amt LY WTD |
Week-to-date value of promotion markdowns for last year. |
Pmt Mkdn Amt LY WTD |
Week-to-date value of permanent markdowns for last year. |
Mkdn to Sales Amt LY WTD |
Week-to-date ratio of markdown amount as a fraction of gross sales amount for last year. |
Mkdn Amt LY MTD |
Month-to-date value of markdowns for last year. |
Clr Mkdn Amt LY MTD |
Month-to-date value of clearance markdowns for last year. |
Pro Mkdn Amt LY MTD |
Month-to-date value of promotion markdowns for last year. |
Pmt Mkdn Amt LY MTD |
Month-to-date value of permanent markdowns for last year. |
Mkdn to Sales Amt LY MTD |
Month-to-date ratio of markdown amount as a fraction of gross sales amount for last year. |
Mkdn Amt LY YTD |
Year-to-date value of markdowns for last year. |
Clr Mkdn Amt LY YTD |
Year-to-date value of clearance markdowns for last year. |
Pro Mkdn Amt LY YTD |
Year-to-date value of promotion markdowns for last year. |
Pmt Mkdn Amt LY YTD |
Year-to-date value of permanent markdowns for last year. |
Mkup Amt LY YTD |
Year-to-date value of markups for last year. |
Mkdn Qty LY YTD |
Year-to-date quantity of units on markdown for last year. |
Clr Mkdn Qty LY YTD |
Year-to-date quantity of units on clearance markdown for last year. |
Pro Mkdn Qty LY YTD |
Year-to-date quantity of units on promotion markdown for last year. |
Pmt Mkdn Qty LY YTD |
Year-to-date quantity of units on permanent markdown for last year. |
Mkup Qty LY YTD |
Year-to-date quantity of units on markup for last year. |
Mkdn to Sales Amt LY YTD |
Year-to-date ratio of markdown amount as a fraction of gross sales amount for last year. |
Mkdn Amt Var LW |
Markdown amount variance compared to last week. |
Clr Mkdn Amt Var LW |
Clearance markdown amount variance compared to last week. |
Pro Mkdn Amt Var LW |
Promotion markdown amount variance compared to last week. |
Pmt Mkdn Amt Var LW |
Permanent markdown amount variance compared to last week. |
Mkup Amt Var LW |
Markup amount variance compared to last week. |
Mkdn Qty Var LW |
Markdown quantity variance compared to last week. |
Clr Mkdn Qty Var LW |
Clearance markdown quantity variance compared to last week. |
Pro Mkdn Qty Var LW |
Promotion markdown quantity variance compared to last week. |
Pmt Mkdn Qty Var LW |
Permanent markdown quantity variance compared to last week. |
Mkup Qty Var LW |
Markup quantity variance compared to last week. |
Mkdn Amt Var LY |
Markdown amount variance compared to last year. |
Clr Mkdn Amt Var LY |
Clearance markdown amount variance compared to last year. |
Pro Mkdn Amt Var LY |
Promotion markdown amount variance compared to last year. |
Pmt Mkdn Amt Var LY |
Permanent markdown amount variance compared to last year. |
Mkup Amt Var LY |
Markup amount variance compared to last year. |
Mkdn Qty Var LY |
Markdown quantity variance compared to last year. |
Clr Mkdn Qty Var LY |
Clearance markdown quantity variance compared to last year. |
Pro Mkdn Qty Var LY |
Promotion markdown quantity variance compared to last year. |
Pmt Mkdn Qty Var LY |
Permanent markdown quantity variance compared to last year. |
Mkup Qty Var LY |
Markup quantity variance compared to last year. |
Pro Mkdn Amt LW Var LY |
Last week's promotion markdown amount variance compared to last year. |
Mkdn Amt WTD Var LY |
Week-to-date markdown amount variance compared to last year. |
Clr Mkdn Amt WTD Var LY |
Week-to-date clearance markdown amount variance compared to last year. |
Pro Mkdn Amt WTD Var LY |
Week-to-date promotion markdown amount variance compared to last year. |
Pmt Mkdn Amt WTD Var LY |
Week-to-date permanent markdown amount variance compared to last year. |
Mkup Amt WTD Var LY |
Week-to-date markup amount variance compared to last year. |
Mkdn Amt MTD Var LY |
Month-to-date markdown amount variance compared to last year. |
Clr Mkdn Amt MTD Var LY |
Month-to-date clearance markdown amount variance compared to last year. |
Pro Mkdn Amt MTD Var LY |
Month-to-date promotion markdown amount variance compared to last year. |
Pmt Mkdn Amt MTD Var LY |
Month-to-date permanent markdown amount variance compared to last year. |
Mkup Amt MTD Var LY |
Month-to-date markup amount variance compared to last year. |
Mkdn Qty MTD Var LY |
Month-to-date markdown quantity variance compared to last year. |
Clr Mkdn Qty MTD Var LY |
Month-to-date clearance markdown quantity variance compared to last year. |
Pro Mkdn Qty MTD Var LY |
Month-to-date promotion markdown quantity variance compared to last year. |
Pmt Mkdn Qty MTD Var LY |
Month-to-date permanent markdown quantity variance compared to last year. |
Mkup Qty MTD Var LY |
Month-to-date markup quantity variance compared to last year. |
Mkdn Amt YTD Var LY |
Year-to-date markdown amount variance compared to last year. |
Clr Mkdn Amt YTD Var LY |
Year-to-date clearance markdown amount variance compared to last year. |
Pro Mkdn Amt YTD Var LY |
Year-to-date promotion markdown amount variance compared to last year. |
Pmt Mkdn Amt YTD Var LY |
Year-to-date permanent markdown amount variance compared to last year. |
Mkup Amt YTD Var LY |
Year-to-date markup amount variance compared to last year. |
Mkdn Qty YTD Var LY |
Year-to-date markdown quantity variance compared to last year. |
Clr Mkdn Qty YTD Var LY |
Year-to-date clearance markdown quantity variance compared to last year. |
Pro Mkdn Qty YTD Var LY |
Year-to-date promotion markdown quantity variance compared to last year. |
Pmt Mkdn Qty YTD Var LY |
Year-to-date permanent markdown quantity variance compared to last year. |
Mkup Qty YTD Var LY |
Year-to-date markup quantity variance compared to last year. |
Comp Mkdn Amt |
Amount of the clearance, promotion, and permanent markdown in comparable stores. This is the difference between the original retail and the selling price. |
Comp Clr Mkdn Amt |
Value of clearance markdowns in comparable stores. |
Comp Pro Mkdn Amt |
Value of promotion markdowns in comparable stores. |
Comp Pmt Mkdn Amt |
Value of permanent markdowns in comparable stores. |
Comp Mkup Amt |
Value of markups in comparable stores. |
Comp Mkdn Qty |
Quantity of units on markdown in comparable stores. |
Comp Clr Mkdn Qty |
Quantity of units on clearance markdown in comparable stores. |
Comp Pro Mkdn Qty |
Quantity of units on promotion markdown in comparable stores. |
Comp Pmt Mkdn Qty |
Quantity of units on permanent markdown in comparable stores. |
Comp Mkup Qty |
Quantity of units on markup in comparable stores. |
Comp Mkdn Amt LY |
Last year's value of markdowns in comparable stores. |
Comp Clr Mkdn Amt LY |
Last year's value of clearance markdowns in comparable stores. |
Comp Pro Mkdn Amt LY |
Last year's value of promotion markdowns in comparable stores. |
Comp Pmt Mkdn Amt LY |
Last year's value of permanent markdowns in comparable stores. |
Comp Mkup Amt LY |
Last year's value of markups in comparable stores. |
Comp Mkdn Qty LY |
Last year's quantity of units on markdown in comparable stores. |
Comp Clr Mkdn Qty LY |
Last year's quantity of units on clearance markdown in comparable stores. |
Comp Pro Mkdn Qty LY |
Last year's quantity of units on promotion markdown in comparable stores. |
Comp Pmt Mkdn Qty LY |
Last year's quantity of units on permanent markdown in comparable stores. |
Comp Mkup Qty LY |
Last year's quantity of units on markup in comparable stores. |
Comp Mkdn to Sales Amt LY |
Last year's ratio of markdown amount as a fraction of gross sales amount in comparable stores. |
Comp Mkdn Amt Var LY |
Markdown amount variance compared to last year for comparable stores. |
Comp Clr Mkdn Amt Var LY |
Clearance markdown amount variance compared to last year for comparable stores. |
Comp Pro Mkdn Amt Var LY |
Promotion markdown amount variance compared to last year for comparable stores. |
Comp Pmt Mkdn Amt Var LY |
Permanent markdown amount variance compared to last year for comparable stores. |
Comp Mkup Amt Var LY |
Markup amount variance compared to last year for comparable stores. |
Comp Mkdn Qty Var LY |
Markdown quantity variance compared to last year for comparable stores. |
Comp Clr Mkdn Qty Var LY |
Clearance markdown quantity variance compared to last year for comparable stores. |
Comp Pro Mkdn Qty Var LY |
Promotion markdown quantity variance compared to last year for comparable stores. |
Comp Pmt Mkdn Qty Var LY |
Permanent markdown quantity variance compared to last year for comparable stores. |
Comp Mkup Qty Var LY |
Markup quantity variance compared to last year for comparable stores. |
Comp Mkdn Amt MTD |
Month-to-date value of markdowns in comparable stores. |
Comp Clr Mkdn Amt MTD |
Month-to-date value of clearance markdowns in comparable stores. |
Comp Pro Mkdn Amt MTD |
Month-to-date value of promotion markdowns in comparable stores. |
Comp Pmt Mkdn Amt MTD |
Month-to-date value of permanent markdowns in comparable stores. |
Comp Mkup Amt MTD |
Month-to-date value of markups in comparable stores. |
Comp Mkdn Qty MTD |
Month-to-date quantity of units on markdown in comparable stores. |
Comp Clr Mkdn Qty MTD |
Month-to-date quantity of units on clearance markdown in comparable stores. |
Comp Pro Mkdn Qty MTD |
Month-to-date quantity of units on promotion markdown in comparable stores. |
Comp Pmt Mkdn Qty MTD |
Month-to-date quantity of units on permanent markdown in comparable stores. |
Comp Mkup Qty MTD |
Month-to-date quantity of units on markup in comparable stores. |
Comp Mkdn Amt LY MTD |
Month-to-date value of markdowns in comparable stores for last year. |
Comp Mkdn Amt MTD Var LY |
Month-to-date markdown amount variance compared to last year for comparable stores. |
Comp Mkdn Amt YTD |
Year-to-date value of markdowns in comparable stores. |
Comp Clr Mkdn Amt YTD |
Year-to-date value of clearance markdowns in comparable stores. |
Comp Pro Mkdn Amt YTD |
Year-to-date value of promotion markdowns in comparable stores. |
Comp Pmt Mkdn Amt YTD |
Year-to-date value of permanent markdowns in comparable stores. |
Comp Mkup Amt YTD |
Year-to-date value of markups in comparable stores. |
Comp Mkdn Qty YTD |
Year-to-date quantity of units on markdown in comparable stores. |
Comp Clr Mkdn Qty YTD |
Year-to-date quantity of units on clearance markdown in comparable stores. |
Comp Pro Mkdn Qty YTD |
Year-to-date quantity of units on promotion markdown in comparable stores. |
Comp Pmt Mkdn Qty YTD |
Year-to-date quantity of units on permanent markdown in comparable stores. |
Comp Mkup Qty YTD |
Year-to-date quantity of units on markup in comparable stores. |
Gross Markdown % |
The actual percentage of markdowns taken against an item or category. |
Table C-3 Forecast Metrics
Metric | Definition |
---|---|
Fcst Sales Qty |
Number of sales units forecast for the given time period. |
Fcst Sales Qty LW |
Last week's forecast quantity of sales units for the given time period. |
Fcst Sales Qty MTD |
Month-to-date forecast quantity of sales units. |
Fcst Sales Qty YTD |
Year-to-date forecast quantity of sales units. |
Fcst Sales Qty Var |
Gross sales quantity variance compared to the forecast quantity. |
Fcst Sales Qty LW Var |
Last week's gross sales quantity variance compared to the forecast quantity. |
Fcst Sales Qty MTD Var |
Month-to-date gross sales quantity variance compared to the forecast quantity. |
Fcst Sales Qty YTD Var |
Year-to-date gross sales quantity variance compared to the forecast quantity. |
Fcst Sales Qty NW |
Next week's forecast quantity of sales units for the given time period. |
Table C-4 Inventory Receipts Metrics
Metric | Definition |
---|---|
Receipts Qty |
Quantity of inventory units received. |
Receipts Cost |
Cost value of inventory units received. |
Receipts Retail |
Retail value of inventory units received. |
Receipts Qty LW |
Last week's quantity of inventory units received. |
Receipts Cost LW |
Last week's cost value of inventory units received. |
Receipts Retail LW |
Last week's retail value of inventory units received. |
Receipts Qty LY |
Last year's quantity of inventory units received. |
Receipts Cost LY |
Last year's cost value of inventory units received. |
Receipts Retail LY |
Last year's retail value of inventory units received. |
Receipts Qty WTD |
Week-to-date quantity of inventory units received. |
Receipts Cost WTD |
Week-to-date cost value of inventory units received. |
Receipts Retail WTD |
Week-to-date retail value of inventory units received. |
Receipts Qty MTD |
Month-to-date quantity of inventory units received. |
Receipts Cost MTD |
Month-to-date cost value of inventory units received. |
Receipts Retail MTD |
Month-to-date retail value of inventory units received. |
Receipts Qty YTD |
Year-to-date quantity of inventory units received. |
Receipts Cost YTD |
Year-to-date cost value of inventory units received. |
Receipts Retail YTD |
Year-to-date retail value of inventory units received. |
Receipts Qty LY LW |
Last week's quantity of inventory units received for last year. |
Receipts Cost LY LW |
Last week's cost value of inventory units received for last year. |
Receipts Retail LY LW |
Last week's retail value of inventory units received for last year. |
Receipts Qty LY WTD |
Week-to-date quantity of inventory units received for last year. |
Receipts Cost LY WTD |
Week-to-date cost value of inventory units received for last year. |
Receipts Retail LY WTD |
Week-to-date retail value of inventory units received for last year. |
Receipts Qty LY MTD |
Month-to-date quantity of inventory units received for last year. |
Receipts Cost LY MTD |
Month-to-date cost value of inventory units received for last year. |
Receipts Retail LY MTD |
Month-to-date retail value of inventory units received for last year. |
Receipts Qty LY YTD |
Year-to-date quantity of inventory units received for last year. |
Receipts Cost LY YTD |
Year-to-date cost value of inventory units received for last year. |
Receipts Retail LY YTD |
Year-to-date retail value of inventory units received for last year. |
Receipts Qty Var LW |
Inventory receipts quantity variance compared to last week. |
Receipts Cost Var LW |
Inventory receipts cost value variance compared to last week. |
Receipts Retail Var LW |
Inventory receipts retail value variance compared to last week. |
Receipts Qty Var LY |
Inventory receipts quantity variance compared to last year. |
Receipts Cost Var LY |
Inventory receipts cost value variance compared to last year. |
Receipts Retail Var LY |
Inventory receipts retail value variance compared to last year. |
Receipts Qty WTD Var LY |
Week-to-date inventory receipts quantity variance compared to last year. |
Receipts Cost WTD Var LY |
Week-to-date inventory receipts cost value variance compared to last year. |
Receipts Retail WTD Var LY |
Week-to-date inventory receipts retail value variance compared to last year. |
Receipts Qty MTD Var LY |
Month-to-date inventory receipts quantity variance compared to last year. |
Receipts Cost MTD Var LY |
Month-to-date inventory receipts cost value variance compared to last year. |
Receipts Retail MTD Var LY |
Month-to-date inventory receipts retail value variance compared to last year. |
Receipts Qty YTD Var LY |
Year-to-date inventory receipts quantity variance compared to last year. |
Receipts Cost YTD Var LY |
Year-to-date inventory receipts cost value variance compared to last year. |
Receipts Retail YTD Var LY |
Year-to-date inventory receipts retail value variance compared to last year. |
Comp Receipts Qty |
Quantity of inventory units received in comparable stores. |
Comp Receipts Cost |
Cost value of inventory units received in comparable stores. |
Comp Receipts Retail |
Retail value of inventory units received in comparable stores. |
Comp Receipts Qty LY |
Last year's quantity of inventory units received in comparable stores. |
Comp Receipts Cost LY |
Last year's cost value of inventory units received in comparable stores. |
Comp Receipts Retail LY |
Last year's retail value of inventory units received in comparable stores. |
Comp Receipts Qty Var LY |
Inventory receipts quantity variance compared to last year for comparable stores. |
Comp Receipts Cost Var LY |
Inventory receipts cost value variance compared to last year for comparable stores. |
Comp Receipts Retail Var LY |
Inventory receipts retail value variance compared to last year for comparable stores. |
IMU % |
The initial markup is the average markup required on all products to cover the cost of all items, incidental expenses, and to obtain a reasonable profit. |
Table C-5 Sales Metrics
Metric | Definition |
---|---|
Gross Sales Amt |
Retail value of units sold, calculated by adding sale invoices. It includes VAT but excludes discounts. |
Return Amt |
Retail value of units returned. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
Net Sales Amt |
Sales amount excluding returns. It indicates the actual money amount received from sales. |
Net Clr Sales Amt |
Gross sales amount from clearance stock, excluding returns. |
Net Pro Sales Amt |
Difference between the gross sales amount and returns amount for promotion priced items. |
Net Reg Sales Amt |
Difference between gross sales amount and returns amount for regularly priced items. |
Gross Sales Qty |
Total units of merchandise sold. |
Return Qty |
Number of units returned. |
Net Sales Qty |
Difference between gross sales quantity and returns quantity. |
Net Clr Sales Qty |
Difference between gross sales quantity and returns quantity for clearance priced items |
Net Pro Sales Qty |
Difference between gross sales quantity and returns quantity for promotion priced items. |
Net Reg Sales Qty |
Difference between gross sales quantity and returns quantity for regularly priced items. |
Gross Profit |
Difference between sales revenue and the cost of units sold. It indicates the retailer's ability to mark up merchandise for sale. |
Return Profit |
Difference between the returns amount and the cost of units returned. The cost of units returned is the product of return quantity times average cost. It indicates the profit lost because of returns. |
Net Profit |
Difference between profit earned on gross sales minus returns profit. |
Net Clr Profit |
Difference between gross profit and returns profit for clearance priced items. |
Net Pro Profit |
Difference between gross profit and returns profit for promotion priced items. |
Net Reg Profit |
Difference between gross profit and returns profit for regularly priced items. |
Net Emp Disc |
Difference between gross employee discount amount and returns employee discount amount. |
Gross Tax |
Tax applied on total sales revenue. Expenses are not deducted when calculating the tax amount. |
Return Tax |
Taxes that have been accounted on returned merchandise. |
Net Tax |
Taxes payable by a company at the end of fiscal year. It is gross tax less returns tax. |
Gross Manual Mkdn Amt |
Difference between the original retail, after official price adjustments, and the price that was actually charged to the customer. |
Return Manual Mkdn Amt |
Difference between the original retail, after official price adjustments, and the price that was actually returned to the customer. |
Net Manual Mkdn Amt |
Difference between gross manual markdown amount and return manual markdown amount. |
Gross Manual Mkup Amt |
Difference between the price that was actually charged to the customer and the original retail after official price adjustments. These generally are indicators of cashier mistakes or system discrepancies. |
Return Manual Mkup Amt |
Difference between the price that was actually returned to the customer and the original retail after official price adjustments. |
Net Manual Mkup Amt |
Difference between gross manual markup amount and return manual markup amount. This is an indicator of discrepancies during manual markup sales and returns. |
Sales Enter Item Count |
Merchandise count that was manually entered by cashiers. |
Return Enter Item Count |
Returned merchandise count that was manually entered by cashiers. |
Sales Scan Item Count |
Sold merchandise count that was electronically scanned by cashiers. |
Return Scan Item Count |
Returned merchandise count that was electronically scanned by cashiers. |
Gross Profit to Sales Amt |
Ratio of profit achieved on total sales. The ratio reflects a company's ability to balance its costs with sales. It is a key performance indicator of a company's efficiency and performance. |
Net Profit to Sales Amt |
Ratio of net profit to net sales. It indicates the bottom-line profit a company keeps from money generated by sales. This is a key performance indicator of a company's profitability for investors. |
Avg Net Retail |
Average retail price of sold items. This is calculated by deducting any taxes or expenses. |
Gross Sales Amt LW |
Last week's value of units sold. |
Return Amt LW |
Last week's value of units returned. |
Net Sales Amt LW |
Last week's value of net sales. |
Net Clr Sales Amt LW |
Last week's value of net clearance sales. |
Net Pro Sales Amt LW |
Last week's value of net promotion sales. |
Net Reg Sales Amt LW |
Last week's value of net regular sales. |
Gross Sales Qty LW |
Last week's quantity of units sold. |
Return Qty LW |
Last week's quantity of units returned. |
Net Sales Qty LW |
Last week's quantity of net sales. |
Net Clr Sales Qty LW |
Last week's quantity of net clearance sales. |
Net Pro Sales Qty LW |
Last week's quantity of net promotion sales. |
Net Reg Sales Qty LW |
Last week's quantity of net regular sales. |
Gross Profit LW |
Last week's difference between sales revenue and the cost of units sold. |
Return Profit LW |
Last week's difference between the retail value of returns and the cost of units returned. |
Net Profit LW |
Last week's bottom line profit after accounting for returns. |
Net Clr Profit LW |
Last week's bottom line profit for clearance items after accounting for returns. |
Net Pro Profit LW |
Last week's bottom line profit for promotion items after accounting for returns. |
Net Reg Profit LW |
Last week's bottom line profit for regular items after accounting for returns. |
Net Emp Disc LW |
Last week's employee discount amount applied to sales after accounting for returns. |
Gross Tax LW |
Last week's tax applied on total sales revenue. |
Return Tax LW |
Last week's tax applied on total return value. |
Net Tax LW |
Last week's total taxes applied on sales revenue after accounting for returns. |
Sales Enter Item Count LW |
Last week's merchandise count that was manually entered by cashiers. |
Return Enter Item Count LW |
Last week's returned merchandise count that was manually entered by cashiers. |
Sales Scan Item Count LW |
Last week's sold merchandise count that was electronically scanned by cashiers. |
Return Scan Item Count LW |
Last week's returned merchandise count that was electronically scanned by cashiers. |
Gross Profit to Sales Amt LW |
Last week's ratio of profit achieved on total sales. |
Net Profit to Sales Amt LW |
Last week's ratio of net profit to net sales. |
Avg Net Retail LW |
Last week's average retail price of sold items. |
Gross Sales Amt LY |
Last year's value of units sold. |
Return Amt LY |
Last year's value of units returned. |
Net Sales Amt LY |
Last year's value of net sales. |
Net Clr Sales Amt LY |
Last year's value of net clearance sales. |
Net Pro Sales Amt LY |
Last year's value of net promotion sales. |
Net Reg Sales Amt LY |
Last year's value of net regular sales. |
Gross Sales Qty LY |
Last year's quantity of units sold. |
Return Qty LY |
Last year's quantity of units returned. |
Net Sales Qty LY |
Last year's quantity of net sales. |
Net Clr Sales Qty LY |
Last year's quantity of net clearance sales. |
Net Pro Sales Qty LY |
Last year's quantity of net promotion sales. |
Net Reg Sales Qty LY |
Last year's quantity of net regular sales. |
Gross Profit LY |
Last year's difference between sales revenue and the cost of units sold. |
Return Profit LY |
Last year's difference between the retail value of returns and the cost of units returned. |
Net Profit LY |
Last year's bottom line profit after accounting for returns. |
Net Clr Profit LY |
Last year's bottom line profit for clearance items after accounting for returns. |
Net Pro Profit LY |
Last year's bottom line profit for promotion items after accounting for returns. |
Net Reg Profit LY |
Last year's bottom line profit for regular items after accounting for returns. |
Net Emp Disc LY |
Last year's employee discount amount applied to sales after accounting for returns. |
Gross Tax LY |
Last year's tax applied on total sales revenue. |
Return Tax LY |
Last year's tax applied on total return value. |
Net Tax LY |
Last year's total taxes applied on sales revenue after accounting for returns. |
Gross Manual Mkdn Amt LY |
Last year's difference between the original retail, after official price adjustments, and the price that was actually charged to the customer. |
Return Manual Mkdn Amt LY |
Last year's difference between the original retail, after official price adjustments, and the price that was actually returned to the customer. |
Net Manual Mkdn Amt LY |
Last year's difference between gross manual markdown amount and return manual markdown amount. |
Gross Manual Mkup Amt LY |
Last year's difference between the price that was actually charged to the customer and the original retail after official price adjustments. |
Return Manual Mkup Amt LY |
Last year's difference between the price that was actually returned to the customer and the original retail after official price adjustments. |
Net Manual Mkup Amt LY |
Last year's difference between gross manual markup amount and return manual markup amount. |
Sales Enter Item Count LY |
Last year's merchandise count that was manually entered by cashiers. |
Return Enter Item Count LY |
Last year's returned merchandise count that was manually entered by cashiers. |
Sales Scan Item Count LY |
Last year's sold merchandise count that was electronically scanned by cashiers. |
Return Scan Item Count LY |
Last year's returned merchandise count that was electronically scanned by cashiers. |
Gross Profit to Sales Amt LY |
Last year's ratio of profit achieved on total sales. |
Net Profit to Sales Amt LY |
Last year's ratio of net profit to net sales. |
Avg Net Retail LY |
Last year's average retail price of sold items. |
Gross Sales Amt WTD |
Week-to-date value of units sold. |
Return Amt WTD |
Week-to-date value of units returned. |
Net Sales Amt WTD |
Week-to-date value of net sales. |
Net Clr Sales Amt WTD |
Week-to-date value of net clearance sales. |
Net Pro Sales Amt WTD |
Week-to-date value of net promotion sales. |
Net Reg Sales Amt WTD |
Week-to-date value of net regular sales. |
Gross Sales Qty WTD |
Week-to-date quantity of units sold. |
Return Qty WTD |
Week-to-date quantity of units returned. |
Net Sales Qty WTD |
Week-to-date quantity of net sales. |
Net Clr Sales Qty WTD |
Week-to-date quantity of net clearance sales. |
Net Pro Sales Qty WTD |
Week-to-date quantity of net promotion sales. |
Net Reg Sales Qty WTD |
Week-to-date quantity of net regular sales. |
Gross Profit WTD |
Week-to-date difference between sales revenue and the cost of units sold. |
Return Profit WTD |
Week-to-date difference between the retail value of returns and the cost of units returned. |
Net Profit WTD |
Week-to-date bottom line profit after accounting for returns. |
Net Clr Profit WTD |
Week-to-date bottom line profit for clearance items after accounting for returns. |
Net Pro Profit WTD |
Week-to-date bottom line profit for promotion items after accounting for returns. |
Net Reg Profit WTD |
Week-to-date bottom line profit for regular items after accounting for returns. |
Net Emp Disc WTD |
Week-to-date employee discount amount applied to sales after accounting for returns. |
Gross Tax WTD |
Week-to-date tax applied on total sales revenue. |
Return Tax WTD |
Week-to-date tax applied on total return value. |
Net Tax WTD |
Week-to-date total taxes applied on sales revenue after accounting for returns. |
Gross Manual Mkdn Amt WTD |
Week-to-date difference between the original retail, after official price adjustments, and the price that was actually charged to the customer. |
Return Manual Mkdn Amt WTD |
Week-to-date difference between the original retail, after official price adjustments, and the price that was actually returned to the customer. |
Net Manual Mkdn Amt WTD |
Week-to-date difference between gross manual markdown amount and return manual markdown amount. |
Gross Manual Mkup Amt WTD |
Week-to-date difference between the price that was actually charged to the customer and the original retail after official price adjustments. |
Return Manual Mkup Amt WTD |
Week-to-date difference between the price that was actually returned to the customer and the original retail after official price adjustments. |
Net Manual Mkup Amt WTD |
Week-to-date difference between gross manual markup amount and return manual markup amount. |
Sales Enter Item Count WTD |
Week-to-date merchandise count that was manually entered by cashiers. |
Return Enter Item Count WTD |
Week-to-date returned merchandise count that was manually entered by cashiers. |
Sales Scan Item Count WTD |
Week-to-date sold merchandise count that was electronically scanned by cashiers. |
Return Scan Item Count WTD |
Week-to-date returned merchandise count that was electronically scanned by cashiers. |
Gross Profit to Sales Amt WTD |
Week-to-date ratio of profit achieved on total sales. |
Net Profit to Sales Amt WTD |
Week-to-date ratio of net profit to net sales. |
Avg Net Retail WTD |
Week-to-date average retail price of sold items. |
Gross Sales Amt MTD |
Month-to-date value of units sold. |
Return Amt MTD |
Month-to-date value of units returned. |
Net Sales Amt MTD |
Month-to-date value of net sales. |
Net Clr Sales Amt MTD |
Month-to-date value of net clearance sales. |
Net Pro Sales Amt MTD |
Month-to-date value of net promotion sales. |
Net Reg Sales Amt MTD |
Month-to-date value of net regular sales. |
Gross Sales Qty MTD |
Month-to-date quantity of units sold. |
Return Qty MTD |
Month-to-date quantity of units returned. |
Net Sales Qty MTD |
Month-to-date quantity of net sales. |
Net Clr Sales Qty MTD |
Month-to-date quantity of net clearance sales. |
Net Pro Sales Qty MTD |
Month-to-date quantity of net promotion sales. |
Net Reg Sales Qty MTD |
Month-to-date quantity of net regular sales. |
Gross Profit MTD |
Month-to-date difference between sales revenue and the cost of units sold. |
Return Profit MTD |
Month-to-date difference between the retail value of returns and the cost of units returned. |
Net Profit MTD |
Month-to-date bottom line profit after accounting for returns. |
Net Clr Profit MTD |
Month-to-date bottom line profit for clearance items after accounting for returns. |
Net Pro Profit MTD |
Month-to-date bottom line profit for promotion items after accounting for returns. |
Net Reg Profit MTD |
Month-to-date bottom line profit for regular items after accounting for returns. |
Net Emp Disc MTD |
Month-to-date employee discount amount applied to sales after accounting for returns. |
Gross Tax MTD |
Month-to-date tax applied on total sales revenue. |
Return Tax MTD |
Month-to-date tax applied on total return value. |
Net Tax MTD |
Month-to-date total taxes applied on sales revenue after accounting for returns. |
Gross Manual Mkdn Amt MTD |
Month-to-date difference between the original retail, after official price adjustments, and the price that was actually charged to the customer. |
Return Manual Mkdn Amt MTD |
Month-to-date difference between the original retail, after official price adjustments, and the price that was actually returned to the customer. |
Net Manual Mkdn Amt MTD |
Month-to-date difference between gross manual markdown amount and return manual markdown amount. |
Gross Manual Mkup Amt MTD |
Month-to-date difference between the price that was actually charged to the customer and the original retail after official price adjustments. |
Return Manual Mkup Amt MTD |
Month-to-date difference between the price that was actually returned to the customer and the original retail after official price adjustments. |
Net Manual Mkup Amt MTD |
Month-to-date difference between gross manual markup amount and return manual markup amount. |
Sales Enter Item Count MTD |
Month-to-date merchandise count that was manually entered by cashiers. |
Return Enter Item Count MTD |
Month-to-date returned merchandise count that was manually entered by cashiers. |
Sales Scan Item Count MTD |
Month-to-date sold merchandise count that was electronically scanned by cashiers. |
Return Scan Item Count MTD |
Month-to-date returned merchandise count that was electronically scanned by cashiers. |
Gross Profit to Sales Amt MTD |
Month-to-date ratio of profit achieved on total sales. |
Net Profit to Sales Amt MTD |
Month-to-date ratio of net profit to net sales. |
Avg Net Retail MTD |
Month-to-date average retail price of sold items. |
Gross Sales Amt YTD |
Year-to-date value of units sold. |
Return Amt YTD |
Year-to-date value of units returned. |
Net Sales Amt YTD |
Year-to-date value of net sales. |
Net Clr Sales Amt YTD |
Year-to-date value of net clearance sales. |
Net Pro Sales Amt YTD |
Year-to-date value of net promotion sales. |
Net Reg Sales Amt YTD |
Year-to-date value of net regular sales. |
Gross Sales Qty YTD |
Year-to-date quantity of units sold. |
Return Qty YTD |
Year-to-date quantity of units returned. |
Net Sales Qty YTD |
Year-to-date quantity of net sales. |
Net Clr Sales Qty YTD |
Year-to-date quantity of net clearance sales. |
Net Pro Sales Qty YTD |
Year-to-date quantity of net promotion sales. |
Net Reg Sales Qty YTD |
Year-to-date quantity of net regular sales. |
Gross Profit YTD |
Year-to-date difference between sales revenue and the cost of units sold. |
Return Profit YTD |
Year-to-date difference between the retail value of returns and the cost of units returned. |
Net Profit YTD |
Year-to-date bottom line profit after accounting for returns. |
Net Clr Profit YTD |
Year-to-date bottom line profit for clearance items after accounting for returns. |
Net Pro Profit YTD |
Year-to-date bottom line profit for promotion items after accounting for returns. |
Net Reg Profit YTD |
Year-to-date bottom line profit for regular items after accounting for returns. |
Net Emp Disc YTD |
Year-to-date employee discount amount applied to sales after accounting for returns. |
Gross Tax YTD |
Year-to-date tax applied on total sales revenue. |
Return Tax YTD |
Year-to-date tax applied on total return value. |
Net Tax YTD |
Year-to-date total taxes applied on sales revenue after accounting for returns. |
Gross Manual Mkdn Amt YTD |
Year-to-date difference between the original retail, after official price adjustments, and the price that was actually charged to the customer. |
Return Manual Mkdn Amt YTD |
Year-to-date difference between the original retail, after official price adjustments, and the price that was actually returned to the customer. |
Net Manual Mkdn Amt YTD |
Year-to-date difference between gross manual markdown amount and return manual markdown amount. |
Gross Manual Mkup Amt YTD |
Year-to-date difference between the price that was actually charged to the customer and the original retail after official price adjustments. |
Return Manual Mkup Amt YTD |
Year-to-date difference between the price that was actually returned to the customer and the original retail after official price adjustments. |
Net Manual Mkup Amt YTD |
Year-to-date difference between gross manual markup amount and return manual markup amount. |
Sales Enter Item Count YTD |
Year-to-date merchandise count that was manually entered by cashiers. |
Return Enter Item Count YTD |
Year-to-date returned merchandise count that was manually entered by cashiers. |
Sales Scan Item Count YTD |
Year-to-date sold merchandise count that was electronically scanned by cashiers. |
Return Scan Item Count YTD |
Year-to-date returned merchandise count that was electronically scanned by cashiers. |
Gross Profit to Sales Amt YTD |
Year-to-date ratio of profit achieved on total sales. |
Net Profit to Sales Amt YTD |
Year-to-date ratio of net profit to net sales. |
Avg Net Retail YTD |
Year-to-date average retail price of sold items. |
Net Sales Amt LY LW |
Last week's value of net sales for last year. |
Net Clr Sales Amt LY LW |
Last week's value of net clearance sales for last year. |
Net Pro Sales Amt LY LW |
Last week's value of net promotion sales for last year. |
Net Reg Sales Amt LY LW |
Last week's value of net regular sales for last year. |
Gross Sales Qty LY LW |
Last week's quantity of units sold for last year. |
Return Qty LY LW |
Last week's quantity of units returned for last year. |
Net Sales Qty LY LW |
Last week's quantity of net sales for last year. |
Net Clr Sales Qty LY LW |
Last week's quantity of net clearance sales for last year. |
Net Pro Sales Qty LY LW |
Last week's quantity of net promotion sales for last year. |
Net Reg Sales Qty LY LW |
Last week's quantity of net regular sales for last year. |
Gross Profit LY LW |
Last week's difference between sales revenue and the cost of units sold for last year. |
Return Profit LY LW |
Last week's difference between the retail value of returns and the cost of units returned for last year. |
Net Profit LY LW |
Last week's bottom line profit after accounting for returns for last year. |
Gross Sales Amt LY WTD |
Week-to-date value of units sold for last year. |
Return Amt LY WTD |
Week-to-date value of units returned for last year. |
Net Sales Amt LY WTD |
Week-to-date value of net sales for last year. |
Net Clr Sales Amt LY WTD |
Week-to-date value of net clearance sales for last year. |
Net Pro Sales Amt LY WTD |
Week-to-date value of net promotion sales for last year. |
Net Reg Sales Amt LY WTD |
Week-to-date value of net regular sales for last year. |
Gross Sales Qty LY WTD |
Week-to-date quantity of units sold for last year. |
Return Qty LY WTD |
Week-to-date quantity of units returned for last year. |
Net Sales Qty LY WTD |
Week-to-date quantity of net sales for last year. |
Net Clr Sales Qty LY WTD |
Week-to-date quantity of net clearance sales for last year. |
Net Pro Sales Qty LY WTD |
Week-to-date quantity of net promotion sales for last year. |
Net Reg Sales Qty LY WTD |
Week-to-date quantity of net regular sales for last year. |
Gross Profit LY WTD |
Week-to-date difference between sales revenue and the cost of units sold for last year. |
Return Profit LY WTD |
Week-to-date difference between the retail value of returns and the cost of units returned for last year. |
Net Profit LY WTD |
Week-to-date bottom line profit after accounting for returns for last year. |
Net Pro Profit LY WTD |
Week-to-date bottom line profit for promotion items after accounting for returns for last year. |
Net Sales Amt LY MTD |
Month-to-date value of net sales for last year. |
Net Sales Qty LY MTD |
Month-to-date quantity of net sales for last year. |
Net Profit LY MTD |
Month-to-date bottom line profit after accounting for returns for last year. |
Net Pro Profit LY MTD |
Month-to-date bottom line profit for promotion items after accounting for returns for last year. |
Avg Net Retail LY MTD |
Month-to-date average retail price of sold items for last year. |
Net Sales Amt LY YTD |
Year-to-date value of net sales for last year. |
Net Sales Qty LY YTD |
Year-to-date quantity of net sales for last year. |
Net Profit LY YTD |
Year-to-date bottom line profit after accounting for returns for last year. |
Net Pro Profit LY YTD |
Year-to-date bottom line profit for promotion items after accounting for returns for last year. |
Avg Net Retail LY YTD |
Year-to-date average retail price of sold items for last year. |
Gross Sales Amt Var LW |
Gross sales amount variance compared to last week. |
Return Amt Var LW |
Return amount variance compared to last week. |
Net Sales Amt Var LW |
Net sales amount variance compared to last week. |
Net Clr Sales Amt Var LW |
Net clearance sales amount variance compared to last week. |
Net Pro Sales Amt Var LW |
Net promotion sales amount variance compared to last week. |
Net Reg Sales Amt Var LW |
Net regular sales amount variance compared to last week. |
Gross Sales Qty Var LW |
Gross sales quantity variance compared to last week. |
Return Qty Var LW |
Return quantity variance compared to last week. |
Net Sales Qty Var LW |
Net sales quantity variance compared to last week. |
Net Clr Sales Qty Var LW |
Net clearance sales quantity variance compared to last week. |
Net Pro Sales Qty Var LW |
Net promotion sales quantity variance compared to last week. |
Net Reg Sales Qty Var LW |
Net regular sales quantity variance compared to last week. |
Gross Profit Var LW |
Gross profit variance compared to last week. |
Return Profit Var LW |
Return profit variance compared to last week. |
Net Profit Var LW |
Net profit variance compared to last week. |
Net Clr Profit Var LW |
Net clearance profit variance compared to last week. |
Net Pro Profit Var LW |
Net promotion profit variance compared to last week. |
Net Reg Profit Var LW |
Net regular profit variance compared to last week. |
Net Emp Disc Var LW |
Net employee discount variance compared to last week. |
Gross Tax Var LW |
Gross tax variance compared to last week. |
Return Tax Var LW |
Return tax variance compared to last week. |
Net Tax Var LW |
Net tax variance compared to last week. |
Gross Sales Amt Var LY |
Gross sales amount variance compared to last year. |
Return Amt Var LY |
Return Amount variance compared to last year. |
Net Sales Amt Var LY |
Net sales amount variance compared to last year. |
Gross Sales Qty Var LY |
Gross sales quantity variance compared to last year. |
Return Qty Var LY |
Return quantity variance compared to last year. |
Net Sales Qty Var LY |
Net sales quantity variance compared to last year. |
Net Profit Var LY |
Net profit variance compared to last year. |
Net Pro Profit Var LY |
Net promotion profit variance compared to last year. |
Net Pro Sales Amt LW Var LY |
Last week's net promotion sales amount variance compared to last year. |
Gross Sales Qty LW Var LY |
Last week's gross sales quantity variance compared to last year. |
Net Pro Profit LW Var LY |
Last week's net promotion profit variance compared to last year. |
Net Sales Amt WTD Var LY |
Week-to-date net sales amount variance compared to last year. |
Net Clr Sales Amt WTD Var LY |
Week-to-date net clearance sales amount variance compared to last year. |
Net Pro Sales Amt WTD Var LY |
Week-to-date net promotion sales amount variance compared to last year. |
Net Reg Sales Amt WTD Var LY |
Week-to-date net regular sales amount variance compared to last year. |
Gross Sales Qty WTD Var LY |
Week-to-date gross sales quantity variance compared to last year. |
Net Sales Qty WTD Var LY |
Week-to-date net sales quantity variance compared to last year. |
Net Clr Sales Qty WTD Var LY |
Week-to-date net clearance sales quantity variance compared to last year. |
Net Pro Sales Qty WTD Var LY |
Week-to-date net promotion sales quantity variance compared to last year. |
Net Reg Sales Qty WTD Var LY |
Week-to-date net regular sales quantity variance compared to last year. |
Net Pro Profit WTD Var LY |
Week-to-date net promotion profit variance compared to last year. |
Net Sales Amt MTD Var LY |
Month-to-date net sales amount variance compared to last year. |
Net Clr Sales Amt MTD Var LY |
Month-to-date net clearance sales amount variance compared to last year. |
Net Pro Sales Amt MTD Var LY |
Month-to-date net promotion sales amount variance compared to last year. |
Net Reg Sales Amt MTD Var LY |
Month-to-date net regular sales amount variance compared to last year. |
Net Sales Qty MTD Var LY |
Month-to-date net sales quantity variance compared to last year. |
Net Clr Sales Qty MTD Var LY |
Month-to-date net clearance sales quantity variance compared to last year. |
Net Pro Sales Qty MTD Var LY |
Month-to-date net promotion sales quantity variance compared to last year. |
Net Reg Sales Qty MTD Var LY |
Month-to-date net regular sales quantity variance compared to last year. |
Net Pro Profit MTD Var LY |
Month-to-date net promotion profit variance compared to last year. |
Net Sales Amt YTD Var LY |
Year-to-date net sales amount variance compared to last year. |
Net Clr Sales Amt YTD Var LY |
Year-to-date net clearance sales amount variance compared to last year. |
Net Pro Sales Amt YTD Var LY |
Year-to-date net promotion sales amount variance compared to last year. |
Net Reg Sales Amt YTD Var LY |
Year-to-date net regular sales amount variance compared to last year. |
Net Sales Qty YTD Var LY |
Year-to-date net sales quantity variance compared to last year. |
Net Clr Sales Qty YTD Var LY |
Year-to-date net clearance sales quantity variance compared to last year. |
Net Pro Sales Qty YTD Var LY |
Year-to-date net promotion sales quantity variance compared to last year. |
Net Reg Sales Qty YTD Var LY |
Year-to-date net regular sales quantity variance compared to last year. |
Net Pro Profit YTD Var LY |
Year-to-date net promotion profit variance compared to last year. |
Comp Gross Sales Amt |
Value of units sold in comparable stores. |
Comp Return Amt |
Value of units returned in comparable stores. |
Comp Net Sales Amt |
Value of net sales in comparable stores. |
Comp Net Clr Sales Amt |
Value of net clearance sales in comparable stores. |
Comp Net Pro Sales Amt |
Value of net promotion sales in comparable stores. |
Comp Net Reg Sales Amt |
Value of net regular sales in comparable stores. |
Comp Gross Sales Qty |
Quantity of units sold in comparable stores. |
Comp Return Qty |
Quantity of units returned in comparable stores. |
Comp Net Sales Qty |
Quantity of net sales in comparable stores. |
Comp Net Profit |
Bottom line profit after accounting for returns in comparable stores. |
Comp Net Clr Profit |
Bottom line profit for clearance items after accounting for returns in comparable stores. |
Comp Net Pro Profit |
Bottom line profit for promotion items after accounting for returns in comparable stores. |
Comp Net Reg Profit |
Bottom line profit for regular items after accounting for returns in comparable stores. |
Comp Gross Sales Amt LY |
Last year's value of units sold in comparable stores. |
Comp Return Amt LY |
Last year's value of units returned in comparable stores. |
Comp Net Sales Amt LY |
Last year's value of net sales in comparable stores. |
Comp Net Clr Sales Amt LY |
Last year's value of net clearance sales in comparable stores. |
Comp Net Pro Sales Amt LY |
Last year's value of net promotion sales in comparable stores. |
Comp Net Reg Sales Amt LY |
Last year's value of net regular sales in comparable stores. |
Comp Gross Sales Qty LY |
Last year's quantity of units sold in comparable stores. |
Comp Return Qty LY |
Last year's quantity of units returned in comparable stores. |
Comp Net Sales Qty LY |
Last year's quantity of units sold in comparable stores. |
Comp Net Profit LY |
Last year's bottom line profit after accounting for returns in comparable stores. |
Comp Gross Sales Amt Var LY |
Gross sales amount variance compared to last year for comparable stores. |
Comp Return Amt Var LY |
Return Amount variance compared to last year for comparable stores. |
Comp Net Sales Amt Var LY |
Net sales amount variance compared to last year for comparable stores. |
Comp Net Clr Sales Amt Var LY |
Net clearance sales amount variance compared to last year for comparable stores. |
Comp Net Pro Sales Amt Var LY |
Net promotion sales amount variance compared to last year for comparable stores. |
Comp Net Reg Sales Amt Var LY |
Net regular sales amount variance compared to last year for comparable stores. |
Comp Gross Sales Qty Var LY |
Gross sales quantity variance compared to last year for comparable stores. |
Comp Return Qty Var LY |
Return quantity variance compared to last year for comparable stores. |
Comp Net Sales Qty Var LY |
Net sales quantity variance compared to last year for comparable stores. |
Comp Net Profit Var LY |
Net profit variance compared to last year for comparable stores. |
Comp Net Clr Profit Var LY |
Net clearance profit variance compared to last year for comparable stores. |
Comp Net Pro Profit Var LY |
Net promotion profit variance compared to last year for comparable stores. |
Comp Net Reg Profit Var LY |
Net regular profit variance compared to last year for comparable stores. |
Comp Net Sales Amt MTD |
Month-to-date value of net sales in comparable stores. |
Comp Net Clr Sales Amt MTD |
Month-to-date value of net clearance sales in comparable stores. |
Comp Net Pro Sales Amt MTD |
Month-to-date value of net promotion sales in comparable stores. |
Comp Net Reg Sales Amt MTD |
Month-to-date value of net regular sales in comparable stores. |
Comp Net Sales Qty MTD |
Month-to-date quantity of net sales in comparable stores. |
Comp Net Profit MTD |
Month-to-date bottom line profit after accounting for returns in comparable stores. |
Comp Net Clr Profit MTD |
Month-to-date bottom line profit for clearance items after accounting for returns in comparable stores. |
Comp Net Pro Profit MTD |
Month-to-date bottom line profit for promotion items after accounting for returns in comparable stores. |
Comp Net Reg Profit MTD |
Month-to-date bottom line profit for regular items after accounting for returns in comparable stores. |
Comp Net Sales Amt LY MTD |
Month-to-date value of net sales in comparable stores for last year. |
Comp Net Sales Qty LY MTD |
Month-to-date quantity of net sales in comparable stores for last year. |
Comp Net Profit LY MTD |
Month-to-date bottom line profit after accounting for returns in comparable stores for last year. |
Comp Net Sales Amt MTD Var LY |
Month-to-date net sales amount variance compared to last year for comparable stores. |
Comp Net Profit MTD Var LY |
Month-to-date net profit variance compared to last year for comparable stores. |
Comp Net Sales Amt YTD |
Year-to-date value of net sales in comparable stores. |
Comp Net Clr Sales Amt YTD |
Year-to-date value of net clearance sales in comparable stores. |
Comp Net Pro Sales Amt YTD |
Year-to-date value of net promotion sales in comparable stores. |
Comp Net Reg Sales Amt YTD |
Year-to-date value of net regular sales in comparable stores. |
Comp Gross Sales Qty YTD |
Year-to-date quantity of units sold in comparable stores. |
Comp Return Qty YTD |
Year-to-date quantity of units returned in comparable stores. |
Comp Net Profit YTD |
Year-to-date bottom line profit after accounting for returns in comparable stores. |
Sales Amt Item Contribution to Department |
Sales revenues generated by an item as a fraction of total sales revenue generated by its department. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Sales Amt Contribution to Loc |
Sales revenues generated by an item as a fraction of total sales revenue generated by its location. Retailers user this key performance indicator to understand consumers' spending on various items in different geographic areas. |
Sales Amt Loc Contribution to Tot |
Sales revenues generated by a location as a fraction of sales generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Sales Amt Department Contribution to Tot |
Sales revenues generated by a department as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Sales Amt Division Contribution to Tot |
Sales revenues generated by a division as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Sales Amt Supplier Contribution to Tot |
Sales revenues generated by a supplier as a fraction of total sales revenue generated by the company. This key performance indicator helps to identify valuable suppliers. |
Sales Amt Division Contribution to Tot LY |
Last year's sales revenues generated by a group as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Profit Item Contribution to Department |
Profit generated by an item as a fraction of total profit generated by its department. It helps to identify high-margin merchandise for purposes of promotions and pricing decisions. |
Profit Amt Contribution to Loc |
Profit generated by an item as a fraction of total profit generated by its location. It helps to identify high-margin merchandise for purposes of promotions and pricing decisions. |
Profit Loc Contribution to Tot |
Profit generated by a location as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit District Contribution to Tot |
Profit generated by a district as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit Region Contribution to Tot |
Profit generated by a region as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit Area Contribution to Tot |
Profit generated by a area as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit Chain Contribution to Tot |
Profit generated by a chain as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit State Contribution to Tot |
Profit generated by a state as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit Country Contribution to Tot |
Profit generated by a country as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit Subclass Contribution to Tot |
Profit generated by a subclass as a fraction of profit generated by the company. This key performance indicator helps retailers to determine store expansion opportunities at high-contributing locations. |
Profit Class Contribution to Tot |
Profit generated by a class as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Profit Department Contribution to Tot |
Profit generated by a department as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Profit Group Contribution to Tot |
Profit generated by a group as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Profit Division Contribution to Tot |
Profit generated by a division as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Profit Subclass Contribution to Tot |
Profit generated by a subclass as a fraction of total sales revenue generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Profit Item Contribution to Department LY |
Last year's profit generated by an item as a fraction of total profit generated by its department. It helps to identify high-margin merchandise for purposes of promotions and pricing decisions. |
Profit Amt Contribution to Loc LY |
Last year's profit generated by an item as a fraction of total profit generated by its location. It helps to identify high-margin merchandise for purposes of promotions and pricing decisions. |
Profit Division Contribution to Tot LY |
Last year's profit generated by a group as a fraction of profit generated by the company. Retailers user this key performance indicator to understand consumers' spending on various items in different product categories. |
Trx Count |
Quantity of transactions. |
Week Count |
Quantity of business weeks. |
Max Trx Amt |
Amount of a transaction. |
Max Trx Unit Qty |
Quantity of units in a transaction. |
Unique Item Count |
Quantity of unique items in a transaction. If a transaction contains an item with multiple units, the item will be counted only once. |
Avg Trx Amt |
Average amount of transactions. |
Avg Trx Unit Qty |
Average quantity of units in a transaction. |
Avg Item Count |
Average quantity of unique items in a transaction. If a transaction contains an item with multiple units, the item will be counted only once. |
Avg Trx Amt LY |
Last year's average amount in a transaction. |
Avg Trx Unit Qty LY |
Last year's average quantity of units in a transaction. |
Avg Item Count LY |
Last year's average quantity of unique items in a transaction. If a transaction contains an item with multiple units, the item will be counted only once. |
Avg Dept Count |
Average quantity of unique departments in a transaction. If a transaction contains multiple items or multiple units from a department, the department will be counted only once. |
Avg Dept Count LY |
Last year's average quantity of unique departments in a transaction. If a transaction contains multiple items or multiple units from a department, the department will be counted only once. |
Table C-6 Sales Pack Metrics
Metric | Definition |
---|---|
Pack Gross Sales Amt |
Total value of regular, clearance, and promotion pack sales and pack components before returns. The amount is inclusive of VAT. |
Pack Return Amt |
Retail value of pack sales and pack component units returned. It indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales |
Pack Net Sales Amt |
Sales amount excluding returns. It indicates the actual money amount received from pack sales and pack component. |
Pack Net Clr Sales Amt |
Clearance sales amount excluding returns. It indicates the actual money amount received from pack sales and pack component. |
Pack Net Pro Sales Amt |
Promotion sales amount excluding returns. It indicates the actual money amount received from pack sales and pack component. |
Pack Net Reg Sales Amt |
Regular sales amount excluding returns. It indicates the actual money amount received from pack sales and pack component. |
Pack Gross Sales Qty |
Total quantity of regular, clearance, and promotion pack sales and pack component units before returns. |
Pack Return Qty |
Quantity of units returned for a pack component item. This is the product of the pack item returns quantity times the pack component item quantity. |
Pack Net Sales Qty |
Difference between pack gross sales quantity and pack returns quantity. |
Pack Net Clr Sales Qty |
Difference between pack gross clearance sales quantity and pack returns quantity. |
Pack Net Pro Sales Qty |
Difference between pack gross promotion sales quantity and pack returns quantity. |
Pack Net Reg Sales Qty |
Difference between pack gross regular sales quantity and pack returns quantity. |
Pack Gross Profit |
Difference between sales revenue and the cost of units sold for a pack component item. It indicates the retailer's ability to mark up merchandise for sale. |
Pack Return Profit |
Difference between the pack return amount and the cost of pack units returned. The cost of units returned is the product of return quantity times average cost. It indicates the profit lost because of returns. |
Pack Net Profit |
Bottom line profit for a pack component item, calculated from money left over after paying all expenses and taxes. This is calculated from the primary supplier's net cost for an item/location. |
Pack Net Clr Profit |
Difference between pack gross profit and pack returns profit for clearance priced items. |
Pack Net Pro Profit |
Difference between pack gross profit and pack returns profit for promotion priced items. |
Pack Net Reg Profit |
Difference between pack gross profit and pack returns profit for regular priced items. |
Pack Net Emp Disc |
Difference between pack gross employee discount amount and pack returns employee discount amount. |
Pack Gross Tax |
Tax applied on total sales revenue for a pack component item. Expenses are not deducted when calculating the tax amount. |
Pack Return Tax |
Taxes that have been accounted on pack returned merchandise. |
Pack Net Tax |
Taxes payable by a company at the end of fiscal year for a pack component item. It is gross tax less returns tax. |
Pack Gross Profit to Sales Amt |
Ratio of pack profit achieved on total pack sales. The ratio reflects a company's ability to balance its costs with sales. It is a key performance indicator of a company's efficiency and performance. |
Pack Net Profit to Sales Amt |
Ratio of pack net profit to pack net sales. It indicates the bottom-line profit a company keeps from money generated by sales. This is a key performance indicator of a company's profitability for investors. |
Pack Avg Net Retail |
Average retail price of sold pack items. This is calculated by deducting any taxes or expenses. |
Pack Gross Sales Amt LY |
Last year's value of pack units sold. |
Pack Return Amt LY |
Last year's value of pack units returned. |
Pack Net Sales Amt LY |
Last year's value of pack net sales. |
Pack Net Clr Sales Amt LY |
Last year's value of pack net clearance sales. |
Pack Net Pro Sales Amt LY |
Last year's value of pack net promotion sales. |
Pack Net Reg Sales Amt LY |
Last year's value of pack net regular sales. |
Pack Gross Sales Qty LY |
Last year's quantity of pack units sold. |
Pack Return Qty LY |
Last year's quantity of pack units returned. |
Pack Net Sales Qty LY |
Last year's quantity of pack net sales. |
Pack Net Clr Sales Qty LY |
Last year's quantity of pack net clearance sales. |
Pack Net Pro Sales Qty LY |
Last year's quantity of pack net promotion sales. |
Pack Net Reg Sales Qty LY |
Last year's quantity of pack net regular sales. |
Pack Gross Profit LY |
Last year's difference between pack sales revenue and the cost of pack units sold. |
Pack Return Profit LY |
Last year's difference between the retail value of pack returns and the cost of pack units returned. |
Pack Net Profit LY |
Last year's bottom line pack profit after accounting for returns. |
Pack Net Clr Profit LY |
Last year's bottom line pack profit for clearance items after accounting for returns. |
Pack Net Pro Profit LY |
Last year's bottom line pack profit for promotion items after accounting for returns. |
Pack Net Reg Profit LY |
Last year's bottom line pack profit for regular items after accounting for returns. |
Pack Net Emp Disc LY |
Last year's employee discount amount applied to pack sales after accounting for returns. |
Pack Gross Tax LY |
Last year's tax applied on total pack sales revenue. |
Pack Return Tax LY |
Last year's tax applied on total pack return value. |
Pack Net Tax LY |
Last year's total taxes applied on pack sales revenue after accounting for returns. |
Pack Gross Profit to Sales Amt LY |
Last year's ratio of profit achieved on total pack sales. |
Pack Net Profit to Sales Amt LY |
Last year's ratio of pack net profit to net pack sales. |
Pack Avg Net Retail LY |
Last year's average retail price of sold pack items. |
Pack Gross Sales Amt Var LY |
Pack gross sales amount variance compared to last year. |
Pack Return Amt Var LY |
Pack return amount variance compared to last year. |
Pack Net Sales Amt Var LY |
Pack net sales amount variance compared to last year. |
Pack Net Clr Sales Amt Var LY |
Pack net clearance sales amount variance compared to last year. |
Pack Net Pro Sales Amt Var LY |
Pack net promotion sales amount variance compared to last year. |
Pack Net Reg Sales Amt Var LY |
Pack net regular sales amount variance compared to last year. |
Pack Gross Sales Qty Var LY |
Pack gross sales quantity variance compared to last year. |
Pack Return Qty Var LY |
Pack return quantity variance compared to last year. |
Pack Net Sales Qty Var LY |
Pack net sales quantity variance compared to last year. |
Pack Net Clr Sales Qty Var LY |
Pack net clearance sales quantity variance compared to last year. |
Pack Net Pro Sales Qty Var LY |
Pack net promotion sales quantity variance compared to last year. |
Pack Net Reg Sales Qty Var LY |
Pack net regular sales quantity variance compared to last year. |
Pack Gross Profit Var LY |
Pack gross profit variance compared to last year. |
Pack Return Profit Var LY |
Pack return profit variance compared to last year. |
Pack Net Profit Var LY |
Pack net profit variance compared to last year. |
Pack Net Clr Profit Var LY |
Pack net clearance profit variance compared to last year. |
Pack Net Pro Profit Var LY |
Pack net promotion profit variance compared to last year. |
Pack Net Reg Profit Var LY |
Pack net regular profit variance compared to last year. |
Pack Net Emp Disc Var LY |
Pack net employee discount variance compared to last year. |
Pack Gross Tax Var LY |
Pack gross tax variance compared to last year. |
Pack Return Tax Var LY |
Pack return tax variance compared to last year. |
Pack Net Tax Var LY |
Pack net tax variance compared to last year. |
Pack Liability Amt |
The retail value of sales pack tied in liability in lieu of unfulfilled order that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered goods to the customer. |
Pack Liability Canceled Amt |
The retail value of sales pack that were canceled for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign . |
Pack Liability Qty |
The sales pack quantity tied in liability in lieu of unfulfilled order that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered goods to the customer. |
Pack Liability Canceled Qty |
The number of sales pack units that were canceled for which a retailer initially had a liability on, at the time of ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Pack Profit Liability Amt |
The profit value of sales packs that are ordered as liability for which a retailer is legally bound or obligated. |
Pack Profit Liability Canceled Amt |
The loss on profit amount occurred due to cancelation of goods/units that were ordered as liability for which a retailer was legally bound or obligated. These values will be positive. |
Table C-7 Supplier Invoice Metrics
Metric | Definition |
---|---|
Invoice Qty |
Number of units for which a supplier is requesting payment. |
PO Unit Cost |
Unit cost when an order was placed for an item. |
Invoice Unit Cost |
Unit cost charged by the supplier to the retailer for an item. |
Tot PO Unit Cost |
Total cost of the order quantity when applying the purchase order unit cost. |
Tot Invoice Unit Cost |
Total cost of the order quantity when applying the invoice unit cost. |
Tot PO to Invoice Cost Diff |
Difference in total cost of the order quantity between the purchase order and invoice costs. |
Table C-8 Supplier Compliance Metrics
Metric | Definition |
---|---|
Unfulfilled ASN Count |
Number of advance shipping notices (ASN) for which the associated shipment delivery has not yet been received. |
Unfulfilled PO Count |
Number of purchase orders for which the total number of ordered units has not yet been received. |
PO Met Count |
Number of purchase orders for which ordered quantity is equal to received quantity. |
PO Under Count |
Number of purchase orders for which ordered quantity is greater than received quantity. |
PO Over Count |
Number of purchase orders for which ordered quantity is less than received quantity. |
PO Absent Count |
Number of shipment deliveries that were received without corresponding purchase orders. |
Ship Late Count |
Number of shipment deliveries that arrived after the date specified on the purchase order as the last date that delivery of the order would be accepted. |
Ship Early Count |
Number of shipment deliveries that arrived before the date specified on the purchase order as the first date that delivery of the order would be accepted. |
Ship On Time Count |
Number of shipment deliveries that arrived within the timeframe specified on the purchase order that delivery of the order would be accepted. |
Days Early Ship |
Number of days that a shipment delivery arrived before the date specified on the purchase order as the first date that delivery of the order would be accepted. |
Days Late Ship |
Number of days that a shipment delivery arrived after the date specified on the purchase order as the last date that delivery of the order would be accepted. |
ASN Met Count |
Number of advance shipping notices (ASN) for which expected shipment deliveries equal received shipments. |
ASN Under Count |
Number of advance shipping notices (ASN) for which expected shipment deliveries are greater than received shipments. |
ASN Over Count |
Number of advance shipping notices (ASN) for which expected shipment deliveries are less than received shipments. |
ASN Expected Qty |
Quantity of units expected to be received based on the associated order number or on the supplier's advance shipping notices (ASN). |
Ordered Qty |
Quantity of units ordered in a purchase order. |
Received Qty |
Quantity of units received in a shipment delivery. |
Shipment Count |
Total number of shipment deliveries that were received by the retailer. |
Table C-9 Inventory Position Metrics
Metric | Definition |
---|---|
BOH Qty |
Quantity of owned inventory units at the beginning of the reporting period. This includes inventory held as components within pack items. |
BOH Retail |
Retail value of owned inventory units at the beginning of the reporting period. This includes inventory held as components within pack items. |
BOH Cost |
Cost value of owned inventory units at the beginning of the reporting period. This includes inventory for pack component items. |
EOH Qty |
Quantity of owned inventory units at the end of the reporting period. This includes inventory held as components within pack items. |
EOH Retail |
Retail value of owned inventory units at the end of the reporting period. This includes inventory for pack component items. |
EOH Cost |
Cost value of owned inventory units at the end of the reporting period. This includes inventory for pack component items. |
In Transit Qty |
Quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. This includes inventory for pack component items. |
In Transit Retail |
Retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. This includes inventory for pack component items. |
In Transit Cost |
Cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. This includes inventory for pack component items. |
On Order Qty |
Quantity of ordered inventory units that have not yet been received at the end of the reporting period. This includes inventory for pack component items. |
On Order Retail |
Retail value of ordered inventory units that have not yet been received at the end of the reporting period. This includes inventory for pack component items. |
On Order Cost |
Cost value of ordered inventory units that have not yet been received at the end of the reporting period. This includes inventory for pack component items. |
Inv Unit Retail |
Retail value for an item when it is sold in a singular quantity of the standard unit of measure. |
Inv Unit Cost |
Purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options. |
Inv Avg Cost |
Weighted average cost of an item at a location, based on the purchase order estimated landed cost. This is adjusted each time inventory is received at this location. Stock of a pack item is valued at the component level, and therefore an average cost is not applicable for pack items. |
BOH Qty LW |
Last week's quantity of owned inventory units at the beginning of the reporting period. |
BOH Retail LW |
Last week's retail value of owned inventory units at the beginning of the reporting period. This includes inventory held as components within pack items. |
BOH Cost LW |
Last week's cost value of owned inventory units at the beginning of the reporting period. |
EOH Qty LW |
Last week's quantity of owned inventory units at the end of the reporting period. |
EOH Retail LW |
Last week's retail value of owned inventory units at the end of the reporting period. |
EOH Cost LW |
Last week's cost value of owned inventory units at the end of the reporting period. |
In Transit Qty LW |
Last week's quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
In Transit Retail LW |
Last week's retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
In Transit Cost LW |
Last week's cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
On Order Qty LW |
Last week's quantity of ordered inventory units that have not yet been received at the end of the reporting period. |
On Order Retail LW |
Last week's retail value of ordered inventory units that have not yet been received at the end of the reporting period. |
On Order Cost LW |
Last week's cost value of ordered inventory units that have not yet been received at the end of the reporting period. |
Inv Unit Retail LW |
Last week's retail value for an item when it is sold in a singular quantity of the standard unit of measure. |
Inv Unit Cost LW |
Last week's purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options. |
Inv Avg Cost LW |
Last week's weighted average cost of an item at a location, based on the purchase order estimated landed cost. This is adjusted each time inventory is received at this location. Stock of a pack item is valued at the component level, and therefore an average cost is not applicable for pack items. |
BOH Qty LY |
Last year's quantity of owned inventory units at the beginning of the reporting period. |
BOH Retail LY |
Last year's retail value of owned inventory units at the beginning of the reporting period. |
BOH Cost LY |
Last year's cost value of owned inventory units at the beginning of the reporting period. |
EOH Qty LY |
Last year's quantity of owned inventory units at the end of the reporting period. |
EOH Retail LY |
Last year's retail value of owned inventory units at the end of the reporting period. |
EOH Cost LY |
Last year's cost value of owned inventory units at the end of the reporting period. |
In Transit Qty LY |
Last year's quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
In Transit Retail LY |
Last year's retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
In Transit Cost LY |
Last year's cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
On Order Qty LY |
Last year's quantity of ordered inventory units that have not yet been received at the end of the reporting period. |
On Order Retail LY |
Last year's retail value of ordered inventory units that have not yet been received at the end of the reporting period. |
On Order Cost LY |
Last year's cost value of ordered inventory units that have not yet been received at the end of the reporting period. |
Inv Unit Retail LY |
Last year's retail value for an item when it is sold in a singular quantity of the standard unit of measure. |
Inv Unit Cost LY |
Last year's purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options. |
Inv Avg Cost LY |
Last year's weighted average cost of an item at a location, based on the purchase order estimated landed cost. |
Current BOH Qty |
Quantity of owned inventory units at the beginning of current week. This includes inventory held as components within pack items. |
Current BOH Retail |
Retail value of owned inventory units at the beginning of current week. This includes inventory held as components within pack items. |
Current BOH Cost |
Cost value of owned inventory units at the beginning of current week. This includes inventory for pack component items. |
Current EOH Qty |
Quantity of owned inventory units at the end of current day. This includes inventory held as components within pack items. |
Current EOH Retail |
Retail value of owned inventory units at the end of the current day. This includes inventory for pack component items. |
Current EOH Cost |
Cost value of owned inventory units at the end of the current day. This includes inventory for pack component items. |
Current In Transit Qty |
Quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the current day. This includes inventory for pack component items. |
Current In Transit Retail |
Retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the current day. This includes inventory for pack component items. |
Current In Transit Cost |
Cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of current day. This includes inventory for pack component items. |
Current On Order Qty |
Quantity of ordered inventory units that have not yet been received at the end of current day. This includes inventory for pack component items. |
Current On Order Retail |
Retail value of ordered inventory units that have not yet been received at the end of current day. This includes inventory for pack component items. |
Current On Order Cost |
Cost value of ordered inventory units that have not yet been received at the end of current day. This includes inventory for pack component items. |
Current Inv Unit Retail |
Retail value for an item when it is sold in a singular quantity of the standard unit of measure at the end of the current day. |
Current Inv Unit Cost |
Purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options. |
Current Inv Avg Cost |
Weighted average cost of an item at a location, based on the purchase order estimated landed cost at the end of the current day. This is adjusted each time inventory is received at this location. Stock of a pack item is valued at the component level, and therefore an average cost is not applicable for pack items. |
Min BOH Qty |
Minimum quantity of owned inventory units at the beginning of the reporting period. |
Min BOH Retail |
Minimum retail value of owned inventory units at the beginning of the reporting period. |
Min BOH Cost |
Minimum cost value of owned inventory units at the beginning of the reporting period. |
Min EOH Qty |
Minimum quantity of owned inventory units at the end of the reporting period. |
Min EOH Retail |
Minimum retail value of owned inventory units at the end of the reporting period. |
Min EOH Cost |
Minimum cost value of owned inventory units at the end of the reporting period. |
Min In Transit Qty |
Minimum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
Min In Transit Retail |
Minimum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
Min In Transit Cost |
Minimum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
Min On Order Qty |
Minimum quantity of ordered inventory units that have not yet been received at the end of the reporting period. |
Min On Order Retail |
Minimum retail value of ordered inventory units that have not yet been received at the end of the reporting period. |
Min On Order Cost |
Minimum cost value of ordered inventory units that have not yet been received at the end of the reporting period. |
Min Inv Unit Retail |
Minimum retail value for an item when it is sold in a singular quantity of the standard unit of measure. |
Min Inv Unit Cost |
Minimum purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options. |
Min Inv Avg Cost |
Minimum weighted average cost of an item at a location, based on the purchase order estimated landed cost. |
Max BOH Qty |
Maximum quantity of owned inventory units at the beginning of the reporting period. |
Max BOH Retail |
Maximum retail value of owned inventory units at the beginning of the reporting period. |
Max BOH Cost |
Maximum cost value of owned inventory units at the beginning of the reporting period. |
Max EOH Qty |
Maximum quantity of owned inventory units at the end of the reporting period. |
Max EOH Retail |
Maximum retail value of owned inventory units at the end of the reporting period. |
Max EOH Cost |
Maximum cost value of owned inventory units at the end of the reporting period. |
Max In Transit Qty |
Maximum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
Max In Transit Retail |
Maximum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
Max In Transit Cost |
Maximum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period. |
Max On Order Qty |
Maximum quantity of ordered inventory units that have not yet been received at the end of the reporting period. |
Max On Order Retail |
Maximum retail value of ordered inventory units that have not yet been received at the end of the reporting period. |
Max On Order Cost |
Maximum cost value of ordered inventory units that have not yet been received at the end of the reporting period. |
Max Inv Unit Retail |
Maximum retail value for an item when it is sold in a singular quantity of the standard unit of measure. |
Max Inv Unit Cost |
Maximum purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options. |
Max Inv Avg Cost |
Maximum weighted average cost of an item at a location, based on the purchase order estimated landed cost. |
BOH Qty Current Week LY |
Quantity of owned inventory units at the beginning of the week , corresponding to the current week, for last year. |
BOH Retail Current Week LY |
Retail value of owned inventory units at the beginning of the week, corresponding to the current week, for last year. |
BOH Cost Current Week LY |
Cost value of owned inventory units at the beginning of the week, corresponding to the current week, for last year. |
EOH Qty Today Current Day LY |
Quantity of owned inventory units at the end of day, corresponding to current day, for last year. |
EOH Retail Current Day LY |
Retail value of owned inventory units at the end of day, corresponding to current day, for last year. |
EOH Cost Current Day LY |
Cost value of owned inventory units at the end of day, corresponding to current day, for last year. |
In Transit Qty Current Day LY |
Quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of day, corresponding to current day, for last year. |
In Transit Retail Current Day LY |
Retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of day, corresponding to current day, for last year. |
In Transit Cost Current Day LY |
Cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of day, corresponding to current day, for last year. |
On Order Qty Current Day LY |
Quantity of ordered inventory units that have not yet been received at the end of the day, corresponding to the current day, for last year. |
On Order Retail Current Day LY |
Retail value of ordered inventory units that have not yet been received at the end of the day, corresponding to the current day, for last year. |
On Order Cost Current Day LY |
Cost value of ordered inventory units that have not yet been received at the end of the day, corresponding to the current day, for last year. |
Inv Unit Retail Current Day LY |
Retail value for an item when it is sold in a singular quantity of the standard unit of measure for the end of the day, corresponding to the current day last year. |
Inv Unit Cost Current Day LY |
Purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options, for the end of the day, corresponding to the current day last year. |
Inv Avg Cost Current Day LY |
Weighted average cost of an item at a location, based on the purchase order estimated landed cost for the end of the day, corresponding to the current day last year. |
Min BOH Qty LY |
Minimum quantity of owned inventory units at the beginning of the reporting period for last year. |
Min BOH Retail LY |
Minimum retail value of owned inventory units at the beginning of the reporting period for last year. |
Min BOH Cost LY |
Minimum cost value of owned inventory units at the beginning of the reporting period for last year. |
Min EOH Qty LY |
Minimum quantity of owned inventory units at the end of the reporting period for last year. |
Min EOH Retail LY |
Minimum retail value of owned inventory units at the end of the reporting period for last year. |
Min EOH Cost LY |
Minimum cost value of owned inventory units at the end of the reporting period for last year. |
Min In Transit Qty LY |
Minimum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period for last year. |
Min In Transit Retail LY |
Minimum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period for last year. |
Min In Transit Cost LY |
Minimum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period for last year. |
Min On Order Qty LY |
Minimum quantity of ordered inventory units that have not yet been received at the end of the reporting period for last year. |
Min On Order Retail LY |
Minimum retail value of ordered inventory units that have not yet been received at the end of the reporting period for last year. |
Min On Order Cost LY |
Minimum cost value of ordered inventory units that have not yet been received at the end of the reporting period for last year. |
Min Inv Unit Retail LY |
Minimum retail value for an item when it is sold in a singular quantity of the standard unit of measure for last year. |
Min Inv Unit Cost LY |
Minimum purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options, for last year. |
Min Inv Avg Cost LY |
Minimum weighted average cost of an item at a location, based on the purchase order estimated landed cost, for last year. |
Max BOH Qty LY |
Maximum quantity of owned inventory units at the beginning of the reporting period for last year. |
Max BOH Retail LY |
Maximum retail value of owned inventory units at the beginning of the reporting period for last year. |
Max BOH Cost LY |
Maximum cost value of owned inventory units at the beginning of the reporting period for last year. |
Max EOH Qty LY |
Maximum quantity of owned inventory units at the end of the reporting period for last year. |
Max EOH Retail LY |
Maximum retail value of owned inventory units at the end of the reporting period for last year. |
Max EOH Cost LY |
Maximum cost value of owned inventory units at the end of the reporting period for last year. |
Max In Transit Qty LY |
Maximum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period for last year. |
Max In Transit Retail LY |
Maximum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period for last year. |
Max In Transit Cost LY |
Maximum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period for last year. |
Max On Order Qty LY |
Maximum quantity of ordered inventory units that have not yet been received at the end of the reporting period for last year. |
Max On Order Retail LY |
Maximum retail value of ordered inventory units that have not yet been received at the end of the reporting period for last year. |
Max On Order Cost LY |
Maximum cost value of ordered inventory units that have not yet been received at the end of the reporting period for last year. |
Max Inv Unit Retail LY |
Maximum retail value for an item when it is sold in a singular quantity of the standard unit of measure for last year. |
Max Inv Unit Cost LY |
Maximum purchase order estimated landed cost each time this item is received at this location, or the primary supplier cost, depending on the merchandising system options, for last year. |
Max Inv Avg Cost LY |
Maximum weighted average cost of an item at a location, based on the purchase order estimated landed cost, for last year. |
BOH Qty Var LW |
Beginning of period owned inventory units variance compared to last week. |
BOH Retail Var LW |
Beginning of period owned inventory retail value variance compared to last week. |
BOH Cost Var LW |
Beginning of period owned inventory cost value variance compared to last week. |
EOH Qty Var LW |
End of period owned inventory units variance compared to last week. |
EOH Retail Var LW |
End of period owned inventory retail value variance compared to last week. |
EOH Cost Var LW |
End of period owned inventory cost value variance compared to last week. |
In Transit Qty Var LW |
End of period in transit inventory units variance compared to last week. |
In Transit Retail Var LW |
End of period in transit inventory retail value variance compared to last week. |
In Transit Cost Var LW |
End of period in transit inventory cost value variance compared to last week. |
On Order Qty Var LW |
End of period on order inventory units variance compared to last week. |
On Order Retail Var LW |
End of period on order inventory retail value variance compared to last week. |
On Order Cost Var LW |
End of period on order inventory cost value variance compared to last week. |
BOH Qty Var LY |
Beginning of period owned inventory units variance compared to last year. |
BOH Retail Var LY |
Beginning of period owned inventory retail value variance compared to last year. |
BOH Cost Var LY |
Beginning of period owned inventory cost value variance compared to last year. |
EOH Qty Var LY |
End of period owned inventory units variance compared to last year. |
EOH Retail Var LY |
End of period owned inventory retail value variance compared to last year. |
EOH Cost Var LY |
End of period owned inventory cost value variance compared to last year. |
In Transit Qty Var LY |
End of period in transit inventory units variance compared to last year. |
In Transit Retail Var LY |
End of period in transit inventory retail value variance compared to last year. |
In Transit Cost Var LY |
End of period in transit inventory cost value variance compared to last year. |
On Order Qty Var LY |
End of period on order inventory units variance compared to last year. |
On Order Retail Var LY |
End of period on order inventory retail value variance compared to last year. |
On Order Cost Var LY |
End of period on order inventory cost value variance compared to last year. |
Min BOH Qty Var LY |
Minimum beginning of period owned inventory units variance compared to last year. |
Min BOH Retail Var LY |
Minimum beginning of period owned inventory retail value variance compared to last year. |
Min BOH Cost Var LY |
Minimum beginning of period owned inventory cost value variance compared to last year. |
Min EOH Qty Var LY |
Minimum end of period owned inventory units variance compared to last year. |
Min EOH Retail Var LY |
Minimum end of period owned inventory retail value variance compared to last year. |
Min EOH Cost Var LY |
Minimum end of period owned inventory cost value variance compared to last year. |
Min In Transit Qty Var LY |
Minimum end of period in transit inventory units variance compared to last year. |
Min In Transit Retail Var LY |
Minimum end of period in transit inventory retail value variance compared to last year. |
Min In Transit Cost Var LY |
Minimum end of period in transit inventory cost value variance compared to last year. |
Min On Order Qty Var LY |
Minimum end of period on order inventory units variance compared to last year. |
Min On Order Retail Var LY |
Minimum end of period on order inventory retail value variance compared to last year. |
Min On Order Cost Var LY |
Minimum end of period on order inventory cost value variance compared to last year. |
Max BOH Qty Var LY |
Maximum beginning of period owned inventory units variance compared to last year. |
Max BOH Retail Var LY |
Maximum beginning of period owned inventory retail value variance compared to last year. |
Max BOH Cost Var LY |
Maximum beginning of period owned inventory cost value variance compared to last year. |
Max EOH Qty Var LY |
Maximum end of period owned inventory units variance compared to last year. |
Max EOH Retail Var LY |
Maximum end of period owned inventory retail value variance compared to last year. |
Max EOH Cost Var LY |
Maximum end of period owned inventory cost value variance compared to last year. |
Max In Transit Qty Var LY |
Maximum end of period in transit inventory units variance compared to last year. |
Max In Transit Retail Var LY |
Maximum end of period in transit inventory retail value variance compared to last year. |
Max In Transit Cost Var LY |
Maximum end of period in transit inventory cost value variance compared to last year. |
Max On Order Qty Var LY |
Maximum end of period on order inventory units variance compared to last year. |
Max On Order Retail Var LY |
Maximum end of period on order inventory retail value variance compared to last year. |
Max On Order Cost Var LY |
Maximum end of period on order inventory cost value variance compared to last year. |
Comp BOH Qty |
Quantity of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp BOH Retail |
Retail value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp BOH Cost |
Cost value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp EOH Qty |
Quantity of owned inventory units at the end of the reporting period in comparable stores. |
Comp EOH Retail |
Retail value of owned inventory units at the end of the reporting period in comparable stores. |
Comp EOH Cost |
Cost value of owned inventory units at the end of the reporting period in comparable stores. |
Comp In Transit Qty |
Quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp In Transit Retail |
Retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp In Transit Cost |
Cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp On Order Qty |
Quantity of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp On Order Retail |
Retail value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp On Order Cost |
Cost value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp BOH Qty LY |
Last year's quantity of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp BOH Retail LY |
Last year's retail value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp BOH Cost LY |
Last year's cost value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp EOH Qty LY |
Last year's quantity of owned inventory units at the end of the reporting period in comparable stores. |
Comp EOH Retail LY |
Last year's retail value of owned inventory units at the end of the reporting period in comparable stores. |
Comp EOH Cost LY |
Last year's cost value of owned inventory units at the end of the reporting period in comparable stores. |
Comp In Transit Qty LY |
Last year's quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp In Transit Retail LY |
Last year's retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp In Transit Cost LY |
Last year's cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp On Order Qty LY |
Last year's quantity of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp On Order Retail LY |
Last year's retail value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp On Order Cost LY |
Last year's cost value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp BOH Qty Var LY |
Beginning of period owned inventory units variance compared to last year in comparable stores. |
Comp BOH Retail Var LY |
Beginning of period owned inventory retail value variance compared to last year in comparable stores. |
Comp BOH Cost Var LY |
Beginning of period owned inventory cost value variance compared to last year in comparable stores. |
Comp EOH Qty Var LY |
End of period owned inventory units variance compared to last year in comparable stores. |
Comp EOH Retail Var LY |
End of period owned inventory retail value variance compared to last year in comparable stores. |
Comp EOH Cost Var LY |
End of period owned inventory cost value variance compared to last year in comparable stores. |
Comp In Transit Qty Var LY |
End of period in transit inventory units variance compared to last year in comparable stores. |
Comp In Transit Retail Var LY |
End of period in transit inventory retail value variance compared to last year in comparable stores. |
Comp In Transit Cost Var LY |
End of period in transit inventory cost value variance compared to last year in comparable stores. |
Comp On Order Qty Var LY |
End of period on order inventory units variance compared to last year in comparable stores. |
Comp On Order Retail Var LY |
End of period on order inventory retail value variance compared to last year in comparable stores. |
Comp On Order Cost Var LY |
End of period on order inventory cost value variance compared to last year in comparable stores. |
Comp Min BOH Qty |
Minimum quantity of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp Min BOH Retail |
Minimum retail value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp Min BOH Cost |
Minimum cost value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp Min EOH Qty |
Minimum quantity of owned inventory units at the end of the reporting period in comparable stores. |
Comp Min EOH Retail |
Minimum retail value of owned inventory units at the end of the reporting period in comparable stores. |
Comp Min EOH Cost |
Minimum cost value of owned inventory units at the end of the reporting period in comparable stores. |
Comp Min In Transit Qty |
Minimum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp Min In Transit Retail |
Minimum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp Min In Transit Cost |
Minimum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp Min On Order Qty |
Minimum quantity of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp Min On Order Retail |
Minimum retail value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp Min On Order Cost |
Minimum cost value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp Min BOH Qty LY |
Minimum quantity of owned inventory units at the beginning of the reporting period in comparable stores for last year. |
Comp Min BOH Retail LY |
Minimum retail value of owned inventory units at the beginning of the reporting period in comparable stores for last year. |
Comp Min BOH Cost LY |
Minimum cost value of owned inventory units at the beginning of the reporting period in comparable stores for last year. |
Comp Min EOH Qty LY |
Minimum quantity of owned inventory units at the end of the reporting period in comparable stores for last year. |
Comp Min EOH Retail LY |
Minimum retail value of owned inventory units at the end of the reporting period in comparable stores for last year. |
Comp Min EOH Cost LY |
Minimum cost value of owned inventory units at the end of the reporting period in comparable stores for last year. |
Comp Min In Transit Qty LY |
Minimum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores for last year. |
Comp Min In Transit Retail LY |
Minimum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores for last year. |
Comp Min In Transit Cost LY |
Minimum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores for last year. |
Comp Min On Order Qty LY |
Minimum quantity of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores for last year. |
Comp Min On Order Retail LY |
Minimum retail value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores for last year. |
Comp Min On Order Cost LY |
Minimum cost value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores for last year. |
Comp Min BOH Qty Var LY |
Minimum beginning of period owned inventory units variance compared to last year in comparable stores. |
Comp Min BOH Retail Var LY |
Minimum beginning of period owned inventory retail value variance compared to last year in comparable stores. |
Comp Min BOH Cost Var LY |
Minimum beginning of period owned inventory cost value variance compared to last year in comparable stores. |
Comp Min EOH Qty Var LY |
Minimum end of period owned inventory units variance compared to last year in comparable stores. |
Comp Min EOH Retail Var LY |
Minimum end of period owned inventory retail value variance compared to last year in comparable stores. |
Comp Min EOH Cost Var LY |
Minimum end of period owned inventory cost value variance compared to last year in comparable stores. |
Comp Min In Transit Qty Var LY |
Minimum end of period in transit inventory units variance compared to last year in comparable stores.t |
Comp Min In Transit Retail Var LY |
Minimum end of period in transit inventory retail value variance compared to last year in comparable stores. |
Comp Min In Transit Cost Var LY |
Minimum end of period in transit inventory cost value variance compared to last year in comparable stores. |
Comp Min On Order Qty Var LY |
Minimum end of period on order inventory units variance compared to last year in comparable stores. |
Comp Min On Order Retail Var LY |
Minimum end of period on order inventory retail value variance compared to last year in comparable stores. |
Comp Min On Order Cost Var LY |
Minimum end of period on order inventory cost value variance compared to last year in comparable stores. |
Comp Max BOH Qty |
Maximum quantity of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp Max BOH Retail |
Maximum retail value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp Max BOH Cost |
Maximum cost value of owned inventory units at the beginning of the reporting period in comparable stores. |
Comp Max EOH Qty |
Maximum quantity of owned inventory units at the end of the reporting period in comparable stores. |
Comp Max EOH Retail |
Maximum retail value of owned inventory units at the end of the reporting period in comparable stores. |
Comp Max EOH Cost |
Maximum cost value of owned inventory units at the end of the reporting period in comparable stores. |
Comp Max In Transit Qty |
Maximum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp Max In Transit Retail |
Maximum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp Max In Transit Cost |
Maximum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores. |
Comp Max On Order Qty |
Maximum quantity of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp Max On Order Retail |
Maximum retail value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp Max On Order Cost |
Maximum cost value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores. |
Comp Max BOH Qty LY |
Maximum quantity of owned inventory units at the beginning of the reporting period in comparable stores for last year. |
Comp Max BOH Retail LY |
Maximum retail value of owned inventory units at the beginning of the reporting period in comparable stores for last year. |
Comp Max BOH Cost LY |
Maximum cost value of owned inventory units at the beginning of the reporting period in comparable stores for last year. |
Comp Max EOH Qty LY |
Maximum quantity of owned inventory units at the end of the reporting period in comparable stores for last year. |
Comp Max EOH Retail LY |
Maximum retail value of owned inventory units at the end of the reporting period in comparable stores for last year. |
Comp Max EOH Cost LY |
Maximum cost value of owned inventory units at the end of the reporting period in comparable stores for last year. |
Comp Max In Transit Qty LY |
Maximum quantity of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores for last year. |
Comp Max In Transit Retail LY |
Maximum retail value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores for last year. |
Comp Max In Transit Cost LY |
Maximum cost value of transfer and allocation inventory units that have been shipped but not yet received at the end of the reporting period in comparable stores for last year. |
Comp Max On Order Qty LY |
Maximum quantity of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores for last year. |
Comp Max On Order Retail LY |
Maximum retail value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores for last year. |
Comp Max On Order Cost LY |
Maximum cost value of ordered inventory units that have not yet been received at the end of the reporting period in comparable stores for last year. |
Comp Max BOH Qty Var LY |
Maximum beginning of period owned inventory units variance compared to last year in comparable stores. |
Comp Max BOH Retail Var LY |
Maximum beginning of period owned inventory retail value variance compared to last year in comparable stores. |
Comp Max BOH Cost Var LY |
Maximum beginning of period owned inventory cost value variance compared to last year in comparable stores. |
Comp Max EOH Qty Var LY |
Maximum end of period owned inventory units variance compared to last year in comparable stores. |
Comp Max EOH Retail Var LY |
Maximum end of period owned inventory retail value variance compared to last year in comparable stores. |
Comp Max EOH Cost Var LY |
Maximum end of period owned inventory cost value variance compared to last year in comparable stores. |
Comp Max In Transit Qty Var LY |
Maximum end of period in transit inventory units variance compared to last year in comparable stores. |
Comp Max In Transit Retail Var LY |
Maximum end of period in transit inventory retail value variance compared to last year in comparable stores. |
Comp Max In Transit Cost Var LY |
Maximum end of period in transit inventory cost value variance compared to last year in comparable stores. |
Comp Max On Order Qty Var LY |
Maximum end of period on order inventory units variance compared to last year in comparable stores. |
Comp Max On Order Retail Var LY |
Maximum end of period on order inventory retail value variance compared to last year in comparable stores. |
Comp Max On Order Cost Var LY |
Maximum end of period on order inventory cost value variance compared to last year in comparable stores. |
Stock Turnover |
Number of times the inventory stock has been turned over during the period. It is calculated by dividing the cost of goods sold by the amount of average stock at cost. |
Stock to Sales |
Ratio of the number of times owned inventory can fulfill sales for a given time period. |
Weeks of Supply |
Number of weeks that current inventory can fulfill sales. This measure helps to avoid inventory stock-outs and lost sales. |
GMROI |
An assessment of the money earned or lost to the amount of money invested. It indicates a retailer's ability to turn inventory into liquid cash above the cost of the inventory. |
Tot Inv Qty |
Projected owned inventory quantity. |
Tot Inv Retail |
Projected owned inventory retail amount. |
Sell Through Qty |
Ratio of the quantity of goods sold by a retailer to the quantity originally delivered during a period. Promotions or special advertising can help to increase the sell-through quantity. |
Sell Through Retail |
Ratio of the gross sales amount as a fraction of owned inventory for a given time period. |
Clr Out of Stock % |
Percentage of unique items on clearance that were out of stock. |
Reg Out of Stock % |
Percentage of regularly priced unique items that were out of stock as of the last batch run. |
Tot Out of Stock % |
Percentage of regularly priced and promotion unique items that were out of stock as of the last batch run. |
Weeks of Supply last 30 Days |
Number of weeks that current inventory can fulfill sales based on the last thirty days of inventory. This measure helps to avoid inventory stock-outs and lost sales. |
Customer Order Reserved Units |
Customer Order Reserved Units |
Customer Back Order Reserved Units |
Customer Back Order Reserved Units |
EOH Customer Order Reserved Units |
Ending on hand Customer Order Reserved Units |
EOH Customer Back Order Reserved Units |
Ending on hand Customer Back Order Reserved Units |
Wholesale Inventory/Sales Ratio |
Ratio of the number of times owned inventory can fulfill Wholesale sales for a given time period. |
Wholesale Inventory Turns |
Number of times the inventory stock has been turned over during the period. It is calculated by dividing the cost of goods sold by the amount of average Wholesale stock at cost. |
Period Avg Inv Rtl Non-Mean |
Average Inventory retail is used to estimate the retail amount of inventory that retailer has on hand over a period of time. This calculation is based on beginning and ending inventory balances for each week of the period. |
Quarter Avg Inv Rtl Non-Mean |
Average Quarterly Inventory retail is used to estimate the retail amount of inventory that retailer has on hand for a Quarter. This calculation is based on beginning and ending inventory balances for each period of the quarter. |
Period Avg Inv Cost Non-Mean |
Average Inventory Cost is used to estimate the cost of inventory that retailer has on hand over a period of time. This calculation is based on beginning and ending inventory balances for each week of the period. |
Quarter Avg Inv Cost Non-Mean |
Average Quarterly Inventory Cost is used to estimate the cost of inventory that retailer has on hand for a Quarter. This calculation is based on beginning and ending inventory balances for each period of the quarter. |
Weekly Avg Inv Rtl Non-Mean |
Average Inventory retail is used to estimate the retail amount of inventory that retailer has on hand for a week. This calculation is based on beginning inventory balances for the period divided by numbers of weeks of the period. |
Weekly Avg Inv Cost Non-Mean |
Average Inventory cost is used to estimate the cost of inventory that retailer has on hand for a week. This calculation is based on beginning inventory balances for the period divided by numbers of weeks of the period. |
Fiscal Sell Through |
Defined as the quantity of goods that are planned to be sold. This can be derived from total quantity of received goods deducting net sales and adjustments. |
Tot Inv Retail LY |
Projected owned inventory retail amount. |
Table C-10 Retailer to Franchise Metrics
Metric | Definition |
---|---|
Tot Gross Sales Amt |
Retail value of units sold to owned and wholesale/franchise locations. It can be tax inclusive or exclusive, depending on the RMS system option, but is exclusive of discounts. |
Tot Return Amt |
Retail value of units returned from owned and wholesale/franchise locations. It can be tax inclusive or exclusive, depending on the RMS system option, but is exclusive of discounts. |
Tot Net Sales Amt |
Difference of gross sales amount minus return amount for owned and wholesale/franchise locations. |
Tot Gross Sales Qty |
Quantity of units sold to owned and wholesale/franchise locations. |
Tot Return Qty |
Quantity of units returned from owned and wholesale/franchise locations. |
Tot Net Sales Qty |
Difference of gross sales quantity minus return quantity for owned and wholesale/franchise locations. |
Tot Gross Tax |
Tax incurred due to the sales amount for owned and wholesale/franchise locations. |
Tot Return Tax |
Tax incurred due to the return amount for owned and wholesale/franchise locations. |
Tot Net Tax |
Difference of gross tax amount minus return tax amount for owned and wholesale/franchise locations. |
Tot Mkdn Qty |
Markdown units sold at owned and wholesale/franchise locations. |
Tot Mkup Qty |
Marked up units sold at owned and wholesale/franchise locations. |
Tot Gross Sales Amt LY |
Last year's retail value of units sold to owned and wholesale/franchise locations. It can be tax inclusive or exclusive depending on the ORMS system option but is exclusive of discounts. |
Tot Return Amt LY |
Last year's quantity of units returned from owned and wholesale/franchise locations. It can be tax inclusive or exclusive depending on the RMS system option but is exclusive of discounts. |
Tot Net Sales Amt LY |
Last year's difference of gross sales amount minus return amount for owned and wholesale/franchise locations. |
Tot Gross Sales Qty LY |
Last year's quantity of units sold to owned and wholesale/franchise locations. |
Tot Return Qty LY |
Last year's quantity of units returned from owned and wholesale/franchise locations. |
Tot Net Sales Qty LY |
Last year's difference of gross sales quantity minus return quantity for owned and wholesale/franchise locations. |
Tot Gross Tax LY |
Last year's tax incurred due to the sales amount for owned and wholesale/franchise locations. |
Tot Return Tax LY |
Last year's tax incurred due to the return amount for owned and wholesale/franchise locations. |
Tot Net Tax LY |
Last year's difference of gross tax amount minus return tax amount for owned and wholesale/franchise locations. |
Tot Mkdn Qty LY |
Last year's markdown units sold at owned and wholesale/franchise locations. |
Tot Mkup Qty LY |
Last year's marked up units sold at owned and wholesale/franchise locations. |
Tot Gross Sales Amt Var LY |
Gross sales amount variance to last year for owned and wholesale/franchise locations. |
Tot Return Amt Var LY |
Return amount variance to last year for owned and wholesale/franchise locations. |
Tot Net Sales Amt Var LY |
Net sales amount variance to last year for owned and wholesale/franchise locations. |
Tot Gross Sales Qty Var LY |
Gross sales quantity variance to last year for owned and wholesale/franchise locations. |
Tot Return Qty Var LY |
Return quantity variance to last year for owned and wholesale/franchise locations. |
Tot Net Sales Qty Var LY |
Net sales quantity variance to last year for owned and wholesale/franchise locations. |
Tot Gross Tax Var LY |
Gross tax variance to last year for owned and wholesale/franchise locations. |
Tot Return Tax Var LY |
Return tax variance to last year for owned and wholesale/franchise locations. |
Tot Net Tax Var LY |
Net tax variance to last year for owned and wholesale/franchise locations. |
Stockholding Franchise Gross Sales Amt |
This is the retail value of units sold from stockholding franchise locations. It can be tax inclusive or exclusive depending on the ORMS system option but is exclusive of discounts. |
Stockholding Franchise Return Amt |
This is the quantity of units returned from stockholding franchise locations. It can be tax inclusive or exclusive depending on the ORMS system option but is exclusive of discounts. |
Stockholding Franchise Net Sales Amt |
This is the difference of gross sales amount minus return amount for stockholding franchise locations. |
Stockholding Franchise Gross Sales Qty |
This is the quantity of units sold for stockholding franchise locations. |
Stockholding Franchise Return Qty |
This is the quantity of units returned to stockholding franchise locations. |
Stockholding Franchise Gross Sales Amt LY |
This is the retail value of units sold from stockholding franchise locations for the last year. It can be tax inclusive or exclusive depending on the ORMS system option but is exclusive of discounts. |
Stockholding Franchise Return Amt LY |
This is the retail value of units returned from stockholding franchise locations for the last year. It can be tax inclusive or exclusive depending on the ORMS system option but is exclusive of discounts. |
Stockholding Franchise Net Sales Amt LY |
This is the retail value of units returned from stockholding franchise locations for the last year. It can be tax inclusive or exclusive depending on the ORMS system option but is exclusive of discounts. |
Stockholding Franchise Gross Sales Qty LY |
This is the quantity of units sold for stockholding franchise locations for the last year. |
Stockholding Franchise Return Qty LY |
This is the quantity of units returned to stockholding franchise locations for the last year. |
NSF Avg Net Retail |
Average retail price of sold items. |
NSF Gross Sales Amt |
This metric is the retail value of units sold by non-stockholding franchise locations, calculated by adding sale invoices. It includes VAT but excludes discounts. |
NSF Return Amt |
This metric is the retail value of units returned to non-stockholding franchise locations. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
NSF Net Sales Amt |
The sales amount excluding returns for non-stockholding franchise locations. It indicates the actual money amount received from sales. |
NSF Gross Sales Qty |
This metric is the total units of merchandise sold. |
NSF Return Qty |
This metric is the number of units returned to non-stockholding franchise locations. |
NSF Net Sales Qty |
This metric is the difference between gross sales quantity and returns quantity for non-stockholding franchise locations. |
NSF Gross Tax |
Tax applied on total sales revenue. Expenses are not deducted when calculating the tax amount. |
NSF Return Tax |
Taxes that have been accounted on returned merchandise. |
NSF Net Tax |
Taxes payable by a company at the end of fiscal year. It is gross tax less returns tax. |
NSF Restock Fee |
Value of the fee that is charged to wholesale/franchise customers by a retailer for the return of an item. A restock fee can be a flat fee or based on a percentage of the sale. |
NSF Gross Acq Cost |
Weighted average cost at the location that the inventory is being shipped from to wholesale/franchise customers. |
NSF Return Acq Cost |
Weighted average cost at the location that the inventory was being shipped from to wholesale/franchise customers for returned inventory. |
NSF Net Acq Cost |
Difference of gross acquisition cost amount minus return acquisition cost amount for shipped inventory to wholesale/franchise locations. |
NSF Avg Net Retail LY |
Last year's average retail price of sold items. This is calculated by deducting any taxes or expenses. |
NSF Gross Sales Amt LY |
Last year's retail value of units sold, calculated by adding sale invoices. |
NSF Return Amt LY |
This metric is the retail value of units returned to non-stockholding franchise locations. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
NSF Net Sales Amt LY |
Last year's sales amount excluding returns. |
NSF Gross Sales Qty LY |
Last year's retail value of units sold, calculated by adding sale invoices. |
NSF Return Qty LY |
This metric is the number of units returned to non-stockholding franchise locations. |
NSF Net Sales Qty LY |
Last year's difference between gross sales quantity and returns quantity. |
NSF Gross Tax LY |
Last year's tax applied on total sales revenue. |
NSF Return Tax LY |
Last year's taxes that have been accounted on returned merchandise. |
NSF Net Tax LY |
Last year's taxes payable by a company at the end of fiscal year. |
NSF Restock Fee LY |
Value of the fee that is charged to wholesale/franchise customers by a retailer for the return of an item. A restock fee can be a flat fee or based on a percentage of the sale. |
NSF Gross Acq Cost LY |
Last year's weighted average cost at the location that the inventory is being shipped from to wholesale/franchise customers. |
NSF Return Acq Cost LY |
Weighted average cost at the location that the inventory was being shipped from to wholesale/franchise customers for returned inventory. |
NSF Net Acq Cost LY |
Last year's difference of gross acquisition cost amount minus return acquisition cost amount for shipped inventory to wholesale/franchise locations. |
NSF Gross Sales Amt Var LY |
Gross sales amount variance compared to last year for wholesale/franchise locations. |
NSF Return Amt Var LY |
Return amount variance compared to last year for wholesale/franchise locations. |
NSF Net Sales Amt Var LY |
Net sales amount variance compared to last year for wholesale/franchise locations. |
NSF Gross Sales Qty Var LY |
Gross sales quantity variance compared to last year for wholesale/franchise locations. |
NSF Return Qty Var LY |
Return quantity variance compared to last year for wholesale/franchise locations. |
NSF Net Sales Qty Var LY |
Net sales quantity variance compared to last year for wholesale/franchise locations. |
NSF Gross Tax Var LY |
Gross tax variance compared to last year for wholesale/franchise locations. |
NSF Return Tax Var LY |
Return tax variance compared to last year for wholesale/franchise locations. |
NSF Net Tax Var LY |
Net tax variance compared to last year for wholesale/franchise locations. |
Franchise Gross Mkdn Amt |
This is the difference of original retail minus selling price for units sold that were on markdown and were booked at the time of sale to non-stockholding and stockholding franchise locations. |
Franchise Return Mkdn Amt |
This is the difference of original retail minus selling price for units returned that were on markdown and were booked at the time of sale to non-stockholding and stockholding franchise locations. |
Franchise Net Mkdn Amt |
This is the difference of gross markdown amount minus return markdown amount for non-stockholding franchise and stockholding franchise locations. |
Franchise Gross Mkup Amt |
This is the difference of selling price minus original retail for units sold that were on markup and were booked at the time of sale to non-stockholding franchise and stockholding franchise locations. |
Franchise Return Mkup Amt |
This is the difference of selling price minus original retail for units returned that were on markup and were booked at the time of sale to non-stockholding franchise and stockholding franchise locations. |
Franchise Net Mkup Amt |
This is the difference of gross markup amount minus return markup amount for non-stockholding franchise and stockholding franchise locations. |
Franchise Mkdn Qty |
Markdown units sold at a wholesale/franchise location. This includes units on clearance, promotion, and permanent markdown. |
Franchise Mkup Qty |
Marked up units sold at a wholesale/franchise location. |
Franchise Return Mkdn Qty |
Markdowns units returned at the wholesale/franchise location. |
Franchise Return Mkup Qty |
Marked up units returned at the wholesale/franchise location. |
Franchise Gross Mkdn Amt LY |
Last year's difference of original retail minus selling price for units sold that were on markdown and were booked at the time of sale to wholesale/franchise locations. |
Franchise Return Mkdn Amt LY |
Last year's difference of original retail minus selling price for units returned that were on markdown and were booked at the time of sale to wholesale/franchise locations. |
Franchise Net Mkdn Amt LY |
Last year's difference of gross markdown amount minus return markdown amount for wholesale/franchise locations. |
Franchise Gross Mkup Amt LY |
Last year's difference of selling price minus original retail for units sold that were on markup and were booked at the time of sale to wholesale/franchise locations. |
Franchise Return Mkup Amt LY |
Last year's difference of selling price minus original retail for units returned that were on markup and were booked at the time of sale to wholesale/franchise locations. |
Franchise Net Mkup Amt LY |
Last year's difference of gross markup amount minus return markup amount for wholesale/franchise locations. |
Franchise Mkdn Qty LY |
Last year's markdown units sold at a wholesale/franchise location. This includes units on clearance, promotion, and permanent markdown. |
Franchise Mkup Qty LY |
Last year's marked up units sold at a wholesale/franchise location. |
Franchise Return Mkdn Qty LY |
Last year's markdowns units returned at the wholesale/franchise location. |
Franchise Return Mkup Qty LY |
Last year's marked up units returned at the wholesale/franchisee location. |
Franchise Gross Mkdn Amt Var LY |
Gross markdown amount variance compared to last year for wholesale/franchise locations. |
Franchise Return Mkdn Amt Var LY |
Return markdown amount variance compared to last year for wholesale/franchise locations. |
Franchise Net Mkdn Amt Var LY |
Net markdown amount variance compared to last year for wholesale/franchise locations. |
Franchise Gross Mkup Amt Var LY |
Gross markdown amount variance compared to last year for wholesale/franchise locations. |
Franchise Return Mkup Amt Var LY |
Return markup amount variance compared to last year for wholesale/franchise locations. |
Franchise Net Mkup Amt Var LY |
Net markup amount variance compared to last year for wholesale/franchise locations. |
Franchise Mkdn Qty Var LY |
Markdown quantity variance compared to last year for wholesale/franchise locations. Retailers can use this KPI to align overall sales and profitability objectives for wholesale and franchisee locations. |
Franchise Mkup Qty Var LY |
Marked up quantity variance compared to last year for wholesale/franchise locations. Retailers can use this KPI to align overall sales and profitability objectives for wholesale and franchisee locations. |
Franchise Return Mkdn Qty Var LY |
Return markdown quantity variance compared to last year. Retailers can use this KPI to test the alignment of overall quality and return objectives for wholesale and franchisee locations. |
Franchise Return Mkup Qty Var LY |
Return marked up quantity variance compared to last year. Retailers can use this KPI to test the alignment of overall quality and return objectives for wholesale and franchisee locations. |
Table C-11 Price Metrics
Metric | Definition |
---|---|
Price |
Retail value for an item when it is sold in a singular quantity of the selling unit of measure. This metric is aggregated by the AVERAGE function. |
Price LY |
Last year's retail value for an item when it is sold in a singular quantity of the selling unit of measure. This metric is aggregated by the AVERAGE function. |
Price Diff LY |
Difference of this year's price minus last year's price. |
Multi Unit Price |
Retail value for an item when a multiple quantity is sold as a single unit. This metric is aggregated by the AVERAGE function. |
Multi Unit Price LY |
Last year's retail value for an item when a multiple quantity is sold as a single unit. This metric is aggregated by the AVERAGE function. |
Multi Unit Price Diff LY |
Difference of this year's multi-unit price minus last year's multi-unit price. |
Std UOM Price |
Retail value for an item when it is sold in a single quantity of the standard unit of measure. |
Base Cost (Price) |
Primary supplier's initial base cost prior to any deals or discounts for an item/location. This metric is aggregated by the AVERAGE function. |
Base Cost (Price) LY |
Last year's primary supplier's initial base cost prior to any deals or discounts for an item/location. This metric is aggregated by the AVERAGE function. |
Table C-12 Plan Metrics
Metric | Definition |
---|---|
OPC Sales Qty |
Quantity of original merchandise financial plan sales. |
OPC Sales Retail Amt |
Retail value of original merchandise financial plan sales. This is tax inclusive. This is in primary currency. |
OPC Sales Cost Amt |
The cost value of original merchandise financial plan sales. This is tax inclusive. This is in primary currency. |
OPC Tax Retail Amt |
Retail value of original merchandise financial plan tax. This is in primary currency. |
OPC Sales Tax Excluded Retail Amt |
Retail value of original merchandise financial plan sales. This is tax exclusive. This is in primary currency. |
OPC Profit Cost Amt |
Value of original merchandise financial plan gross profit. Gross profit is calculated by the cost accounting method and is the difference of the retail value of sales minus the cost value of sales. This is in primary currency. |
OPC BOH Cost Amt |
The cost value of original merchandise financial plan owned inventory at the beginning of a time period. This is in primary currency. |
OPC BOH Qty |
Quantity of original merchandise financial plan owned inventory at the beginning of a time period. |
OPC EOH Cost Amt |
The cost value of original merchandise financial plan owned inventory at the end of a time period. |
OPC EOH Qty |
Quantity of original merchandise financial plan owned inventory at the end of a time period. |
OPC Receipts Cost Amt |
The cost value of original merchandise financial plan inventory received. This is in primary currency. |
OPC Receipts Qty Amt |
Quantity of original merchandise financial plan inventory received. |
OPC Shrink Cost Amt |
The cost value of original merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. This is in primary currency. |
OPC Shrink Qty |
Quantity of original merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. |
OPC Misc Out Cost Amt |
The cost value of original merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). This is in primary currency. |
OPC Misc Out Qty |
Quantity of original merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). |
OPC Misc In Cost Amt |
The cost value of original merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. This is in primary currency. |
OPC Misc In Cost Qty |
Quantity of original merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. |
OPC Devaluation Cost Amt |
The cost value of original merchandise financial plan devaluation. Devaluation is an adjustment in cost accounting that decreases inventory cost. |
CPC Sales Qty |
Quantity of current merchandise financial plan sales. |
CPC Sales Retail Amt |
Retail value of current merchandise financial plan sales. This is tax inclusive. This is in primary currency. |
CPC Sales Cost Amt |
The cost value of current merchandise financial plan sales. This is tax inclusive. This is in primary currency. |
CPC Tax Retail Amt |
Retail value of current merchandise financial plan tax. This is in primary currency. |
CPC Sales Tax Excluded Retail Amt |
Retail value of current merchandise financial plan sales. This is tax exclusive. This is in primary currency. |
CPC Profit Cost Amt |
Value of current merchandise financial plan gross profit. Gross profit is calculated by the cost accounting method and is the difference of the retail value of sales minus the cost value of sales. This is in primary currency. |
CPC BOH Cost Amt |
The cost value of current merchandise financial plan owned inventory at the beginning of a time period. This is in primary currency. |
CPC BOH Qty |
Quantity of current merchandise financial plan owned inventory at the beginning of a time period. |
CPC EOH Cost Amt |
The cost value of current merchandise financial plan owned inventory at the end of a time period. |
CPC EOH Qty |
Quantity of current merchandise financial plan owned inventory at the end of a time period. |
CPC Receipts Cost Amt |
The cost value of current merchandise financial plan inventory received. This is in primary currency. |
CPC Receipts Qty Amt |
Quantity of current merchandise financial plan inventory received. |
CPC Shrink Cost Amt |
The cost value of current merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. This is in primary currency. |
CPC Shrink Qty |
Quantity of current merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. |
CPC Misc Out Cost Amt |
The cost value of current merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). This is in primary currency. |
CPC Misc Out Qty |
Quantity of current merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). |
CPC Misc In Cost Amt |
The cost value of current merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. This is in primary currency. |
CPC Misc In Cost Qty |
Quantity of current merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. |
CPC Devaluation Cost Amt |
The cost value of current merchandise financial plan devaluation. Devaluation is an adjustment in cost accounting that decreases inventory cost. |
OPR Reg Sales Retail Amt |
Retail value of original merchandise financial plan regular sales. This is tax inclusive. This is in primary currency. |
OPR Pro Sales Retail Amt |
Retail value of original merchandise financial plan promotion sales. This is tax inclusive. This is in primary currency. |
OPR Clr Sales Retail Amt |
Retail value of original merchandise financial plan clearance sales. This is tax inclusive. This is in primary currency. |
OPR Reg Sales Qty |
Quantity of original merchandise financial plan regular sales. |
OPR Pro Sales Qty |
Quantity of original merchandise financial plan promotion sales. |
OPR Clr Sales Qty |
Quantity of original merchandise financial plan clearance sales. |
OPR Tax Retail Amt |
Retail value of original merchandise financial plan tax. This is in primary currency. |
OPR Sales Tax Excluded Retail Amt |
Retail value of original merchandise financial plan sales. This is tax exclusive. This is in primary currency. |
OPR Margin Retail Amt |
Value of original merchandise financial plan gross margin. Gross margin is calculated by the retail accounting method and is the difference of the retail value of sales excluding taxes minus the cost of goods sold. This is in primary currency. |
OPR COGS Cost Amt |
Value of original merchandise financial plan cost of goods sold. This is in primary currency. |
OPR Pmt Mkdn Retail Amt |
Retail value of original merchandise financial plan permanent markdown. Permanent markdown is due to an irrevocable price change that is booked immediately at the corporate level. It is the difference of the original retail minus the selling price. This is in primary currency. |
OPR Pro Mkdn Retail Amt |
Retail value of original merchandise financial plan promotion markdown. Promotion markdown is due to a temporary price change at a location and is booked at the time of the sale. It is the difference of the original retail minus the selling price. This is in primary currency. |
OPR Clr Mkdn Retail Amt |
Retail value of original merchandise financial plan clearance markdown. Clearance markdown is due to a permanent price change that occurs to close out inventory and is booked immediately at the corporate level. It is the difference of the original retail and the selling price. This is in primary currency. |
OPR Mkup Retail Amt |
Retail value of original merchandise financial plan markup. Markup is the difference of the selling price minus the original retail. This is in primary currency. |
OPR BOH Cost Amt |
The cost value of original merchandise financial plan owned inventory at the beginning of a time period. This is in primary currency. |
OPR BOH Retail Amt |
Retail value of original merchandise financial plan owned inventory at the beginning of a time period. This is in primary currency. |
OPR BOH Qty |
Quantity of original merchandise financial plan owned inventory at the beginning of a time period. |
OPR EOH Cost Amt |
The cost value of original merchandise financial plan owned inventory at the end of a time period. |
OPR EOH Retail Amt |
Retail value of original merchandise financial plan owned inventory at the end of a time period. This is in primary currency. |
OPR EOH Qty |
Quantity of original merchandise financial plan owned inventory at the end of a time period. |
OPR Receipts Cost Amt |
The cost value of original merchandise financial plan inventory received. This is in primary currency. |
OPR Receipts Retail Amt |
Retail value of original merchandise financial plan inventory received. This is in primary currency. |
OPR Receipts Qty |
Quantity of original merchandise financial plan inventory received. |
OPR Shrink Retail Amt |
Retail value of original merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. This is in primary currency. |
OPR Shrink Qty |
Quantity of original merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. |
OPR Misc Out Retail Amt |
Retail value of original merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). This is in primary currency. |
OPR Misc Out Qty |
Quantity of original merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). |
OPR Misc In Retail Amt |
Retail value of original merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. This is in primary currency. |
OPR Misc In Qty |
Quantity of original merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. |
CPR Reg Sales Retail Amt |
Retail value of current merchandise financial plan regular sales. This is tax inclusive. This is in primary currency. |
CPR Pro Sales Retail Amt |
Retail value of current merchandise financial plan promotion sales. This is tax inclusive. This is in primary currency. |
CPR Clr Sales Retail Amt |
Retail value of current merchandise financial plan clearance sales. This is tax inclusive. This is in primary currency. |
CPR Reg Sales Qty |
Quantity of current merchandise financial plan regular sales. |
CPR Pro Sales Qty |
Quantity of current merchandise financial plan promotion sales. |
CPR Clr Sales Qty |
Quantity of current merchandise financial plan clearance sales. |
CPR Tax Retail Amt |
Retail value of current merchandise financial plan tax. This is in primary currency. |
CPR Sales Tax Excluded Retail Amt |
Retail value of current merchandise financial plan sales. This is tax exclusive. This is in primary currency. |
CPR Margin Retail Amt |
Value of current merchandise financial plan gross margin. Gross margin is calculated by the retail accounting method and is the difference of the retail value of sales excluding taxes minus the cost of goods sold. This is in primary currency. |
CPR COGS Cost Amt |
Value of current merchandise financial plan cost of goods sold. This is in primary currency. |
CPR Pmt Mkdn Retail Amt |
Retail value of current merchandise financial plan permanent markdown. Permanent markdown is due to an irrevocable price change that is booked immediately at the corporate level. It is the difference of the original retail minus the selling price. This is in primary currency. |
CPR Pro Mkdn Retail Amt |
Retail value of current merchandise financial plan promotion markdown. Promotion markdown is due to a temporary price change at a location and is booked at the time of the sale. It is the difference of the original retail minus the selling price. This is in primary currency. |
CPR Clr Mkdn Retail Amt |
Retail value of current merchandise financial plan clearance markdown. Clearance markdown is due to a permanent price change that occurs to close out inventory and is booked immediately at the corporate level. It is the difference of the original retail minus the selling price. This is in primary currency. |
CPR Mkup Retail Amt |
Retail value of current merchandise financial plan markup. Markup is the difference of the selling price minus the original retail. This is in primary currency. |
CPR BOH Cost Amt |
The cost value of current merchandise financial plan owned inventory at the beginning of a time period. This is in primary currency. |
CPR BOH Retail Amt |
Retail value of current merchandise financial plan owned inventory at the beginning of a time period. This is in primary currency. |
CPR BOH Qty |
Quantity of current merchandise financial plan owned inventory at the beginning of a time period. |
CPR EOH Cost Amt |
The cost value of current merchandise financial plan owned inventory at the end of a time period. |
CPR EOH Retail Amt |
Retail value of current merchandise financial plan owned inventory at the end of a time period. This is in primary currency. |
CPR EOH Qty |
Quantity of current merchandise financial plan owned inventory at the end of a time period. |
CPR Receipts Cost Amt |
The cost value of current merchandise financial plan inventory received. This is in primary currency. |
CPR Receipts Retail Amt |
Retail value of current merchandise financial plan inventory received. This is in primary currency. |
CPR Receipts Qty |
Quantity of current merchandise financial plan inventory received. |
CPR Shrink Retail Amt |
Retail value of current merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. This is in primary currency. |
CPR Shrink Qty |
Quantity of current merchandise financial plan shrinkage. Shrinkage is an inventory event that reduces end of period inventory and may include events such as theft or cycle count adjustments. |
CPR Misc Out Retail Amt |
Retail value of current merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). This is in primary currency. |
CPR Misc Out Qty |
Quantity of current merchandise financial plan miscellaneous out. Miscellaneous out is an inventory event that reduces end of period inventory and may include events such as return to vendor (RTV). |
CPR Misc In Retail Amt |
Retail value of current merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. This is in primary currency. |
CPR Misc In Qty |
Quantity of current merchandise financial plan miscellaneous in. Miscellaneous in is an inventory event that increases end of period inventory and may include events such as store transfers. |
Tot Pmt Mkdn Amt Var CPR% |
Variance of permanent Markdown value of inventory to Current Plan Markdown Retail Amt. |
Tot Pro Mkdn Amt Var CPR% |
Variance of promotional Markdown value of inventory to Current Plan Promotional Markdown Retail Amt. |
Tot Clr Mkdn Amt Var CPR% |
Variance of actual Clearance Markdown value of inventory to Current Plan Clearance Markdown Retail Amt. |
Tot Reg Sales Amt Var CPR% |
Variance of regular Sales Amount to Current Plan Regular Sales Amt. |
Tot Profit Var CP% |
Variance of gross Profit to Current Plan Current Plan Profit Amt. |
Tot Sales Cost Amt Var CP% |
Variance of sales Cost Amt it to Current Plan Sales Cost Amt. |
Tot Sales Qty Var CP% |
Variance of gross Sales Qty it to Current Plan Sales Qty |
Tot Receipts Retail Amt Var CP% |
Variance of receipt Retail Amount it to Current Plan Receipts Retail Amt. |
Tot EOH Inv Retail Amt Var CPR% |
Variance of EOH inventory retail to Current Plan to EOH Retail Amt. |
Tot EOH Inv Cost Amt Var CPR% |
Variance of EOH inventory cost to Current Plan to EOH Cost Amt. |
Planned Monthly Forward Cover |
Planned Monthly Forward Cover is calculated as of BOH Retail for the planned period divided by the average planned promotion, clearance and regular sales amount for weeks of next period. |
Planned Quarterly Forward Cover |
Planned Quarterly Forward cover is calculated as of BOH Retail for a quarter divided by the average of Promotion, Clearance and Regular sales amount for next quarter. |
Monthly Forward Cover LY |
Last Year Monthly Forward Cover is calculated as of last year's BOH Retail for the planned period divided by the average planned promotion, clearance and regular sales amount for weeks of last year next period. |
Quarterly Forward Cover LY |
Last Year Quarterly Forward cover is calculated as BOH Retail LY for a quarter divided by the average of Promotion, Clearance and Regular sales amount for the next quarter. |
Table C-13 Stock Ledger Metrics
Metric | Definition |
---|---|
SL Franchise Mkup Retail |
Extra amount a retailer charges a franchise customer for an item, over and above what the retailer paid the supplier. This is the difference between the selling price and original retail. |
SL Adjusted COGS Cost |
Cost value of the adjustment made to the cost of goods sold (COGS) due to differences in book stock and the physical count of inventory. |
SL Adjusted COGS Retail |
Retail value of the adjustment made to the cost of goods sold (COGS) due to differences in book stock and the physical count of inventory. |
SL BOH Cost |
Cost value of owned inventory units at the beginning of the reporting period. This includes inventory for pack component items. |
SL BOH Retail |
Retail value of owned inventory units at the beginning of the reporting period. This includes inventory for pack component items. |
SL Cash Disc |
Discount credited by vendors. This will increase gross margin. |
SL Clr Mkdn Amt |
Amount of reduction to the original selling price for reasons such as decline in overall prices of goods, excessive competition, special sale, damaged merchandise, or excess supply. |
SL Cost Var Amt |
Used in the cost method of accounting to record the standard cost change as well as the cost difference between standard cost and transaction cost for transactions such as receiving, RTV and transfers. |
SL Deal Income Purchase Amt |
Amount billed back to a supplier from a deal. This is invoiced at the time inventory is purchased. |
SL Deal Income Sales Amt |
Amount billed back to a supplier from a deal. This is invoiced at the time inventory is sold. |
SL Emp Disc |
Retail value of the employee discount incurred due to a sale. This amount is subtracted from the sales amount sub-total to obtain the final sales value. |
SL EOH Cost |
Cost value of owned inventory units at the end of the reporting period. This includes inventory for pack component items. |
SL EOH Retail |
Retail value of owned inventory units at the end of the reporting period. This includes inventory for pack component items. |
SL Freight Cost |
Cost of moving goods from one location to another and may include charges for packing, documenting, loading, unloading, transportation, insurance and other costs. |
SL Freight Claim Cost |
Cost value of lost or damaged freight inventory that is being submitted as a claim to recoup the monetary amount lost. |
SL Freight Claim Retail |
Retail value of lost or damaged freight inventory that is being submitted as a claim to recoup the monetary amount lost. |
SL GAFS Cost |
Cost value of goods available for sale. This is used in the retail method of accounting. |
SL GAFS Retail |
Retail value of goods available for sale. |
SL Gross Profit |
Difference between sales revenue and the cost of units sold. It indicates the retailer's ability to mark up merchandise for sale. |
SL IC Profit |
Change in margin/profit due to an intercompany transfer. This is a result of the price variance between the shipping location and receiving location. |
SL IC Tsf In Cost |
Cost value of merchandise that has been intercompany transferred into a subclass/location. |
SL IC Tsf In Retail |
Retail value of merchandise that has been intercompany transferred into a subclass/location. |
SL IC Tsf Out Cost |
Cost value of merchandise that has been intercompany transferred out of a subclass/location. |
SL IC Tsf Out Retail |
Retail value of merchandise that has been intercompany transferred out of a subclass/location. |
SL Margin Costs Var Amt |
New cost variance using cost method of accounting. |
SL Mkdn Cancelled Amt |
Value of a clearance markdown amount that has been cancelled. |
SL Mkup Amt |
Extra amount a retailer charges a customer for an item, over and above what the retailer paid the supplier. This is the difference between the selling price and original retail. |
SL Mkup Cancelled Amt |
Value of the total markup amount that has been cancelled. A markup cancellation is used to correct an unintentional error in a previous markup. |
SL Pmt Mkdn Amt |
Amount of permanent reduction to the selling price of inventory. This type of markdown is used to remove slow-selling merchandise or replace out-of-date merchandise. |
SL Pro Mkdn Amt |
Amount of temporary reduction to a selling price to boost sales. This markdown is normally for a specified period of time, at the end of which the product price is raised back to the normal selling price. |
SL Receipts Cost |
Cost value of inventory units received. |
SL Receipts Retail |
Retail value of inventory units received. |
SL Reclass In Cost |
Cost value of merchandise that has been reclassified into a subclass/location. |
SL Reclass In Retail |
Retail value of merchandise that has been reclassified into a subclass/location. |
SL Reclass Out Cost |
Cost value of merchandise that has been reclassified out of a subclass/location. |
SL Reclass Out Retail |
Retail value of merchandise that has been reclassified out of a subclass/location. |
SL Restock Fee |
Fee that is charged to a customer for the return of an item. A restock fee can be a flat fee or based on a percentage of the sale. |
SL Return Cost |
Cost value of units returned. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
SL Return Retail |
Retail value of units returned. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
SL RTV Cost |
Cost value of inventory units that have been returned to the vendor. |
SL RTV Retail |
Retail value of inventory units that have been returned to the vendor. |
SL Sales Cost |
Cost value of units sold, calculated by adding sale invoices. It includes VAT but excludes discounts. |
SL Sales Retail |
Retail value of units sold, calculated by adding sale invoices. It includes VAT but excludes discounts. |
SL Sales VAT Exclusive Retail |
Retail value of units sold, calculated by adding sale invoices. It excludes VAT and discounts. |
SL Shrink Cost |
Cost value of inventory lost through means other than a sale. This is the difference between actual physical inventory counts and the amount of inventory reflected in the stock ledger. |
SL Shrink Retail |
Retail value of inventory lost through means other than a sale. This is the difference between actual physical inventory counts and the amount of inventory reflected in the stock ledger. |
SL SOH Adjusted Retail |
Retail value of an adjustment to stock on hand due to differences in book stock and the physical count of inventory. |
SL Tsf In Cost |
Cost value of merchandise that has been transferred into a subclass/location. |
SL Tsf In Retail |
Retail value of merchandise that has been transferred into a subclass/location. |
SL Tsf Out Cost |
Cost value of merchandise that has been transferred out of a subclass/location. |
SL Tsf Out Retail |
Retail value of merchandise that has been transferred out of a subclass/location. |
SL Upcharge Expense |
Cost incurred by the origin location to transfer merchandise to another location. |
SL Upcharge Profit |
Profit gained from an up charge due to an intercompany transfer. |
SL WO Post Fin Cost |
Cost value of merchandise required work order activity - post to financial for intercompany transfers. |
SL WO Update Inv Cost |
Cost value of merchandise required work order activity - update inventory for intercompany transfers. |
SL Workroom Cost |
Cost of value added services to make merchandise available for sale. |
SL Franchise Mkdn Retail |
Amount of reduction to the selling price of inventory for a franchise customer. |
SL Franchise Restock Fee |
Fee that is charged to franchise/franchise customers by a retailer for the return of an item. A restock fee can be a flat fee or based on a percentage of the sale. |
SL Franchise Return Cost |
Cost value of units returned from a franchise location. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
SL Franchise Return Retail |
Retail value of units returned from a franchise location. It Indicates lost revenue that is credited back to customers. Retailers should find opportunities to convert this to new sales. |
SL Franchise Sales Cost |
Cost value of units sold to franchise locations, calculated by adding sale invoices. It includes VAT but excludes discounts. |
SL Franchise Sales Retail |
Retail value of units sold to franchise locations, calculated by adding sale invoices. It includes VAT but excludes discounts. |
SL IC Mkdn Amt |
Reduction in price due to an intercompany transfer. This occurs when the shipping location price is greater than the receiving location price. |
SL IC Mkup Amt |
Increase in price due to an intercompany transfer. This occurs when the shipping location price is lesser than the receiving location price. |
SL Tsf In Book Cost |
Cost value of merchandise that has been book transferred into a subclass/location. |
SL Tsf In Book Retail |
Retail value of merchandise that has been book transferred into a subclass/location. |
SL Tsf Out Book Cost |
Cost value of merchandise that has been book transferred out of a subclass/location. |
SL Tsf Out Book Retail |
Retail value of merchandise that has been book transferred out of a subclass/location. |
SL VAT In |
Input VAT which is VAT charged by a supplier to the retailer. |
SL VAT Out |
Output VAT which is VAT charged by a business to a customer. |
SL Weight Var Retail |
Retail variance due to variance in weight for catchweight items. |
SL Cum Mkon Pct |
Amount added to the cost to determine the selling price and is stated as a fraction of the selling price. This is used in the retail method of accounting. |
SL Gross Sales Qty |
Total units of merchandise sold. |
Table C-14 Dimension Metrics
Metric | Definition |
---|---|
Item Count |
This is a count of unique items on a sales transaction. If multiple quantities of an item are purchased, the item will be counted only once. |
Item OOS Count |
This is the count of all items which are out of stock. This metrics is used to derive other metrics. |
Table C-15 Affinity Metrics
Metric | Definition |
---|---|
% Support for Rule |
Given an association rule such that if X then Y, Support is the frequency in which, out of all transactions, that the customer purchased both X and Y. |
Rule Confidence |
Given an association rule such that if X then Y, Confidence is the estimated probability that Y will be purchased in the same transactions where a customer has purchased X, expressed as a percentage. |
Affinity Reverse Confidence |
Given an association rule such that if X then Y, Reverse Confidence is the estimated probability that X will be purchased in the same transactions where a customer has purchased Y, expressed as a percentage. |
% Market Basket Sales |
The percentage of sales the items on the given association rules contributed to total sales for a specified time period. |
Total Basket Sales Value |
The total revenue for all items, in all transactions which were mined. |
Antecedent Sales Value |
The revenue generated by IF items on the given association rules. |
Antecedent Sales Qty |
The units sold from IF subclasses on the given association rules. |
Target Sales Value |
The revenue generated by THEN items on the given association rules. |
Avg Sales per Affinity MB |
The average revenue for all items in a given association rule, for the transactions where a customer has purchased all the items of the rule. |
Avg Profit per Affinity MB |
The average profit for all items in a given association rule, for the transactions where a customer has purchased all the items of the rule. |
Avg Qty per Affinity MB |
The average number of units sold of all the items in a given association rule, for the transactions where a customer has purchased all the items of the rule. |
MB Total Trx Count |
Count of transactions which were mined. |
Total Trx Count |
Count of transactions regardless of mining. |
Rule Trx Count |
Count of transactions in which the customer has purchased all the items of the rule. |
Avg Weekly Basket Sales Value |
The average weekly sales value from IF and THEN components. This metric is calculated based on all transactions that contained the specified rule, for the period and location that was mined. |
Avg Weekly Target Sales Value |
The average weekly sales value of THEN components. This metric is calculated based on all transactions that contained the specified rule, for the period and location that was mined. |
Antecedent Profit |
The sum of profit for the IF components of the rule, from transactions which contain the rule. |
Target Profit |
The sum of profit for the THEN components of the rule, from transactions which contain the rule. |
MB Total Profit |
The sum of profit for both the IF and THEN components of the rule, from transactions which contain the rule. |
Total Profit |
The sum of profit from all transactions regardless of mining. |
Avg MB Unit Qty |
Average basket size of transactions that were mined, expressed as number of units per transaction. |
Basket Component Count |
Count of items that participate in the rule definition, inclusive of items in the IF and THEN side of the rule. |
Table C-16 Customer Metrics
Metric | Definition |
---|---|
% Pro Discount Amt by Sales |
This is a ratio of Pro Discount Amount to Total Sales for a specific customer segment, geography, RFM score, or gender. |
Avg Gross Profit per Basket |
This is an average across all transactions of the Gross Profit Amount fact column for the relevant time frame of the report. It is important to have Customer Type available for this metric. |
Avg Gross Sales per Basket |
This is an average across all transactions for the customers in specific geography, or segment, as grouped together by the template, of the Gross Sales Amount fact column for the relevant time frame of the report. |
Avg Item Count per Basket (by Cust Type) |
Average items per market basket for a specific customer type.Calculated by number of items divided by number of transactions, in other words: count (item)/count (distinct transactions). |
Avg Net Sales per Basket |
This is an average across all transactions of the Net Sales Amount fact column for the relevant time frame of the report. |
Avg Sales Amount per Customer |
Average sales amount per customer. |
Avg Sales Quantity per Customer |
Average sales quantity per customer. |
Avg Trx Count per Customer |
Average transaction count per customer. |
Known Customer Count |
Count of unique customers. |
Segment Percent Return Amount |
This is a ratio of Return Amount to Total Sales for a specific customer segment or geography. |
Total Trx |
Total Transactions is the total number of transactions carried out at a retailer's stores by all customers. |
Trx % to Total Trx (by Cust Type) |
Transaction for a specific customer type as a ratio of all the transactions. This is calculated by (Trxn for customer type/total transactions)*100. |
Table C-17 Promotion Metrics
Metric | Definition |
---|---|
Pro Campai.gn Cost |
Actual cost incurred to execute a promotion campaign. |
Fcst Pro Sales Amt |
Value of promotion sales that have been forecast for the given timeframe. |
Fcst Pro Sales Qty |
Quantity of promotion sales units that have been forecast for the given timeframe. |
Fcst Pro Gross Profit |
Forecasted gross profit from promotion sales. |
Fcst Gross Pro Profit to Fcst Sales Amt % |
Ratio of promotion profit achieved on total promotion sales. The ratio reflects a company's ability to balance its costs with sales. It is a key performance indicator of a company's efficiency and performance. |
Fcst Pro Trx Count |
Count of forecast sales transactions that contain promoted items. |
Fcst Pro Disc |
Forecast discount from promotion sales. |
Fcst Pro Loc Count |
Count of forecast stores yielding promotion sales. |
Fcst Pro Count |
Count of forecast promotions for the given timeframe. |
Pro Sales Amt Var Fcst Sales % |
Gross promotion sales amount variance compared to the forecast promotion sales. |
Pro Sales Unit Var Fcst % |
Gross promotion sales quantity variance compared to the forecast promotion quantity. |
Pro Gross Profit Var Fcst % |
Gross promotion profit variance compared to the forecast promotion profit. |
Pro Trx Var Fcst % |
Gross promotion sales transaction count variance compared to the forecast promotion sales transaction count. |
Pro Disc Amt Var Fcst % |
Gross promotion discount variance compared to the forecast promotion discount. |
Pro Campaign Budget Requested |
Amount of budget requested to execute a promotion campaign. |
Pro Campaign Budget Assigned |
Amount of budget granted to exeute a promotion campaign. |
Pro Campaign Budget Var Cost |
Promotion campaign assigned budget variance compared to the actual cost of executing the promotion campaign. |
Pro Campaign Budget Var Requested |
Promotion campaign assigned budget variance compared to the requested budget |
Pro Campaign Requested Var Cost |
Promotion campaign requested budget variance compared to the actual cost of executing the promotion campaign. |
Pro Days Count |
Number of days an item is on promotion. |
Pro Sales % to Total Sales |
Promotion sales amount as a percentage of total sales. |
Baseline Sales Amt |
Estimated baseline sales value generated by the promotion item before and after the promotion period. |
Baseline Qty |
Estimated baseline units of advertised items in offer during the advertisement period. |
Baseline Profit |
Estimated baseline profit generated by the advertised item during the advertisement period. |
Sales Lift to Sales Fcst Qty% |
Incremental sales amount as a percent of forecast sales amount. |
Sales Lift to Pro Fcst % |
Incremental sales amount as a percent of actual promotion sales amount. |
Sales Lift Amt |
Additional sales value generated by an item as a result of an advertisement event, compared with the estimated baseline sales value. |
Sales Lift Amt % |
Sales lift value as a percentage of baseline sales value. |
Incremental Profit |
Additional profit during an advertisement event of the promoted item, plus additional profit generated by non-promoted items allocated to the advertised item, compared to estimated baseline profit. |
Incremental Profit Lift % |
Promotion profit by an advertised item against baseline profit, the percentage change in profit over baseline due to an advertisement event. |
Sales Lift Qty |
Additional sales units generated by an item as a result of an advertisement event, compared with the estimated baseline sales units. |
Sales Lift Qty % |
Sales lift units as a percentage of baseline sales units. |
Item Baseline Count |
Estimated count of baseline transactions that contain the item during the period of baseline weeks used for that promotion event. |
Incr Item Count |
Variance between Item Baseline Count and the average transaction count during the period of baseline weeks used for that promotion event. |
Item Promo Count Lift |
Count of item promotion transactions compared to estimated baseline transactions, giving a percentage change in promotion count over baseline due to a promotion event. |
Sales Lift to Pro Sales% |
Incremental sales amount as a percent of actual promotion sales amount. |
Item Promo Lift Count |
Count of item promo transactions compared to estimated baseline transactions, giving a percentage change in promo count over baseline due to promo event. |
Table C-18 Trial and Repeat Metrics
Metric | Definition |
---|---|
Trial Count |
Count of distinct purchases by Customer Household and day, for the first time a customer buys the item in the time frame requested on the report. All those household counts are summed into this ”Trial Purchase Count”. |
Repeat 1 Count |
Count of first repeat purchase by Customer Household, for the first time a customer buys the item in the time frame requested on the report, after the trial purchase. All those household counts are summed into this ”Repeat 1 Count”. |
Repeat 2 Count |
Count of second repeat purchase by Customer Household, for the second time a customer buys the item in the time frame requested on the report, after the trial purchase. All those household counts are summed into this ”Repeat 2 Count”. |
Repeat 3 Count |
Count of third repeat purchase by Customer Household, for the third time a customer buys the item in the time frame requested on the report, after the trial purchase. All those household counts are summed into this ”Repeat 3 Count”. |
Repeat 4 Count |
Count of fourth repeat purchase by Customer Household, for the fourth time a customer buys the item in the time frame requested on the report, after the trial purchase. All those household counts are summed into this ”Repeat 4 Count”. |
Repeat 5+ Count |
Count of fifth and greater repeat purchase by Customer Household, for the fifth or greater time a customer buys the item in the time frame requested on the report, after the trial purchase. All those household counts are summed into this ”Repeat 5+ Count”. |
Table C-19 Offer Metrics
Metric | Definition |
---|---|
Total Offers Count |
Count of unique offers sent to various customers for a specific promotion component. |
Redeemed Offer Count |
Count of distinct transactions attributed to the promotion component. This indicates reach of this promotion component. |
Offer Redemption Rate |
This is actual redemption rate, based on sales transactions flagged as having a promotion discount. |
Offer Redemption Rate Var Fcst% |
Represents the difference between the actual and forecasted rate as of the as a percentage of the forecasted rate. |
Table C-20 Customer Order Metrics
Metric | Definition |
---|---|
CO Reserved Units |
This metric is the inventory units that are currently approved for transfer between two locations. |
CO Backorder Reserved Units |
This metric is the inventory units that are currently approved for transfer between two locations and are in backorder status. |
CO EOH Reserved Units |
This metric is the ending on hand inventory that is currently approved for transfer between two locations. |
CO EOH Backorder Reserved Units |
This metric is the ending on hand inventory that is currently approved for transfer between two locations and is in backorder status. |
CO Demand Qty |
This metric is the number of customer order units. |
CO Demand Qty LW |
This metric is the number of customer order units for last week. |
CO Demand Qty LY |
This metric is the number of customer order units for last year. |
CO Demand Qty WTD |
This metric is the customer order units for week-to-date. |
CO Demand Qty MTD |
This metric is the customer order units for month-to-date. |
CO Demand Qty QTD |
This metric is the customer order units for quarter-to-date. |
CO Demand Qty YTD |
This metric is the customer order units for year-to-date. |
CO Demand Qty LY WTD |
This metric is the customer order units for last year week-to-date. |
CO Demand Qty LY MTD |
This metric is the customer order units for the last year month-to-date. |
CO Demand Qty LY QTD |
This metric is the customer order units for last year quarter-to-date. |
CO Demand Qty LY YTD |
This metric is the customer order units for last year year-to-date. |
CO Demand Retail Amt |
This metric is the retail value of the customer order. |
CO Demand Retail Amt LW |
This metric is the retail value of the customer order for last week. |
CO Demand Retail Amt LY |
This metric is the retail value of the customer order for last year. |
CO Demand Retail Amt WTD |
This metric is the retail value of the customer order items for week to date. |
CO Demand Retail Amt MTD |
This metric is the customer order quantity retail value for month-to-date. |
CO Demand Retail Amt QTD |
This metric is the customer order quantity retail value for quarter-to-date. |
CO Demand Retail Amt YTD |
This metric is the customer order quantity retail value for year-to-date. |
CO Demand Retail Amt LY WTD |
This metric is the customer order quantity retail value for last year week-to-date. |
CO Demand Retail Amt LY MTD |
This metric is the customer order quantity retail value for last year month-to-date. |
CO Demand Retail Amt LY QTD |
This metric is the customer order quantity retail value for last year quarter-to-date. |
CO Demand Retail Amt LY YTD |
This metric is the customer order quantity retail value for last year year-to-date. |
CO Demand Cost Amt |
This metric is the customer order cost amount. |
CO Demand Cost Amt LW |
This metric is the customer order cost amount for last week. |
CO Demand Cost Amt LY |
This metric is the customer order cost amount for last year. |
CO Demand Cost Amt WTD |
This metric is the customer order cost amount for week-to-date. |
CO Demand Cost Amt MTD |
This metric is the customer order cost amount for month-to-date. |
CO Demand Cost Amt QTD |
This metric is the customer order cost amount for quarter-to-date. |
CO Demand Cost Amt YTD |
This metric is the customer order cost amount for year-to-date. |
CO Demand Cost Amt LY WTD |
This metric is the customer order cost amount for last year week-to-date. |
CO Demand Cost Amt LY MTD |
This metric is the customer order cost amount for last year month-to-date. |
CO Demand Cost Amt LY QTD |
This metric is the customer order cost amount for last year quarter-to-date. |
CO Demand Cost Amt LY YTD |
This metric is the customer order cost amount for last year year-to-date. |
CO Demand Profit |
This metric is the profit amount of the customer order |
CO Demand Profit LW |
This metric is the profit amount of the customer order quantity for last week. |
CO Demand Profit LY |
This metric is the profit amount of the customer order quantity for last week last year. |
CO Demand Profit WTD |
This metric is the profit amount of the customer order quantity for week-to-date. |
CO Demand Profit MTD |
This metric is the profit amount of the customer order quantity for month-to-date. |
CO Demand Profit QTD |
This metric is the profit amount of the customer order quantity for quarter-to-date. |
CO Demand Profit YTD |
This metric is the profit of the order for demand quantity for year-to-date. |
CO Demand Profit LY WTD |
This metric is the profit amount of customer orders for last year week-to-date. |
CO Demand Profit LY MTD |
This metric is the profit amount of customer orders for last year month-to-date. |
CO Demand Profit LY QTD |
This metric is the profit amount of customer orders for last year quarter-to-date. |
CO Demand Profit LY YTD |
This metric is the profit amount of customer orders for last year year-to-date. |
CO Demand Profit Var LW |
This metric is the variance of the profit amount of customer orders compared to last week. |
CO Demand Profit Var LY |
This metric is the variance in profit amount of customer orders compared to last year. |
CO Demand Profit WTD Var LY WTD |
This metric is the variance of week-to-date profit amount of customer orders compared to last year week-to-date. |
CO Demand Profit MTD Var LY MTD |
This metric is the variance of month-to-date profit amount of customer orders compared to last year month-to-date. |
CO Demand Profit QTD Var LY QTD |
This metric is the variance quarter-to-date profit amount of customer orders compared to last year, quarter-to-date. |
CO Demand Profit YTD Var LY YTD |
This metric is the variance of year-to-date profit amount of customer order compared to last year, year-to-date. |
CO EOP Reserve Qty |
This metric is the reserved units at the end of a period. |
CO Reserve Qty |
This metric is the number of reserved customer order units. |
CO Reserve Qty LW |
This metric is the number of reserved customer order units for last week. |
CO Reserve Qty LY |
This metric is the customer order reserve units for last year. |
CO EOP Reserve Retail Amt |
This metric is the customer order reserve units' retail value at the end of a period. |
CO Reserve Retail Amt |
This metric is the customer order reserve units' retail value. |
CO Reserve Retail Amt LW |
This metric is the customer order reserve units' retail value for the last week. |
CO Reserve Retail Amt LY |
This metric is the customer order reserve units' retail value for last year. |
CO EOP Reserve Cost Amt |
This metric is the customer order reserved units' cost value at the end of a period. |
CO Line Reserve Cost Amt |
This metric is the customer order reserved units' cost value at the order line level. |
CO Reserve Cost Amt |
This metric is the customer order reserved units' cost value. |
CO Reserve Cost Amt LW |
This metric is the customer order reserve units' cost value for last week. |
CO Reserve Cost Amt LY |
This metric is the customer order reserve units' cost value for last year. |
CO EOP Pick Qty |
This metric is the customer order picked units for the end of a period. |
CO Pick Qty |
This metric is the customer order picked units. |
CO Pick Qty LW |
This metric is the customer order picked units for last week. |
CO Pick Qty LY |
This metric is the customer order picked units for last year. |
CO EOP Pick Retail Amt |
This metric is the customer order picked units' retail value at the end of a period. |
CO Pick Retail Amt |
This metric is the customer order picked units' retail value. |
CO Pick Retail Amt LW |
This metric is the customer order picked units' retail value for last week. |
CO Pick Retail Amt LY |
This metric is the customer order picked units' retail value for last year. |
CO EOP Pick Cost Amt |
This metric is the customer order picked units' cost at the end of period. |
CO Pick Cost Amt |
This metric is the customer order picked units' cost value. |
CO Pick Cost Amt LW |
This metric is the customer order picked units' cost value for last week. |
CO Pick Cost Amt LY |
This metric is the customer order picked units' cost value for last year. |
CO EOP Backorder Qty |
This metric is the customer order backorder units at the end of period. |
CO Backorder Qty |
This metric is the customer order backorder units. |
CO Backorder Qty LW |
This metric is the customer order backorder units for last week. |
CO Backorder Qty LY |
This metric is the customer order backorder units for last year. |
CO Backorder Qty WTD |
This metric is the customer order backorder units for week-to-date. |
CO Backorder Qty MTD |
This metric is the customer order backorder units for month-to-date. |
CO Backorder Qty QTD |
This metric is the customer order backorder units for quarter-to-date. |
CO Backorder Qty YTD |
This metric is the customer order backorder units for year-to-date. |
CO Backorder Qty LY WTD |
This metric is the customer order backorder units last year week-to-date. |
CO Backorder Qty LY MTD |
This metric is the customer order backorder units last year month-to-date. |
CO Backorder Qty LY QTD |
This metric is the customer order backorder units for last year quarter-to-date. |
CO Backorder Qty LY YTD |
This metric is the customer order backorder units last year year-to-date. |
CO EOP Backorder Retail Amt |
This metric is the retail value of customer order backorder units at the end of a period. |
CO Backorder Retail Amt |
This metric is the retail value of customer order backorder units. |
CO Backorder Retail Amt LW |
This metric is the retail value of customer order backorder units for last week. |
CO Backorder Retail Amt LY |
This metric is the retail value of customer order backorder units for last year. |
CO Backorder Retail Amt WTD |
This metric is the retail value of customer order backorder units for week-to-date. |
CO Backorder Retail Amt MTD |
This metric is the retail value of customer order backorder units for month-to-date. |
CO Backorder Retail Amt QTD |
This metric is the retail value of customer order backorder units for quarter-to-date. |
CO Backorder Retail Amt YTD |
This metric is the retail value of customer order backorder units for year-to-date. |
CO Backorder Retail Amt LY WTD |
This metric is the retail value of customer order backorder units for last year week-to-date. |
CO Backorder Retail Amt LY MTD |
This metric is the retail value of customer order backorder units for last year month-to-date. |
CO Backorder Retail Amt LY QTD |
This metric is the retail value of customer order backorder units for last year quarter-to-date. |
CO Backorder Retail Amt LY YTD |
This metric is the retail value of customer order backorder units for last year year-to-date. |
CO EOP Backorder Cost Amt |
This metric is the cost value of customer order backorder units at the end of a period. |
CO Backorder Cost Amt |
This metric is the cost value of customer order backorder units. |
CO Backorder Cost Amt LW |
This metric is the cost value of customer order backorder units for last week. |
CO Backorder Cost Amt LY |
This metric is the cost value of customer order backorder units for last year. |
CO Backorder Cost Amt WTD |
This metric is the cost value of customer order backorder units for week-to-date. |
CO Backorder Cost Amt MTD |
This metric is the cost value of customer order backorder units for month-to-date. |
CO Backorder Cost Amt QTD |
This metric is the cost value of customer order backorder units for quarter-to-date. |
CO Backorder Cost Amt YTD |
This metric is the cost value of customer order backorder units for year-to-date. |
CO Backorder Cost Amt LY WTD |
This metric is the cost value of customer order backorder units for last year week-to-date. |
CO Backorder Cost Amt LY MTD |
This metric is the cost value of customer order backorder units for last year month-to-date. |
CO Backorder Cost Amt LY QTD |
This metric is the cost value of customer order backorder units for last year quarter-to-date. |
CO Backorder Cost Amt LY YTD |
This metric is the cost value of customer order backorder units for last year year-to-date. |
CO Demand Line Ct |
This metric is the count of distinct customer order lines. |
CO Demand Order Ct |
This metric is the count of distinct customer orders. |
CO Avg Lines |
This metric is the average number of lines per customer order. |
CO Avg Lines LY |
This metric is the average number of lines per customer order for last year. |
CO Line Avg order qty |
This metric is the average number of items per customer order line. |
CO Line Avg order qty LY |
This metric is the average number of items per customer order line for last year. |
CO Avg order qty |
Average ordered qty per customer order. |
CO Avg order qty LY |
Average ordered qty per customer order last year. |
CO Line Avg Retail Amt |
This metric is the average retail amount per customer order line. |
CO Line Avg Retail Amt LY |
This metric is the average retail amount per customer order line for last year. |
CO Avg Demand Retail Amt |
This metric is the average retail value of all customer orders. |
CO Avg Demand Retail Amt LY |
This metric is the average retail value of all customer orders for last year. |
CO Line Avg Cost Amt |
This metric is the average cost value of all customer order lines. |
CO Line Avg Cost Amt LY |
This metric is the average cost value of all customer order lines for last year. |
CO Avg Demand Cost Amt |
This metric is the average cost value of all customer orders. |
CO Avg Demand Cost Amt LY |
This metric is the average cost value of all customer orders for last year. |
CO Tax Amt |
This metric is the customer order tax amount. |
CO Disc Amt |
This metric is the discount given to the customer at the customer order level. This discount amount excludes promotional discounts. |
CO Promo Disc Amt |
This metric is the customer order promotional discount amount. |
CO Tender Amt |
This metric is the amount the customer paid for the order, after all discounts and offers have been accounted for. |
CO Cancel Tax Amt |
This metric is the tax amount from the original sale that was returned to the customer after the order was canceled. |
CO Line Promo Amt |
This metric is the retail amount of the customer order line that was purchased on promotion. |
CO Line Promo Amt LW |
This metric is the retail amount of the customer order line that was purchased on promotion for last week. |
CO Line Promo Amt LY |
This metric is the retail amount of the customer order line that was purchased on promotion for last year. |
CO Line Promo Amt WTD |
This metric is the retail amount of the customer order line that was purchased on promotion for week-to-date. |
CO Line Promo Amt MTD |
This metric is the retail amount of the customer order line that was purchased on promotion for month-to-date. |
CO Line Promo Amt YTD |
This metric is the retail amount of the customer order line that was purchased on promotion for year-to-date. |
CO Line Promo Amt LY WTD |
This metric is the retail amount of the customer order line that was purchased on promotion for last year week-to-date. |
CO Line Promo Amt LY MTD |
This metric is the retail amount of the customer order line that was purchased on promotion for last year month-to-date. |
CO Line Promo Amt LY YTD |
This metric is the retail amount of the customer order line that was purchased on promotion last year year-to-date. |
CO Promo Amt |
This metric is the retail amount of the customer order that was purchased on promotion. |
CO Promo Amt LW |
This metric is the retail amount of the customer order that was purchased on promotion for last week. |
CO Promo Amt LY |
This metric is the retail amount of the customer order that was purchased on promotion for last year. |
CO Promo Amt WTD |
This metric is the retail amount of the customer order that was purchased on promotion for week-to-date. |
CO Promo Amt MTD |
This metric is the retail amount of the customer order that was purchased on promotion for month-to-date. |
CO Promo Amt YTD |
This metric is the retail amount of the customer order that was purchased on promotion for year-to-date. |
CO Promo Amt LY WTD |
This metric is the retail amount of the customer order that was purchased on promotion for last year week-to-date. |
CO Promo Amt LY MTD |
This metric is the retail amount of the customer order that was purchased on promotion for last year month-to-date. |
CO Promo Amt LY YTD |
This metric is the retail amount of the customer order that was purchased on promotion for last year year-to-date. |
CO Demand Clr Amt |
This metric is the retail amount of the customer order that was purchased on clearance. |
CO Demand Clr Amt LW |
This metric is the retail amount of the customer order that was purchased on clearance for last week. |
CO Demand Clr Amt LY |
This metric is the retail amount of the customer order that was purchased on clearance for last year. |
CO Demand Clr Amt WTD |
This metric is the retail amount of the customer order that was purchased on clearance for week-to-date. |
CO Demand Clr Amt MTD |
This metric is the retail amount of the customer order that was purchased on clearance for month-to-date. |
CO Demand Clr Amt YTD |
This metric is the retail amount of the customer order that was purchased on clearance for year-to-date. |
CO Demand Clr Amt LY WTD |
This metric is the retail amount of the customer order that was purchased on clearance for last year week-to-date. |
CO Demand Clr Amt LY MTD |
This metric is the retail amount of the customer order that was purchased on clearance for last year month-to-date. |
CO Demand Clr Amt LY YTD |
This metric is the retail amount of the customer order that was purchased on clearance for last year year-to-date. |
CO Line Promo Mkdn Amt |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line. |
CO Line Promo Mkdn Amt LW |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for last week. |
CO Line Promo Mkdn Amt LY |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for last year. |
CO Line Promo Mkdn Amt WTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for week-to-date. |
CO Line Promo Mkdn Amt MTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for month-to-date. |
CO Line Promo Mkdn Amt YTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for year-to-date. |
CO Line Promo Mkdn Amt LY WTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for last year week-to-date. |
CO Line Promo Mkdn Amt LY MTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for last year month-to-date. |
CO Line Promo Mkdn Amt LY YTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order line for last year year-to-date. |
CO Promo Mkdn Amt |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order. |
CO Promo Mkdn Amt LW |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for last week. |
CO Promo Mkdn Amt LY |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for last year. |
CO Promo Mkdn Amt WTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for week-to-date. |
CO Promo Mkdn Amt MTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for month-to-date. |
CO Promo Mkdn Amt YTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for year-to-date. |
CO Promo Mkdn Amt LY WTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for last year week-to-date. |
CO Promo Mkdn Amt LY MTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for last year month-to-date. |
CO Promo Mkdn Amt LY YTD |
This metric is the difference between the original selling price and the actual selling price due to a promotion on the customer order for last year year-to-date. |
CO Line Promo Mkdn to Promo Amt |
This metric is an indication of how large a markdown was required on an order line item to generate the total promotional sales for that item. In general, the smaller the number for this metric the better for the retailer, as it means a small markdown amount generated a large amount of promotional sales. |
CO Line Promo Mkdn To Promo Amt LY |
This metric is an indication of how large a markdown was required on an order line item to generate the total promotional sales for that item for last year. In general the smaller the number for this metric the better for the retailer, as it means a small markdown amount generated a large amount of promotional sales. |
CO Promo Mkdn To Promo Amt |
This metric is an indication of how large a markdown was required on a customer order to generate the total promotional sales amount. In general the smaller the number for this metric the better for the retailer, as it means a small markdown amount generated a large amount of promotional sales. |
CO Promo Mkdn To Promo Amt LY |
This metric is an indication of how large a markdown was required on a customer order to generate the total promotional sales for last year. In general the smaller the number for this metric the better for the retailer, as it means a small markdown amount generated a large amount of promotional sales. |
CO Line Promo Qty |
This metric is the number of customer order line units that were sold on promotion. |
CO Line Promo Qty LW |
This metric is the number of customer order line units that were sold on promotion for last week. |
CO Line Promo Qty LY |
This metric is the number of customer order line units that were sold on promotion for last year. |
CO Line Promo Qty WTD |
This metric is the number of customer order line units that were sold on promotion for week-to-date. |
CO Line Promo Qty MTD |
This metric is the number of customer order line units that were sold on promotion for month-to-date. |
CO Line Promo Qty YTD |
This metric is the number of customer order line units that were sold on promotion for year-to-date. |
CO Line Promo Qty LY WTD |
This metric is the number of customer order line units that were sold on promotion for last year week-to-date. |
CO Line Promo Qty LY MTD |
This metric is the number of customer order line units that were sold on promotion for last year month-to-date. |
CO Line Promo Qty LY YTD |
This metric is the number of customer order line units that were sold on promotion for last year year-to-date. |
CO Promo Qty |
This metric is the number of customer order units that were sold on promotion. |
CO Promo Qty LW |
This metric is the number of customer order units that were sold on promotion for last week. |
CO Promo Qty LY |
This metric is the number of customer order units that were sold on promotion for last year. |
CO Promo Qty WTD |
This metric is the number of customer order units that were sold on promotion for week-to-date. |
CO Promo Qty MTD |
This metric is the number of customer order units that were sold on promotion for month-to-date. |
CO Promo Qty YTD |
This metric is the number of customer order units that were sold on promotion for year-to-date. |
CO Promo Qty LY WTD |
This metric is the number of customer order units that were sold on promotion for last year week-to-date. |
CO Promo Qty LY MTD |
This metric is the number of customer order units that were sold on promotion for last year month-to-date. |
CO Promo Qty LY YTD |
This metric is the number of customer order units that were sold on promotion for last year year-to-date. |
CO Clr Qty |
This metric is the number of customer order units sold on clearance. |
CO Clr Qty LW |
This metric is the number of customer order units sold on clearance for last week. |
CO Clr Qty LY |
This metric is the number of customer order units sold on clearance for last year. |
CO Clr Qty WTD |
This metric is the number of customer order units sold on clearance for week-to-date. |
CO Clr Qty MTD |
This metric is the number of customer order units sold on clearance for month-to-date. |
CO Clr Qty YTD |
This metric is the number of customer order units sold on clearance for year-to-date. |
CO Clr Qty LY WTD |
This metric is the number of customer order units sold on clearance for last year week-to-date. |
CO Clr Qty LY MTD |
This metric is the number of customer order units sold on clearance for last year month-to-date. |
CO Clr Qty LY YTD |
This metric is the number of customer order units sold on clearance for last year year-to-date. |
CO Shipped Complete Qty |
This metric is the number of customer orders in which the shipped quantity was the same as the ordered quantity. |
CO Line Fill Rate % |
This metric is the number of lines that were shipped complete compared to the total number of lines ordered in a customer order. |
CO SKU Fill Rate % |
This metric is the quantity that was shipped complete compared to the total quantity ordered in a customer order. |
CO Demand Cancel Amt |
This metric is the retail value of the customer order canceled quantity. |
CO Demand Cancel Qty |
This metric is the customer order canceled quantity. |
CO Demand Cancel Cost |
This metric is the cost value of the customer order canceled quantity. |
CO Cancel Rate |
This metric is the count of canceled order lines compared to the total order lines. |
CO Line Avg Number of Backorder Days |
This metric is the average number of days that a customer order line is in backorder status. This calculation is done using only order lines that are currently in backorder status. |
CO Line Number of Backorder Days |
This metric is the number of days that a customer order line is in backorder status. This calculation is done only for order lines that are still in backorder status. |
CO Line Number of Pick Days |
This metric is the number of days that a customer order line took to be picked. |
CO Line Avg Number of Pick Days |
This metric is the number of average days it takes a customer order line to be picked. |
CO Line Number of Reserve Days |
This metric is the number of days that a customer order line is in reserve status. |
CO Line Avg Number of Reserve Days |
This metric is the average number of days a customer order line is in reserve status. |
CO Avg Number of Fulfillment Days |
This metric is the average number of days to fulfill a customer order. The calculation excludes order lines that have not yet been fulfilled. |
CO On-Time Shipment Ct |
This metric is the number of customer order lines for which the actual shipment date was earlier than or equal to the expected shipment date. |
CO Late Shipment Ct |
This metric is the number of customer order lines for which the actual shipment date was later than the expected shipment date. |
CO % On-Time Shipments |
This metric is the on-time customer order line shipments as a percentage of total customer order lines. |
CO Fulfillment Order Ct |
This metric is the total number of customer orders that have been fulfilled. |
CO Fulfillment Order Line Ct |
This metric is the total number of customer order lines that have been fulfilled. |
CO Fulfillment Retail Amt |
This metric is the retail value of the customer orders that have been fulfilled. |
CO Fulfillment Retail Amt LW |
This metric is the retail value of the customer orders that have been fulfilled for last week. |
CO Fulfillment Retail Amt LY |
This metric is the retail value of the customer orders that have been fulfilled for last year. |
CO Fulfillment Retail Amt WTD |
This metric is the retail value of the customer orders that have been fulfilled for week-to-date. |
CO Fulfillment Retail Amt MTD |
This metric is the retail value of the customer orders that have been fulfilled for month-to-date. |
CO Fulfillment Retail Amt QTD |
This metric is the retail value of the customer orders that have been fulfilled for quarter-to-date. |
CO Fulfillment Retail Amt YTD |
This metric is the retail value of the customer orders that have been fulfilled for year-to-date. |
CO Fulfillment Retail Amt LY WTD |
This metric is the retail value of the customer orders that have been fulfilled for last year week-to-date. |
CO Fulfillment Retail Amt LY MTD |
This metric is the retail value of the customer orders that have been fulfilled for last year month-to-date. |
CO Fulfillment Retail Amt LY QTD |
This metric is the retail value of the customer orders that have been fulfilled for last year quarter-to-date. |
CO Fulfillment Retail Amt LY YTD |
This metric is the retail value of the customer orders that have been fulfilled for last year year-to-date. |
CO Fulfillment Retail Amt Var LW |
This metric is the variance in fulfilled customer orders' retail value compared to last week. |
CO Fulfillment Retail Amt Var LY |
This metric is the variance in fulfilled customer orders' retail value compared to last year. |
CO Fulfillment Retail Amt WTD Var LY WTD |
This metric is the variance in fulfilled customer orders' retail value compared to last year. |
CO Fulfillment Retail Amt MTD Var LY MTD |
This metric is the month-to-date fulfilled customer order retail value variance compared to last year month-to-date. |
CO Fulfillment Retail Amt QTD Var LY QTD |
This metric is the quarter-to-date fulfilled customer order retail value variance compared to last year quarter-to-date. |
CO Fulfillment Retail Amt YTD Var LY YTD |
This metric is the year-to-date fulfilled customer order retail value variance compared to last year year-to-date. |
CO Fulfillment Qty |
This metric is the quantity of customer order items that have been fulfilled. |
CO Fulfillment Qty LW |
This metric is the quantity of customer order items that have been fulfilled for last week. |
CO Fulfillment Qty LY |
This metric is the quantity of customer order items that have been fulfilled for last year. |
CO Fulfillment Qty WTD |
This metric is the quantity of customer order items that have been fulfilled for week-to-date. |
CO Fulfillment Qty MTD |
This metric is the quantity of customer order items that have been fulfilled for month-to-date. |
CO Fulfillment Qty QTD |
This metric is the quantity of customer order items that have been fulfilled for quarter-to-date. |
CO Fulfillment Qty YTD |
This metric is the quantity of customer order items that have been fulfilled for year-to-date. |
CO Fulfillment Qty LY WTD |
This metric is the quantity of customer order items that have been fulfilled for last year week-to-date. |
CO Fulfillment Qty LY MTD |
This metric is the quantity of customer order items that have been fulfilled for last year month-to-date. |
CO Fulfillment Qty LY QTD |
This metric is the quantity of customer order items that have been fulfilled for last year quarter-to-date. |
CO Fulfillment Qty LY YTD |
This metric is the quantity of customer order items that have been fulfilled for last year year-to-date. |
CO Fulfillment Qty Var LW |
This metric is the variance in the quantity of customer order items that have been fulfilled compared to last week. |
CO Fulfillment Qty Var LY |
This metric is the variance in the quantity of customer order items that have been fulfilled compared to last year. |
CO Fulfillment Qty WTD Var LY WTD |
This metric is the week-to-date variance in the quantity of customer order items that have been fulfilled compared to last year week-to-date. |
CO Fulfillment Qty MTD Var LY MTD |
This metric is the month-to-date variance in the quantity of customer order items that have been fulfilled compared to last year month-to-date. |
CO Fulfillment Qty QTD Var LY QTD |
This metric is the quarter-to-date variance in the quantity of customer order items that have been fulfilled compared to last year quarter-to-date. |
CO Fulfillment Qty YTD Var LY YTD |
This metric is the year-to-date variance in the quantity of customer order items that have been fulfilled compared to last year year-to-date. |
CO Fulfillment Cost Amt |
This metric is the total cost value of fulfilled customer orders. |
CO Fulfillment Cost Amt LW |
This metric is the total cost value of fulfilled customer orders for last week. |
CO Fulfillment Cost Amt LY |
This metric is the total cost value of fulfilled customer orders for last year. |
CO Fulfillment Cost Amt WTD |
This metric is the total cost value of fulfilled customer orders for week-to-date. |
CO Fulfillment Cost Amt MTD |
This metric is the total cost value of fulfilled customer orders for month-to-date. |
CO Fulfillment Cost Amt QTD |
This metric is the total cost value of fulfilled customer orders for quarter-to-date. |
CO Fulfillment Cost Amt YTD |
This metric is the total cost value of fulfilled customer orders for year-to-date. |
CO Fulfillment Cost Amt LY WTD |
This attribute defines the total cost value of fulfilled customer order lines for last year week-to-date. |
CO Fulfillment Cost Amt LY MTD |
This metric is the total cost value of fulfilled customer orders for last year month-to-date. |
CO Fulfillment Cost Amt LY QTD |
This metric is the total cost value of fulfilled customer orders for last year quarter-to-date. |
CO Fulfillment Cost Amt LY YTD |
This metric is the total cost value of fulfilled customer orders for last year year-to-date. |
CO Fulfillment Cost Amt Var LW |
This metric is the total cost value variance of fulfilled customer orders compared to last week. |
CO Fulfillment Cost Amt Var LY |
This metric is the total cost value variance of fulfilled customer orders compared to last year. |
CO Fulfillment Cost Amt WTD Var LY WTD |
This metric is the week-to-date total cost value variance of fulfilled customer orders compared to last year week-to-date. |
CO Fulfillment Cost Amt MTD Var LY MTD |
This metric is the month-to-date total cost value variance of fulfilled customer orders compared to last year month-to-date. |
CO Fulfillment Cost Amt QTD Var LY QTD |
This metric is the quarter-to-date total cost value variance of fulfilled customer orders compared to last year quarter-to-date. |
CO Fulfillment Cost Amt YTD Var LY YTD |
This metric is the year-to-date total cost value variance of fulfilled customer orders compared to last year year-to-date. |
CO Fulfillment Profit Amt |
This metric is the profit amount of fulfilled customer orders. |
CO Fulfillment Profit LW |
This metric is the profit amount of fulfilled customer orders for last week. |
CO Fulfillment Profit LY |
This metric is the profit amount of fulfilled customer orders for last year. |
CO Fulfillment Profit WTD |
This metric is the profit amount of fulfilled customer orders for week-to-date. |
CO Fulfillment Profit MTD |
This metric is the profit amount of fulfilled customer orders for month-to-date. |
CO Fulfillment Profit QTD |
This metric is the profit amount of fulfilled customer orders for quarter-to-date. |
CO Fulfillment Profit YTD |
This metric is the profit amount of fulfilled customer orders for year-to-date. |
CO Fulfillment Profit LY WTD |
This metric is the profit amount of fulfilled customer orders for last year week-to-date. |
CO Fulfillment Profit LY MTD |
This metric is the profit amount of fulfilled customer orders for last year month-to-date. |
CO Fulfillment Profit LY QTD |
This metric is the profit amount of fulfilled customer orders for last year month-to-date. |
CO Fulfillment Profit LY YTD |
This metric is the profit amount of fulfilled customer orders for last year year-to-date. |
CO Fulfillment Profit Var LW |
This metric is the variance in the fulfilled customer order profit compared to last week. |
CO Fulfillment Profit Var LY |
This metric is the variance in the fulfilled customer order profit compared to last year. |
CO Fulfillment Profit WTD Var LY WTD |
This metric is the variance in the week-to-date fulfilled customer order profit compared to last year week-to-date. |
CO Fulfillment Profit MTD Var LY MTD |
This metric is the variance in the month-to-date fulfilled customer order profit compared to last year month-to-date. |
CO Fulfillment Profit QTD Var LY QTD |
This metric is the variance in the quarter-to-date fulfilled customer order profit compared to last year quarter-to-date. |
CO Fulfillment Profit YTD Var LY YTD |
This metric is the variance in the year-to-date fulfilled customer order profit compared to last year year-to-date. |
CO Accommodation Amt |
This metric is the amount of monetary adjustments to a customer order made by the retailer in order to achieve customer satisfaction. |
CO Rush Order Cost Amt |
This metric is the cost of rush order services for a customer order. |
CO Shipping Amt |
This metric is the cost value of customer order shipping services. |
CO Overnight Shipping Amt |
This metric is the cost value of customer order overnight shipping services. |
CO Ground Shipping Amt |
This metric is the cost value of customer order ground shipping services. |
CO Non Return Rate % |
This metric displays the count of order lines that were returned verses number of fulfilled order lines, to help the user understand how many customer order lines were returned. |
Liability Qty |
The number of units that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered to the consumer. |
Liability Qty LW |
Last Week's number of units that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered to the customer at the time of order. |
Liability Qty LY |
Last Year's number of units that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered to the customer at the time of order. |
Liability Amt |
The retail value tied in liability in lieu of unfulfilled order that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered goods to the customer. |
Liability Amt LW |
Last week's retail value tied in liability in lieu of unfulfilled order that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered goods to the customer at the time of order. |
Liability Amt LY |
Last Year's retail value tied in liability in lieu of unfulfilled order that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered goods to the customer at the time of order. |
Liability Canceled Qty |
The number of units that were canceled for which a retailer initially had a liability on, at the time of ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Liability Cancelled Qty LW |
The number of units that were canceled last week for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign . |
Liability Cancelled Qty LY |
The number of units that were canceled last year for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Liability Cancelled Amt |
The retail value of units that were canceled for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Liability Cancelled Amt LW |
The retail value of units that were canceled last week for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Liability Cancelled Amt LY |
The retail value of units that were canceled last year for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Promo Liability Qty |
The number of units sold on promotion that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered to the customer. |
Promo Liability Qty LW |
Last Week's promotional units that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered to the customer at the time of order. |
Promo Liability Qty LY |
Last Year's promotional units that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered to the customer at the time of order. |
Promo Liability Amt |
The promotional retail value tied in liability in lieu of unfulfilled order that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered goods to the customer. |
Promo Liability Amt LW |
Last week's promotional retail value tied in liability in lieu of unfulfilled order that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered goods to the customer at the time of order. |
Promo Liability Amt LY |
Last Year's promotional retail value tied in liability in lieu of unfulfilled order that a retailer was legally bounded to deliver to a customer. For these units, retailer had received payment for but had not delivered goods to the customer at the time of order. |
Promo Liability Canceled Qty |
The number of promotional units that were canceled for which a retailer initially had a liability on, at the time of ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Promo Liability Canceled Qty LW |
The number of promotional units that were canceled last week for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Promo Liability Canceled Qty LY |
The number of promotional units that were canceled last year for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Promo Liability Canceled Amt |
The promotional retail value of units that were canceled for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Promo Liability Canceled Amt LW |
The promotional retail value of units that were canceled last week for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Promo Liability Canceled Amt LY |
The promotional retail value of units that were canceled last year for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Profit Liability Amt |
The profit value of goods/units that are ordered as liability for which a retailer is legally bond or obligated. |
Profit Liability Canceled Amt |
The loss on profit amount occurred due to cancelation of goods/units that were ordered as liability for which a retailer was legally bound or obligated. These values will be positive. |
Pack Liability Amt |
The retail value of sales pack tied in liability in lieu of unfulfilled order that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered goods to the customer. |
Pack Liability Canceled Amt |
The retail value of sales pack that were canceled for which a retailer initially had a liability on, at the time of customer ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Pack Liability Qty |
The sales pack quantity tied in liability in lieu of unfulfilled order that a retailer is legally bounded to deliver to a customer. For these units, retailer has received payment for but has not delivered goods to the customer. |
Pack Liability Canceled Qty |
The number of sales pack units that were canceled for which a retailer initially had a liability on, at the time of ordering. Since these values are received in negative Trx sign from retail merchandising system, a transformation is performed to indicate the values in positive sign. |
Pack Profit Liability Amt |
The profit value of sales packs that are ordered as liability for which a retailer is legally bound or obligated. |
Pack Profit Liability Canceled Amt |
The loss on profit amount occurred due to cancelation of goods/units that were ordered as liability for which a retailer was legally bound or obligated. These values will be positive. |
Table C-21 Consumer Metrics
Metric | Definition |
---|---|
Avg Market Retail |
This metric is the average price paid by consumers for a given market item. |
Avg Market Retail LY |
This metric is the average price paid by consumers for a given market item last year. |
Consumer Score |
This metric measures consumer loyalty to a retailer. It serves as an alternative to traditional customer satisfaction research. |
Consumer Shopping Trips |
This metric is the number of trips that a consumer made over a period of time to buy a market item. |
Consumer Avg Spend Per Trip |
Average monetary value spent per trip, calculated by dividing gross spend by all trips made. |
Consumer Avg Spend Per Trip LY |
Last year's average monetary value spent per trip, calculated by dividing gross spend by all trips made. |
Consumer Household Count |
The count of consumer households with specific attributes that have shopped for the market item in a trade area and timeframe specified for a given sales channel |
Consumer Count |
The count of consumers with specific attributes that have shopped for the market item in a trade area and timeframe specified for a given sales channel. |
Total Time Spent On Trips |
This metric is the total time taken by a consumer for making all trips to a retailer. |
Total Time Spent On Trips LY |
This metric is the total time taken by a consumer for making all trips to a retailer for the last year. |
Market Avg Time Spent |
This metric is the average time spent by a consumer at the retailer's store location. |
Market Avg Time Spent LY |
This metric is the average time spent by a consumer at the retailer's store location for the last year. |
Market Gross Spend Amt |
Gross spend amount for this metric is the value of market items purchased before deducting consumer's returns and inclusive of taxes. |
Market Gross Spend Amt Last Period |
Gross spend amount for this metric is the value of market items purchased before deducting consumer's returns and inclusive of taxes for the previous period. |
Market Gross Spend Qty |
This metric is the quantity of market items purchased before deducting consumer's returns. |
Market Return Amt |
This metric is the value of market items returned by the consumer. |
Market Return Qty |
This metric is the quantity of market items returned by the consumer. |
Market Net Spend Amt |
This metric is the value of market items purchased after deducting consumer's returns. |
Market Net Spend Qty |
This metric is the quantity of market items purchased after deducting consumer's returns. |
Market Net Reg Spend Amt |
This metric is the value of market items purchased at regular price after deducting consumers' returns. |
Market Net Promo Spend Amt |
This metric is the value of promoted market items purchased, after deducting returns of promoted market items. |
Market Net Clr Spend Amt |
This metric is the sales value of clearance market items. |
Market Net Reg Spend Qty |
This metric is the number of market items purchased at regular price after deducting returns. |
Market Net Promo Spend Qty |
This metric is the units of promoted market items purchased. |
Market Net Clr Spend Qty |
This metric is the units of market items purchased on clearance. |
Market Gross Spend Amt LY |
This metric is the value of market items purchased for the last year. It includes taxes, but does not include discounts or returns. |
Market Return Amt LY |
This metric is the value of market items returned by the consumer for the last year. |
Market Net Reg Spend Amt LY |
This metric is the value of market items purchased at regular price for the last year after deducting returns. |
Market Net Promo Spend Amt LY |
This metric is the value of promoted market items purchased for last year. |
Market Net Clr Spend Amt LY |
This metric is the value of market items purchased on clearance for the last year. |
Market Gross Spend Qty LY |
This metric is the units of market items purchased for the last year before deducting returns. |
Market Return Qty LY |
This metric is the number of market items returned by the consumer for the last year. |
Market Net Reg Spend Qty LY |
This metric is the quantity of market items purchased on regular price after deducting consumer returns for last year. |
Market Net Promo Spend Qty LY |
This metric is the value of promoted market items purchased for the last year, after deducting returns of promoted market items. |
Market Clr Spend Qty LY |
This metric is the number of market items purchased on clearance for the last year. |
% Market Items Scoring ”Good” |
This metric is the percentage of items in a market category that consumers scored in the ”good” range from 8-10 for the selected channel. |
% Market Items Scoring ”Poor” |
This metric is the percentage of items in a market category that consumers scored in the ”poor” range from 1-4 for the selected channel. |
% Market Items Scoring ”Average” |
This metric is the percentage of items in a market category that consumers scored in the ”average” range from 5-7 for the selected channel. |
Market Penetration |
This metric is the ratio of Market Gross Sales Amount for a lower level of the market item hierarchy to the Market Gross Sales Amount for a market category. It indicates what proportion of a market category's sales are due to a particular item or subcategory. |
Item % Contribution to Subcategory |
This metric displays the amount of sales of a lower level of the market item hierarchy as a percentage of total sales for a subcategory. It will reveal the relative importance of specified items to their subcategory sales. |
Market Subcategory Gross Spend Amt |
This metric displays the gross spend amount for a particular market subcategory. |
Table C-22 Cluster Metrics
Metric | Definition |
---|---|
Avg Disc Amt |
This metric is the average of the difference between the regular price-point and the discounted price-point times the sales units at the discounted price-point. |
Cluster Loc Ct |
The Cluster Location Count is the count of all locations within one cluster. |
Cluster Group Loc Ct |
The Cluster Location Group Count is the count of all locations within a cluster group. |
Cluster Avg Loc Gross Sales Amt |
The Cluster Average Location Gross Sales Amount is the average gross sales amount of a location within the cluster in question |
Cluster Avg Loc Net Sales Amt |
The Cluster Average Location Net Sales Amount is the average net sales amount per location in a given cluster. |
Cluster Avg Loc Profit |
The Cluster Average Location Profit Amount is the average profit amount per location in a given cluster. |
Cluster Group Tot Inv Retail |
Projected owned inventory retail amount. |
Cluster Group Avg Loc Stock Turnover |
The Cluster Group Average Location Stock Turnover is how fast a location within a cluster group on average turns inventory in a given period like a year. |
Cluster Avg Loc Tot Inv Retail |
The Cluster Average Location Inventory Amount is how a location within a cluster does on average for inventory amount (level). |
Cluster Stock Turnover |
The number of times inventory is sold in a time period such as a year for a cluster. |
Ending Cluster In-Stock % |
This metric is the percentage of item-location combinations in a cluster that are in-stock at a specific point in time. |
Cluster Group Avg Loc Gross Sales Amt |
The Cluster Average Location Gross Sales Amount is the average gross sales amount of a location within the cluster in question. |
Cluster Group Avg Loc Net Sales Amt |
The Cluster Average Location Net Sales Amount is the average net sales amount per location in a given cluster. |
Cluster Group Avg Loc Profit Amt |
The Cluster Group Average Location Profit Amount is the average profit amount per location in a given cluster Group. |
Table C-23 Wholesale Order Metrics
Metric | Definition |
---|---|
Wholesale Stock Turnover |
Inventory in this metric is initial stock on hand for the virtual warehouse, but in this case sales are divided by inventory, which is the inverse of the inventory/sales ratio. |
Wholesale Returns |
This metric is the amount of returns for wholesale transactions only, leaving out regular retail returns. |
Wholesale Gross Profit Amt |
This metric is the gross profit value for wholesale transactions. |
Quarterly % Change in Wholesale Sales |
This metric is calculated by comparing the current period's wholesale sales to the previous period's wholesale sales to reveal trends over time. |
Wholesale Gross Sales Amt |
This metric is sales for wholesale transactions only. |
Wholesale Gross Sales Amt |
This metric is sales for wholesale transactions only. |
Table C-24 Inventory Adjustment Metrics
Metric | Definition |
---|---|
Adjustment Units |
This metric is the number of units adjusted on stock on hand in a location to an item. |
Adjustment Cost Value |
This metric is the cost value of units adjusted on stock on hand in a location to an item. |
Adjustment Retail Value |
This metric is the retail value of units adjusted on stock on hand in a location to an item. |
Table C-25 Inventory Transfer Metrics
Metric | Definition |
---|---|
Transfer Out Units |
This metric is the number of units being transferred from the location to any other retailer's entity as part of different transfer types (book transfer, Inter Company etc.) |
Transfer Out Cost Value |
This metric is the cost value of units being transferred from the location to any other retailer's entity as part of different transfer types (book transfer, Inter Company etc.) |
Transfer Out Retail Value |
This metric is the retail value of units being transferred from the location to any other retailer's entity as part of different transfer types (book transfer, Inter Company etc.) |
Transfer In Units |
This metric is the number of units being transferred to the location from any other retailer's entity as part of different transfer types (book transfer, Inter Company etc.) |
Transfer In Cost Value |
This metric is the cost value of units being transferred to the location from any other retailer's entity as part of different transfer types (book transfer, Inter Company etc.) |
Transfer In Retail Value |
This metric is the retail value of units being transferred to the location from any other retailer's entity as part of different transfer types (book transfer, Inter Company etc.) |
Table C-26 Return to Vendor Metrics
Metric | Definition |
---|---|
RTV Units |
This metric is the number of units being returned from the location to supplier as part of returns. |
RTV Cost |
This metric is the Cost value of units being returned from the location to supplier as part of returns. |
RTV Retail |
This metric is the retail value of units being returned from the location to supplier as part of returns. |
RTV Cancelled Units |
This metric is the number of units cancelled during the return from the location to supplier as part of returns. |
RTV Cancelled Cost |
This metric is the cost value of units cancelled during the return from the location to supplier as part of returns. |
RTV Cancelled Retail |
This metric is the retail value of units cancelled during the return from the location to supplier as part of returns. |