Experimental v1

This macro-enabled Excel Promo Residue workbook is designed to help stores find residual SKUs left over from promotional sales.

• I - Ext Avg Cost: QOH multiplied by Average Cost.

  J - On Promo: Currently on promo as of the first of the month.

  K - Promo Price: The current or most recent promotional price.

  L - Retail: Latest Retail Price.

  M - Rep Cost: Replacement Cost.

  N - Regular Margin: Margin at retail price.

  O - Promo Margin: Margin at promo price.

  P - Months Supply: Remaining months supply if sold at promo.

  Q - Non-Promo Months Supply: ​Remaining months supply if sold at full retail.

  R - Promo Percent:

  S - Promo Frequency TTM: Percent of months the SKU has been on promo in the last 12.

  T - Last Month Promo Sales Units: How many sold last month on promo.

  U - Action: Recommended steps to take on the SKU.

  V - Last Action: