View the components of the demand forecast calculation for an individual product on the Demand Calculation Audit dialog box.
These values update each time you run the Update Demand Forecast program for the product.
To audit the demand calculation:
From the Maintenance menu, select Product to display the Product Maintenance window.
From the Inventory menu, select Primary Inventory Maintenance to display the Primary Inventory Maintenance dialog box.
Select a branch and, from the Edit menu, select Audit to display the Demand Calculation Audit dialog box for that branch.
The Product ID displays in the Product Description area. All fields on this window are view-only.
In the Transaction Information area, review the following fields, as needed:
Field |
Description |
Raw Hits for Period |
Number of hits recorded during the forecast period. The system uses the number of sales occurrences to determine the amount of sales history to review. |
Number of Bill-To Customers |
Number of individual customers billed for the raw hits during the forecast period. This value demonstrates whether the market or individual customers drive a product's demand. |
Median Sale |
Quantity sold on the median sale from the forecast period. |
Days Out of Stock |
Number of days the product's on-hand quantity was zero or less during the forecast period. By default, if you ship items directly from another branch to the customer to meet an order, fulfilling demand, the system does not count the product in your branch as out of stock. To change this setting, use the Control Forecast Parameters Maintenance control maintenance record and select the Exclude Ship From Different Branch check box. Note: This calculation uses transactions only as far back as when the item was created. |
Lost Sale Factor Used |
Lost sale factor used by the demand calculation. |
Largest Transaction |
Largest quantity sold on a single transaction during the forecast period. |
In the Demand Information area, review the following fields:
Field |
Description |
Date Last Calculated |
Date the Update Demand Forecast program was last run. |
Demand Pattern |
Whether the product is seasonal or non-seasonal. |
Demand Period Used |
Number of days in the forecast period. |
Raw Demand for Period |
Total quantity sold during the forecast period. |
Exceptional Quantity to be Excluded |
Quantity excluded from the demand calculation due to being an exceptional sale. |
Customer Demand Excluded |
Number of products excluded from the demand calculation. |
In the Trend Information area, review the following fields:
Field |
Description |
Trend Factor Used |
Trend factor, if any, used by the demand calculation. |
Automatic Trend |
Whether the automatic trend calculation is enabled for this product's demand calculation. Note: Use this figure to compare to the DEMAND (PER DAY) field on the Product Order Points/Line Points window to ensure that the audit demand is calculating correctly. |
Click OK to exit the dialog box.
See Also: