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.
The initial screen presented by Usage Review is a summary view for the selected warehouse and item. It presents a daily view of usages beginning with the date specified and going back the number of days selected.This view provides a high-level perspective of the usage, including rolling 30-day usage values and the “normal” range based on the setting in Replenishment Parameter F/M. It allows you to see where spikes or troughs in usage occur. You cannot edit usage from this summary screen. FACTS maintains usage values at the individual document level, not in monthly or even daily buckets. To make changes to specific documents, you must proceed to the detail screen by drilling down on one of the lines on the summary screen.
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 using the beginning date for the display, and the number of days (30, 60, 90, or 120) from that date to display.
Tip: Press F1 to enter the current date. Press F2 or click IC Period End icon to automatically enter the 'end of current IC period' or you can enter the date to be the end of the current IC period (even if that date is in the "future"). This you allows to view all the dates of the current period.
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 click Apply Filters 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 click Recalculate Usage. Specify the date to Recalculate From and click OK 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 Recalculate Usage 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