HOW TO USE THIS MODULE”Forecast Analysis Report”
Upon installing this module, an additional tab labeled “More Info” will be visible in the Product Master section. Here, you can define various product details such as product category, product type, product brand, sub-category, and sub-type, providing comprehensive information for efficient cataloging and organization.
Within the Reporting Menu, you have the option to access the Forecast Analysis Report.
A popup window will appear, allowing you to specify the duration from a list of selections provided. You can choose from the following options:
– Last 3 months
– Last 6 months
– Last 12 months
– Last 24 months
– Last 36 months
This selection enables you to customize the time frame for your analysis as per your preference.
If no filter is selected, the system will display all products along with their corresponding Sales Quantity, On Hand values, Pending Stock, and Minimum Stock levels. The suggested status on the right side represents the forecasted quantities for each product.
By clicking on each product, you will access a detailed form view containing all the product’s information. In this specific instance, the product’s On Hand Quantity is 8, while the forecasted quantity stands at 128. Consequently, the pending quantity is calculated as 120.
In another scenario, if the Product On Hand Quantity is 80 and the sales quantity is 5, the suggested or forecast quantity will be 75. This data is used for generating the Consumption Report based on product category.
Forecast analysis can also be conducted for specific products based on their category, type, and brand.
Analysis report categorized by product category.
We also offer an additional feature where you can add buffer quantities to the products. For instance, a 10% buffer quantity is specified for the product category “Furniture.”
As observed in the reference image above, the suggested quantity has been increased by 10%.
Reviews
There are no reviews yet.