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.