Create a forecast manually

Firstshift.AI provides a flexible way to create forecasts for the products. The key highlights of Firstshift.AI are

• Ability to create a forecast for specific items with different forecast parameters.

• Ability to create a forecast as a scenario before publishing it to demand planning.

• Ability to adjust the forecast parameters based on the type of the product family

Forecast creation

Click the Create Forecast button on the forecast list screen to create a forecast. This will navigate you to the page where you can create a new forecast.

Steps to create a forecast

Attribute selection

1. Select the filter attributes.

   1. By default, product attributes are selected in the create forecast page.

   2. Users can add more attributes from the customer, location, and source.

2. Select the items 

   1. From the selected attributes, select the values from each attribute dropdown for which you want to create a forecast.

   2. Example: If the product and region attributes are selected from the filter attributes, then values under product and region must be selected.

3. Show advanced filter attributes:

   1. Advanced filters provide more granular control over the data displayed in forecast management. These filters can refine results based on specific characteristics, ensuring more precise analysis.

   2. Enable the toggle in the filter attribute dropdown to see the advanced attributes filter.

   3. Note: All the basic and advanced attributes are configuration driven.
      

4. Save as filter:

   1. You can save the filter criteria if needed. You can save it either as a Public filter or a Private filter

   2. Saving the filter is optional in forecast creation.

3. Public filter: If the 'public' option is selected, other planners can view the saved filters in the select filter panel.

4. Private filter: The saved filter is not visible to other users when the private option is selected.

5. Clear all:

   1. To replace the chosen attributes and items, click "Clear All."

   2. This will remove all the selected attributes and items. 

6. Select a saved filter:

   1. You can select an already saved filter from the select filter.

   2. Clicking the selected filter will display a panel showing all saved filters.

   3. Select any of the public and private filters to create a forecast.

7. Edit the attributes

   1. After selecting the attributes or saved filter, the criteria can be edited or modified based on the requirement..
      

Hierarchy level

By default, the selected hierarchy level is Product: All: All. If only the product attribute is added, this hierarchy will remain unchanged. 

However, if you select any other attribute, such as Customer or Location, the hierarchy will reset accordingly, as shown below.

To create a forecast, you must select the hierarchy level. Click the select hierarchy edit button to select the level.

Once clicked, the below popup will appear on the screen.

Select the level in the popup to see the results. If the results appeared blank, the selected input measure does not have data for the selected hierarchy level.

In this case, the planners can change the input measure to see the search results for the selected hierarchy level.

Forecast settings:

Time range and Input measure are the default settings on the create forecast screen.

Time range: The default time selected is the Next 12 months. Clicking on the time range will open a popup with available time ranges.

What to forecast: The application picks one measure as a default input measure from the available measures in the forecast. To select other input measures, click the input measure field, and a dropdown will appear below.

Advanced settings

Enable the Advanced Settings toggle to access additional configuration options for forecast creation. This will allow you to customize parameters such as outlier removal, confidence levels, forecast methods, and other advanced forecasting preferences.

Once the Advanced Settings toggle is enabled, all forecast configuration options will be displayed on the Create Forecast page. 

After enabling the advanced settings, all the forecast settings will be shown. These settings are similar to those created for the template.

1. Time horizon: The Historical Period and Forecast Period settings allow planners to define the time frames for analysis and forecasting:

   1. Historical Period: Planners can choose a specific date range (year and month) or select the "Entire History" option, which includes all available historical data for the selected items.

   2. Forecast Period: Planners can specify the year and month to generate forecasted values.

2. What to forecast: By default, Statistical forecast units and statistical forecast revenue are pre-configured output measures for the forecast creation.

   1. Output measure: To generate the forecast results, select units or revenue as an output measure.

   2. Input measure: The input measures will appear in the dropdown based on the selected output measure type.

3. Influencing factors include changes in market positions, such as the Consumer price index, Oil/gas prices, Raw material Costs, and Retail sales. Adding influence factors to the forecast is not mandatory, but you can do so to explain the reasons behind the decrease or increase in sales and demand. Selected factors will appear on the screen. You can remove them by clicking on the remove button.

