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).
Print ABC Velocity by Dollars report:
CWDirect Rel 8.0 Print ABC Velocity by Dollars KBOTTGER INR1823 2/09/04 11:36:39 Page 1 KAB CWData Download Company Report Selection: From Date . . : 2/09/04 To date . . . : 2/09/04 Use Dollars or Units : D Dollars Update to be Performed: 1 Update w/Report ABC First Percentage Code Order of Sales A 0 50.00 % B 0 25.00 % C 0 15.00 % D 0 10.00 % N 5 .00 % Z 0 .00 % Cumul. Cumul. Prev New Sales Sales Cumulative Pct of Pct of ABC ABC Item SKU Description Dollars Units Dollar Sales Sales Items Code Code 2004ITEM1 2004ITEM1 ITEM DESCRIPT 160.00 6 160.00 22.63 % 12.50 % A A 2004SKU1 RED GRLS SMLL 2004SKU1 ITEM DESCRIPTI 160.00 6 320.00 45.26 % 25.00 % A A 2003ITEM1 2003ITEM1 DESCRIPTION 152.00 7 472.00 66.76 % 37.50 % B B 2003SKU1 RED GRLS SMLL 2003SKU1 152.00 7 624.00 88.26 % 50.00 % C C 2004ITEM2 2004ITEM2 ITEM DESCRIPT 51.00 6 675.00 95.47 % 62.50 % D D 2003ITEM2 2003ITEM2 ITEM DESCRIPT 32.00 3 707.00 100.00 % 75.00 % D D 2003SOLDOUT 2003SOLDOUT ITEM DESCRI .00 0 707.00 100.00 % 87.50 % Z Z 2005ITEM1 2005ITEM1 ITEM DESCRIPT .00 0 707.00 100.00 % 100.00 % Z Z Final totals 707.00 Total Items: 8 |
Print ABC Velocity by Units report:
CWDirect Rel 8.0 Print ABC Velocity by Units KBOTTGER INR1822 2/09/04 11:44:56 Page 1 KAB CWData Download Company Report Selection: From Date . . : 2/09/04 To date . . . : 2/09/04 Use Dollars or Units : U Units Update to be Performed: 2 Report Only ABC First Percentage Code Order of Sales A 0 50.00 % B 0 25.00 % C 0 15.00 % D 0 10.00 % N 5 .00 % Z 0 .00 % Cumul. Cumul. Prev New Sales Sales Cumulative Pct of Pct of ABC ABC Item SKU Description Dollars Units Unit Sales Sales Items Code Code 2003ITEM1 2003ITEM1 DESCRIPTION 152.00 7 7 20.00 % 12.50 % B A 2003SKU1 RED GRLS SMLL 2003SKU1 152.00 7 14 40.00 % 25.00 % C A 2004ITEM1 2004ITEM1 ITEM DESCRIPTION 160.00 6 20 57.14 % 37.50 % A B 2004ITEM2 2004ITEM2 ITEM DESCRIPTION 51.00 6 26 74.29 % 50.00 % D B 2004SKU1 RED GRLS SMLL 2004SKU1 ITEM DESCRIPTION 160.00 6 32 91.43 % 62.50 % A C 2003ITEM2 2003ITEM2 ITEM DESCRIPTION 32.00 3 35 100.00 % 75.00 % D D 2003SOLDOUT 2003SOLDOUT ITEM DESCRIPTI .00 0 35 100.00 % 87.50 % Z Z 2005ITEM1 2005ITEM1 ITEM DESCRIPTION .00 0 35 100.00 % 100.00 % Z Z Final totals 35 Total Items: 8 |
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 displays if the system used sales dollars.
• U Units displays if 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 displays if 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 displays if 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 defined in the ABC/Velocity file 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 file. 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 file.
• 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 displays 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 displays 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.
| Chapter 1: Working with ABC/Velocity Codes (WABC) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 2: Working with Frequency Codes (WFRQ) |
ME01_02r CWDirect 18.0 August 2015 OTN