This tab helps stores review significant inventory value change compared to the same month last year. This can be used to:

• Gain sku-level insight into balance sheet changes in inventory value.
• Catch purchasing or point-of-sale errors.
• Become proactive with reducing inventory before it becomes overstock or obsolete.
• Point out lapses in purchasing control/policy.

The worksheet is limited to 300 SKUs per store and lists year-over-year increases of $50.00 or more and decreases of $200.00 or less. A more thorough listing can be found in the Inventory Changes Workbook in your online reports.

• I - Change Status: (New, Deleted, Can/Rep) Indicates if a SKU is newly added (within the last twelve months), was deleted with QOH, or is part of a canceled and replaced pairing.

  J - Promo Sales Signature: Shows if "Promo" if the SKU is currently on a promotion or half or more of its annual sales have been on promo. Shows COM when on Closeout Management.

  K - Seasonal Signature: Shows if the SKU is part of a seasonal class and will likely exhibit sales variability depending on the time of the year.

  M - TTM QOH Change: The change in units (quantity on hand) from the same month last year (month-end to month-end).

  N - TTM Value Difference: The dollar change in extended average cost (QOH * Avg Cost) from last year. This is the worksheet's original sort order.

  O - TTM Purch Units: The number of units purchased over the last twelve months.

  P - TTM Sales Units: The number of units sold over the last twelve months.

  Q - Months of Supply: The number months of inventory on hand based on the SKU's quantity-on-hand and its average monthly sales units.

  R - Gross Margin %: The SKU's profit margin.

  S - TTM Gross Profit: Profit dollars (sales dollars minus average cost dollars) over the last twelve months.

  T - (Cash) Flow (Sales - Purch): This is the estimated cash flow (sales dollars - purchase dollars - shrink) for the last twelve months. Negative number indicate more purchase dollars than sales dollars.

  U - Shrink: Shows the shrinkage gain/loss (change times average cost) over the last twelve months.

  V - Inflation: Shows the impact of average cost change from year to year. This is current quantity-on-hand times (current avg cost minus last year's average cost).

  AD - Obsolete/Overstock: Shows If the SKU is currently on the Obsolete or Overstock listing in your MEGA report.

  AE - Replacement SKU: If the SKU is a canceled/replaced pair then this shows the canceled replaced pair.