Print ABC Velocity Report (By Dollars or Units)

Purpose: Use this report to review the ABC/velocity code assigned to each item/SKU, based on the total sales dollars or total sales units of the item/SKU for a defined accounting period/year.

The Use dollars or units field at the Update SKU ABC/Velocity Codes Screen (MABC) determines if the system prints the Print ABC Velocity report by dollars or units.

This report sorts in New ABC code, Sales dollars/units sequence.

See ABC/Velocity Process for more information on the steps the system performs to determine the ABC/velocity code assigned to each item/SKU, based on sales rank.

How to print: Submit the ABC/Velocity Process at the Update SKU ABC/Velocity Codes Screen (MABC).

For more information: See the sample Print ABC Velocity by Units report and the sample Print ABC Velocity by Dollars report in PDF format.

Contents:

From date: The date you entered in the From date field on the Update SKU ABC/Velocity Codes Screen (MABC); this is the starting date the system uses to update ABC/velocity codes.

To date: The date you entered in the To date field on the Update SKU ABC/Velocity Codes Screen (MABC); this is the ending date the system uses to update ABC/velocity codes.

Use dollars or units: Indicates if the system used sales dollars or sales units to determine the ABC/velocity code assigned to each item.

D Dollars indicates that the system used sales dollars.

U Units indicates that the system used sales units.

Update to be performed: Indicates if the system updated items with the new ABC/velocity code or just generated the Print ABC Velocity Dollars/Units report without performing updates.

1 Update w/Report indicates that the system updated the ABC/velocity code assigned to an item based on the item’s performance and generated the Print ABC Velocity Dollars/Units report.

2 Report only indicates that the system generated the Print ABC Velocity Dollars/Units report without performing updates.

ABC code: A code that classifies an item based on sales volume; this is a list of the ABC codes from the ABC/Velocity table that can be assigned to each item/SKU.

First order: Indicates the number of days that must pass after the first order for an item before an ABC/velocity code is assigned to the item. For example, if First order is set to 5, an item is assigned an ABC/velocity code of N (new item) until 5 days after the date of its first order. The First order column is populated only for ABC/velocity code N. Items assigned ABC/velocity code N are not included on this report.

Percentage of sales: The percentage of sales (units or dollars) required for an item to earn the ABC/velocity code. The system ranks percent of sales by ABC/velocity code, sorted alphanumerically.

Item: A code that represents an item.

SKU: The SKU code, if any, of the item.

Description: A description of the item.

Sales dollars: The sales dollars for the item/SKU in the date range specified. This is the Dollars sold from the Item Sales Analysis Work table. Note: The system does not include items with negative sales dollars.

Sales units: The sales units for the item/SKU in the date range specified. This is the Units sold from the Item Sales Analysis Work table.

Cumulative dollar sales: The cumulative sales dollars up to and including this item. The system totals the Sales dollars column for this item and all previous items on the report. For example, the cumulative dollar sales for the first item on the report is sales dollars for that item only; the cumulative dollar sales for the second item on the report is sales dollars for that item plus the sales dollars for the first item; the cumulative dollar dales for the third item on the report is the sales dollar for that item plus the sales dollars for the first and second item, etc. This column is included only if you generated the report by dollars.

Cumulative unit sales: The cumulative sales units up to and including this item. The system totals the Sales units column for this item and all previous items on the report. For example, the cumulative unit sales for the first item on the report is sales units for that item only; the cumulative unit sales for the second item on the report is sales units for that item plus the sales units for the first item; the cumulative unit sales for the third item on the report is the sales units for that item plus the sales units for the first and second item, etc. This column is included only if you generated the report by units.

Cumulative percent of sales: The cumulative percentage of sales for the item. The system uses the following calculation to determine the cumulative percent of sales: (Cumulative dollar sales / Final totals cumulative dollar sales) x 100 = Cumulative percent of sales. For example, if the Cumulative dollar sales for the item is 824.00 and the Final totals cumulative dollar sales is 1092.00, the Cumulative percent of sales is 75.45787, rounding to 75.46%.

Cumulative percent of items: The cumulative percentage of items. The system uses the following calculation to determine the cumulative percent of items: (item # / Total items) x 100 = Cumulative percent of items. For example, for the first item on a report with 8 total items, the Cumulative percent of items is 12.50%; for the second item, the Cumulative percent of items is 25.00%.

Previous ABC code: The ABC/velocity code previously assigned to the item/SKU.

New ABC code: The ABC/velocity code currently assigned to the item/SKU. Note: If you selected to generate this report without performing updates, the system does not assign a new ABC code to the item.

Final totals: The total cumulative dollars or units for all items/SKUs included in the ABC Velocity by dollars/units.

Total items: The total number of items/SKUs included in the ABC Velocity by dollars/units. The system does not include items assigned ABC/velocity code N (new item) in this total.

ME01_02r Serenade 5.0 March 2015