4. Forecast methods: Firstshift.AI leverages Machine Learning, Deep Neural Networks, and advanced statistical models to generate the most accurate and reliable technical forecasts. Our system intelligently selects the best forecasting technique based on your data patterns, ensuring optimal results.

   1. The best model (let the forecast engine choose): If this option is selected, the system automatically determines the best forecasting model based on historical data patterns. AI-driven algorithms analyze trends, seasonality, and demand fluctuations to pick the most suitable model.

   2. Let me choose: If this option is selected, the planner can manually select a forecasting method from a dropdown menu. This allows planners to apply specific models, such as ARIMA, Holt-Winters, or Moving Averages, based on their preferences or business needs.

5. Remove outliers: Removing outliers from the data helps create more accurate forecasts by eliminating extreme values that could distort trends. However, it can also dampen the accuracy of statistical patterns, primarily if those outliers represent recurring business trends.

   1. Selecting ‘Yes’ will remove the outliers caused by temporary events that are unlikely to recur.

   2. Selecting ‘No’ will keep the outliers representing important business events (e.g., seasonal spikes or significant product launches).

   3. We recommend enabling outlier removal, which improves forecast reliability by focusing on core demand patterns rather than temporary anomalies.

6. Confidence level: You should select the confidence level for your forecast carefully, as it affects the reliability of your predictions.

   1. Higher confidence levels (e.g., 97.5%) provide more certainty but result in wider prediction intervals, meaning a broader range of possible outcomes.

   2. Lower confidence levels (e.g., 80%) produce narrower prediction intervals but with a greater chance of missing actual values.

   3. In general, choose higher confidence levels when you trust your historical data and need conservative estimates. Uncertainty increases for extended forecast periods, so balancing confidence and practical accuracy is key.

7. Disaggregation rules: 

• Consider the historical data of individual lower-level items.

This option allows the forecast engine to consider the historical data of each lower-level item while disaggregating the forecast from higher to lower levels. This way, the disaggregated forecast at the lower-level items is based on the weighted average of the historical data.

• Consider the historical pattern of individual lower-level items.

This option allows the forecast engine to consider the historical trend of individual lower-level items while disaggregating the forecast from higher to lower levels. For example, the forecast for items in the family is on an upward trend. However, the sales of one item in that family have fallen in the last few months. In this case, the new forecast disaggregated at the item level should consider the falling trend and predict accordingly

Once all the configuration is made, click the Run forecast button to create a forecast job.

Clicking Run Forecast will open a popup where you must decide the forecast's run options.

The application will automatically fill in the name of the forecast job. The name can be edited based on the planner's preferences.  

Run as a scenario: 

This option allows users to run forecasts, verify their accuracy, and adjust the forecast algorithm by modifying parameters. However, the forecast results will not be copied to the downstream time series. 

For example, if a tenant configuration stores forecast results in Statistical Forecast Units, these results are typically copied to the Consensus Demand Plan, Sales Forecast Units, and Marketing Forecast Units. When this option is selected, the application will not copy the statistical forecast units to these time series, allowing users to test and refine forecasts without affecting other business functions.

Run and publish forecast: 

This option runs the forecast and copies the results to the downstream time series.

• Copying forecast results to downstream time series

The application copies the statistical forecast results to downstream measures only for periods without overrides.

If the planners override the downstream measures for a few periods, the new forecast results will not be copied to those periods. However, they will be copied to the period in which the planner made no overrides.

For example, consider an item “Etab 2000 v1: Walmart: All: All.”

• The planner has submitted overrides for Sales manager forecast from Jan 2024 to April 2024

• A new statistical forecast is generated from Jan 2024 to Dec 2024.

• The new forecast will not be copied to the Sales manager forecast from Jan 2024 to April 2024, as the user has already submitted overrides. But the forecast will be copied from May 2024 to Dec 2024

After creating the forecast, its status will initially be "Not Started." To begin processing the forecast, click on the "Run" button, as shown below. The application will then pick up the job and start processing it.

To check the status of the created forecast, click on the "Refresh" button as shown below.