With Usage Review (ICE555) you can view qualified usage for any document that has recorded usage for the selected warehouse and item combination you specify. All usage on this screen is sum of usage for the specified warehouse and all warehouses the specified warehouse replenishes.
You can apply a set of filters to define the usage lines displayed in the browser (which are displayed in descending date order). You can filter for the beginning date for the display, and the number of days (30, 60, 90, or 120) from that date to display. You can also check the Abnormal check box to only display those dates already listed in the browser that have Abnormal (both High and Low) indicated usage. When making any changes to date or number of days you must select the Apply Filters button to enact those changes so that the browser will redisplay with appropriate lines.
Usage lines display for ‘beginning date’ descending # days.
Above the browser, in the Math for Usage Range, you can review the display for how comparison low and high values were determined. The information in the browser includes: total actual usage for that day , total qualified usage for that day, accumulated total qualified usage going back for 30 days (including the day of the line in the browser), comparison usage range and abnormal usage details–High/Low/(blank) - based on whether the total 30 day usage is outside the Comparison Range.
The comparison usage range is only backwards based on RPM Usage Alert Settings – excludes most recent 30 days (so if the 30 day window was dec then if the RPM months was 3, would go back to sep, oct, nov) This value does not depend on the usage method selected.
You can double click a line in the browser to access the Usage Review Detail (ICE556) program to modify qualified usage values/dates. Only lines having usage will be able to access the Usage Review Detail program. Once you have modified the qualified usage for a document you can return to Usage Review and select the Recalculate Usage button to recalculate qualified usage for specified warehouse/item. This modified usage, called qualified usage, is used in usage calculations performed by the Daily Sales Register.
Usage: Usage, by item, is summarized by the Daily Sales Register (DSR) from the item’s detailed transactions recorded. Qualified usage adjustments (performed in the Usage Review Detail program) upon the next DSR or when you click the Recalculate Usage button in the Usage Review program. Otherwise the daily usage for an item will not be summarily stored in the ICUSED table until the next day. The summary table ICUSED is used to provide usage information for replenishment calculations. Usage data will be collected/summarized nightly for all stocked items in the system. This allows for accurate calculation of Average Daily Usage for Order Point and Line Point. The extrapolated data points for seasonal usage will employ a T-Backward usage calculation. The usage for an item will be examined for 12 periods in arrears, backing up a number of periods based on an items Rank. The number of periods utilized for trending will be based on an item’s Rank. The higher the activity Hits for an item, the higher the Rank and thus a smaller the window to be utilized for trending. An “A” ranked item will have a 3 month backward and forward trend and require 15 months of history. A “B” ranked item will have a 4 month trend window and require 16 months of history, and so on.
See Also