Minimum Version Required: 22.06
Pre-Conditions
Forecast Locations must be set to True on Create Forecast Records to utilize the Forecasting tool.
Steps
How to Execute a Forecast
1. Using Universal Search, navigate to the Forecast dashboard
2. Apply filters in the Forecast Filters section
Select/Deselect Row and Forecast Header options to display
Apply Filters to selectively display by Location, Period Type (weeks or months), Forecast By (Product or Location), and more
3. Apply filters by Forecast Group, Supplier, Brand Family, Brand, or Product. NOTE: Use the Show/Hide toggle to display or hide Conditions
Optional: From the Condition picklist, select the Condition for the Forecast
Inventory Low: This will limit the list of products within the forecast group to just products that are below the target DOI
Oversold Forecast: This will limit products where the forecast percentage is less than zero. This means that from the beginning of the year, total sales have exceeded sales forecasts
5% Undersold: This will limit products where the forecast percentage is between 5% and 19%. This means the sum of all sales for the year is between 5% and 19% less than the forecast
20% Undersold: This will limit products where the forecast percentage is 20% or greater. This means the sum of all sales for the year is 20% or greater less than forecasted sales
New Products: This will limit products that have a time created within 7 days of today
4. Once clicked on Forecast Group, Supplier, Brand Family, Brand, or Product, this will populate product data within the Forecasting tool.
a. Select the Forecast Method
b. Click Forecast, this will generate all forecasts for the products shown.
Forecast: Auto-Forecasts. The browser will open a pop-up asking if you want to Auto-Forecast for all products.
Clear Out Forecasted Sales: Removes all values from the Forecasted Sales row, allowing the system to re-populate the row. The browser will open a pop-up asking to clear out all manually edited forecasted sales figures.
Zero Out Forecasted Sales: Enters zero for each cell in the row, generally used to estimate depletion over time of current inventory without replenishment. The browser will open a pop-up asking to zero out all manually edited forecasted sales figures.
c. Click to Expand All or select products to view individually
d. Buttons available under individual Products once expanded
Lock/Unlock Forecasted Data: Unlocking previously entered data in the Forecasted sales row allows the system to populate the cell upon updating/generating a forecast
Consider Production Schedule: It will open a page that will show the production schedule
Change Estimated Orders:
Clear Out Forecasted Orders - Removes all values from the Estimated Order row, allowing the system to re-populate the row for the individual product expanded.
Zero Out Forecasted Orders - Enters zeros for all values in the Estimated Order row for the individual product expanded.
5. Save Changes