Mango Report
Help Center
Search:
Contents
:
IndexBookmarkPrint

Home > Excel Reports > Product Analysis > TTM/Month SKU Detail

TTM/Month SKU Detail
The SKU Detail tabs in this workbook help stores audit and understand inventory value change, sales, and shrink from period to period.  This is especially useful when trying to analyze why reported inventory value went up or down significantly during a period. There are two "value change" worksheet tabs: 

  • TTM SKU Detail - this worksheet reports value changes, sales, or shrink compared to 12 months ago (TTM stands for Twelve Trailing Months). To keep worksheet size manageable, only absolute changes of $10 or more are reported. 
     
  • Month SKU Detail - this worksheet reports value change, sales, or shrink from last month. To keep worksheet size manageable, only absolute changes of $10 or more are reported. 

Note 1: both Value Change tabs will exclude the Boundary Exceptions: Cost/QOH Errors, and Store Supply. However, some negative values may be included in certain circumstances.

 

     Column Definitions