ABC Analysis Ordering Criteria Calculations

This table shows the ordering criteria calculations for the ABC Analysis report.


Analysis Method	Sort By	Calculation
Future	Unit	Sort by sum of all APS requirements for each item
Future	Value	Sort by sum of all APS requirements multiplied by unit cost for each item
Unit	Unit	Sort by unit cost
Unit	Value	Sort by unit cost multiplied by quantity on hand
YTD	Unit	Sort by sum of quantity sold year-to-date plus quantity used year-to-date for each item
YTD	Value	Sort by sum of (quantity sold year-to-date plus quantity used year-to-date) multiplied by unit cost for each item

Note: Quantity used year-to-date comes from the Used YTD field on the Sales tab of the Items form. Quantity sold year-to-date comes from the Sold YTD field on the Sales tab of the Items form.