Sales - Executive Summary
Note: sales and gross profit comparisons (to last year) are estimated for stores using Mango for less than a full calendar year.
These figures may differ slightly from your financial or other reports due to non SKU-level discounting such as terms discounts or using Ctrl+D in POS in the total window, which do not apply discounts back to individual SKUs.

MTD Sales - Month to date sales
Month-to-date sales measures sales increase/decrease from the same month last year.

YTD Sales - Year to date sales
Fiscal year to date sales increase/decrease from the comparable period last year.

YTD GP Dollars - Year to date gross profit dollars
Fiscal year to date gross profit increase/decrease from the comparable period last year. Note: gross profit is calculated using the cost basis set up in your store (Option ID 102, Replacement Cost or Average Cost). An overwhelming majority of stores use Average Cost (like 99% of stores) so if your store is using Replacement Cost then your Gross Profit and Margin metrics may show lower than peers.

MTD Margin % - Month to date margin percentage
Average margin for the reported month (gross profit/sales) as a percentage.

YTD Margin % - Year to date margin percentage
Margin for your fiscal-to-date period (gross profit/sales) as a percentage.

Ace SKU Margin % - Margin percentage, Ace SKUs only
Year to date margin for Ace SKUs only.

Non-Ace SKU Sales % - Percentage of sales by non-Ace SKUs
Note: no dot color associated with this metric as targets for different types of stores are expected.
The contribution of non-Ace SKUs to total sales.  For example, a store with a sizable lumber yard may have a high percentage here as its non-Ace lumber sales contribute significantly to the store's overall sales. A store focused primarily on an Ace SKU assortment will have a lower percentage.

Non-Ace SKU Margin % - Margin percentage, non-Ace SKUs only
Note: no dot color associated with this metric as targets for different types of stores are expected.
Year to date margin for your non-Ace SKU population.

Rewards % - Ace Rewards redemption percentage
Note: no dot color associated with this metric as targets for different types of stores are expected.
The percentage of non-vendor/bankcard funded Ace reward redemptions to sales.  For example, if a store with $1 million in annual sales redeems $10,000 of rewards in the same period, its Rewards % metric will be ($10,000 / $1,000,000 * 100) = 1%.

Promotion activity % - Promotional sales impact
Note: no dot color associated with this metric as targets for different types of stores are expected.
Shows the impact of promotional sales activity in the store. A higher number can indicate a store more sensitive to promotional sales and may indicate a more price sensitive market. The metric is derived by summing the difference between full retail and actual selling price for promotional items (MIP, Ctrl+P at POS, plugged promotional price), excluding Store Closeout = Y sales.  Your store's high dollar promotional impact SKUs can be found in your monthly Exception Reports under Top Promotional Sales and Discounts.Margin

Margin Point Change LY
This powerful metric measures the difference between your store's current weighted back door margin (retail - replacement cost--based on historical sales) expected this year based on the same metric last year.  The metric excludes promotional and certain noisy inventory and the top drivers are reported in your Margin Impact Exception Report.  For example, a metric of -0.14 means your store's back door margin this year is 13 basis points below where it was last year (49.65% vs. 49.51% for example).  Negative values mean your retail pricing is not keeping up with inflation, or you have employed a price reduction strategy, whereas positive numbers indicate your margin this year is higher than last year (everything else being equal).