Movement Class Report (ICR730)

Using Reports

Use this program to obtain a Movement Class Report listing by movement class, items assigned to that class by warehouse. Movement classes may also be recalculated and reset.

To reset movement classes, the system takes each item (per warehouse) and multiplies the last 12 periods of usage by the unit cost. The totals for each item are then sequenced in order with the best items (most dollars moving through inventory) at the top of the list. Each item is then assigned to a class based on the following:

Top	7 ½% of the items	-	Class 1
Next	7 ½%	-	Class 2
Next	10%	-	Class 3
Next	10%	-	Class 4
Next	8%	-	Class 5
	8%	-	Class 6
	8%	-	Class 7
	8%	-	Class 8
	8%	-	Class 9
	8%	-	Class 10
	8%	-	Class 11
Last	9%	-	Class 12
	0%	-	Class 13 (Dead Stock)
	0%	-	Class 14 (Unassigned)
	100%

Movement Class is calculated for an item based upon six months of history for the item and warehouse. Items that do not have six months of history may be included or excluded from this report. If these items are included, then the known usage of these items is averaged and extrapolated over twelve previous months (based on the current date).

Movement Class Recalculate

When the Movement Class Report is selected with the option to recalculate, the user has the option to specify the number of months of usage to exclude. Any item that does not meet the specified number of months of usage is excluded from the recalculation.

For item with usage greater than or equal to the specified months but less than 12 months, an average for the known usage is taken and extrapolated across the months not known (up to 12 months). The known and extrapolated monthly usage will be added for the annual usage needed to recalculate the movement class.

Items in Class 13 (Dead Stock) remain in Class 13.
Items in Classes 1-13 which do not have the specified number of months of usage in ‘Exclude New Items’ are moved to Class 14 (Unassigned) and print on this report.
Nonstocked and uninventoried items are moved to Class 14 and print on this report.

Blank usage for a month is considered as a month with NO usage history. Zero usage for a month is considered as a month with usage history of zero.

To access this program, choose Inventory Control-->Reports & Prints -->Movement Class Report.

Use the following fields to print a Movement Class Report:

1. Beginning Movement Class

Enter the beginning movement class code to print (1-14). Press Enter (CR) to default to 1.

2. Ending Movement Class

Enter the ending movement class code to print (1-14). Press Enter (CR) to default to 14.

3. Vendor

Enter the vendor to print. The entry must be a valid vendor. Press F1 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

4. Class

Enter the item class to print. The entry must be a valid item class. Press F1 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

5. Item Description

Enter whether to print item description 1, 2, or Both from Item F/M. Press Enter (CR) to default to 1.

6. Warehouse Code

Enter up to 20 two-character warehouse codes side by side to print. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F3 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

7. Recalculate

If Class 1 was not entered in field #1 and class 14 was not entered in field #2 (i.e., the entire range of movement classes were not selected), this field is skipped. Indicate whether to recalculate movement classes by using the 12-month usage figures.

8. Dead Item Cutoff

This field only displays if Y was entered in the previous field. Enter the total cost of the last 12 periods of qualified usage for dead item cutoff. Press Enter (CR) to default to $10.00.

9. Flagged

This field displays only if Y was entered in field #7. If any flagged items are encountered when this report is run, enter A to use the actual usage or R to reset to class 14.

10. Exclude New Items

Exclude items with less than how many months of usage history: 1-12, CR=6, F1=NONE. If ‘1’ is selected, then all of the items will be included, except those new items with no usage (or blank usage). For all items included with less than 12 months of usage history, the extrapolated average calculation for annual usage is used.

11. Dead Items

Indicate whether to print only newly calculated dead items or not. Press Enter (CR) to default to selected.

Check the Report. Do you wish to reset? Enter YES or N to indicate whether to reset the item’s movement classes as indicated on the report just printed.

Movement Class Report (ICR730)

Using Reports

Movement Class Recalculate

Use the following fields to print a Movement Class Report:

See Also

Using Reports