Usage and history fields
Field definitions for usage and history fields.
| Field name | Description | Usage information |
|---|---|---|
| Actual Issues | Average Total Number of Issues per year | This value is calculated as the total annual issues over the last two years based on issue date, where Scheduled Flag is not equal to "Ignore". |
| Actual Stockouts | Average Total Number of Stock outs per year | This value is calculated as the total number of issue transactions per year, which is calculated over the last two years, where StockOut Flag = "Y". |
| Ann usage 2 yrs ago | Annual Unscheduled Usage 2 years ago | Unscheduled usage for the calendar year two years ago. |
| Average Issue Size | Average (Forecast) Issue Size in units | An average of unschedued issues where the issue size is greater than 0, using the most recent 48 issues. If there are no issues or the result of the issue size calculation is less than one the Average Issue Size will be set to one. |
| Clipping Code | Forecast Clipping Code | Within the usage data that is extracted from the ERP there will be a few data values that may be considered “abnormal”. To avoid distorting the demand forecast, the solution allows these points to be removed or “clipped” from the usage data. All values that equal or exceed the clipping limit are clipped. |
| Current Safety Weeks | Current Safety Stock in weeks of usage | The calculated safety stock expressed as weeks of usage.It can be negative. |
| CurrentStockOut Cost | Current Annual Stockout Costs | Projected Annual Stockout Costs. |
| Delivery Lead Time | Forecast Freight Delivery Lead Time (in days) | Calculated average of Lead time from receipts where the Receipt Category is equal to "FRT - Freight". |
| Factor Due Date | Forecast Factor Due Date | Date the ramp-up factor ceases to apply. |
| Forecast Factor | Forecast Factor Value | Amount to increase or decrease the forecast usage by. |
| Forecast Method | Forecast Method | User selectable to choose any of the available algorithms for forecasting. |
| Forecast Mode | Forecast Mode | This user selectable field is used to determine what usage forecasting should be based on - Actual, Projected or both. |
| Forecast Parameter | Forecast Parameter | Used when adopting some of the forecast methods that are not "Best". |
| Forecast Trend % | Forecast Annual Trend % | A future usage trend is calculated to aid in determining whether demand is increasing or declining. |
| Forecast Usage Mth 1 | Forecast Usage in Month 1 | (The most recent month) |
| Forecast Usage Value | Forecast Average Annual Usage Value | Value based on the solution Recommended Reorder Point and Reorder Quantity. |
| Forecast Usage/month | Average Forecast | Usage per month (units) |
| Forecast Variance % | Forecast Variance % | A measure of the degree of variability in the usage. |
| Former UOI | Former Unit Of Issue | Last Month's Unit of Issue. |
| Issue Size Code | Issue Size Code | Used to designate which issue size value is used. For example, "A - Average" or "M - Manual". |
| Issue Size | Issue Size Displayed & Used | If issue size code equals A, then average issue size is adopted and displayed. If issue size code equals M, then the manually set issue size is adopted and displayed. |
| Issue Variance % | Issue Size Variance % | A measure of the degree of variability in the issue size. |
| Last Issued | Last Issued Date | The most recent Issue Date where the Scheduled Flag is not equal to "I - Ignore". |
| Last Year Usage | Last Year's total Usage | The total quantity consumed in the past rolling 12 months (unscheduled plus scheduled). |
| Last Years Turnover | Last year's Usage Turnover Ratio | Last year's usage value divided by the average stock on hand value. |
| Last years usage Total | Unscheduled Usage Last Year | Total unscheduled and transfer (scheduled flag N and T) usage for the previous calendar year. |
| Lead Time Usage. | Lead Time over Usage. | Forecast usage Multiplied by Lead Time. |
| Limit | Clipping Limit (usage above the limit is clipped) | Only applicable if the user has set the Clipping Code to "Manual" |
| MTBD (years) | Mean Time Between Demand in years | Mean that Time Between Demand is the default forecasting method that is used for slow moving items. |
| MTBD Holding Level | Mean Time Between Demand Holding Level | Shows which holding level the solution recommends (zero, one, or two sets). |
| On-time Issue % | Item issue date against item required date. | This value is calculated as the percentage of stock demands (sum of the on-time issue quantities) met on-time (the customer service level) compared with the total stock demands (sum of all issue quantities). |
| OOB StockOut Cost | Optimal/Optimal/Best Stockout Costs | Annual Stockout Costs based on "Optimal" Reorder Level Methods and "Best" Forecast Method. |
| Projected Usage | Projected Usage | Projected Demand Values by month. |
| ROQ Usage Months | Expected Reorder Quantity as months (periods) of usage | Value based on the solution Recommended Reorder Point and Reorder Quantity. |
| Safety Stock weeks | Expected Safety Stock as weeks of usage | Value based on the solution Recommended Reorder Point and Reorder Quantity. |
| Stock-Out Cost | Stockout Incident | Cost (cost per demand during a stockout) |
| Stockout Cost | Expected Annual Stockout Cost | Value based on the solution Recommended Reorder Point and Reorder Quantity. |
| Supplier Lead Time Forecast (Average) | Supplier Lead Time (days) | An average of the most recent 24 preferred supplier ("SUP") receipts/lead times. Where there are no preferred suppliers that the alternative supplier receipts will be used. |
| Unit of Issue | Unit of Issue (unit of measure) | Extracted from the ERP. |
| Usage ABCD | Usage ABCD Code | Pareto analysis of annual usage value across items in a set. |
| Usage Forecast Months | Usage Forecast Months | The number of months to forecast. This field is user selectable up to 24 months. |
| Usage Last Period | Actual Usage Last Period (1 period ago) | Last months usage. |
| Usage Periods | Number of Periods (months) of Usage History | The number of actual month values to use for forecasting. |
| Year to date usage | Total Unscheduled Year to Date Usage | Unscheduled usage for the current calendar year. |