ABC Analysis
This report sorts items based on the analysis method and displays what the new ABC code should be. Sorting may be done either by unit volume or total cost.
This table shows the ordering criteria calculations:
| 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.
These forms are all accessible from the menu:
- Background Queue
- Get Options
- Store Options