Skip Headers
Oracle® Retail Analytics User Guide
Release 14.1
E57810-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

C Retail Analytics Metric Definitions

This appendix contains a complete list of Oracle Retail Analytics metrics. See Chapter 6, "Metrics" for additional information about metrics.

Cost/Profit

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.


Markdowns

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.


Forecast

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.


Inventory Receipts

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.


Sales

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.


Sales Pack

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.


Supplier Invoice

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.


Supplier Compliance

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.


Inventory Position

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.


Retailer To Franchise

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.


Price

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.


Plan

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.


Stock Ledger

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.


Dimension

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.


Affinity

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.


Customer

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.


Promotion

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.


Trial and Repeat

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”.
• Design note: The counting logic should group purchases by Customer Household/Item/Day. For instance, the first purchase on day 1 of week 1 by Customer1, followed by a second purchase on day 2 of week 1 by Customer 2, would count as ”1 trial purchase in wk1 and 1 repeat 1 purchase in wk1. • Note if Customer Household is not available as a grouping mechanism of Customers in RA 13.3, then this report name and logic should be changed to just group by individual customers, i.e. ”Trial & Repeat Purchases by Customers” report

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”.


Offer

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.


Customer Order

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.


Consumer

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.


Cluster

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.


Wholesale Order

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.


Inventory Adjustment

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.


Inventory Transfer

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.)


Return to Vendor

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.