Inventory Evaluation
Menu 6.32 - ABC Ranking Report
Menu 6.32 - ABC Ranking Report
The ABC Ranking Report is for spot checking and analyzing items to see if they agree with the Sales, Hits, & GMROI ranking. It’s also used to compare Old ABC (OABC) to new ABC (ABC) ranking.
The report can be FT (file transferred) into Excel to alter the sort order.
ABC Ranking Report Column Headings
Warehouse #, Part #, Item Description, On Hand, ROP, EOQ, Average Cost, Qty Sold 12 Month, Old ABC, Sales $$, Sales ABC Rank, Hits, Hits ABC Rank, GP $$, Inventory $$, GMROI, GMROI ABC Rank, Final ABC Rank
 
|
