Generating Forecasts for MFP
Before you can complete an MFP implementation, you must set up and run forecasting within AI Foundation Cloud Services. Review the steps below for the initial setup of Forecasting:
-
In Manage Forecast Configurations in the AI Foundation UI, start by setting up a run type in the Setup train stop.
-
Click the + icon above the table and fill in the fields in the popup. For MFP forecasting, the forecast method should be selected as Automatic Exponential Smoothing.
-
Create a run type for each forecast measure/forecast intersection combination that is required for MFP.
-
Create test runs in the Test train stop once you are done setting up the run types:
-
Click a run type in the top table, then click on the + icon in the bottom table to create a run.
-
If necessary, change the configurations parameters for the estimation process and forecast process in their respective tabs in the Create Run popup.
For example, if you want to test a run using Bayesian method, edit the Estimation Method parameter in the Estimation tab using the edit icon above the table.
-
After modifying and reviewing the configuration parameters, click the Submit button to start the run.
-
-
Once the run is complete, the status changes to Forecast Generation Complete.
Doing test runs is an optional step. In addition to that, you will need to modify and review the configurations of the run type, activate the run type, enable auto-approve and map the run type to the downstream application (in this case to MFP). In the Manage train stop, select a row, click Edit Configurations Parameters and edit the estimation and forecast parameters as needed. Once you are done, go to Review tab, click Validate, then close the tab.
Note:
If the run type is active, you will only be able to view the parameters. To edit the parameters, the run type must be inactive.To activate the run type and enable the auto-approve, select a run type in the table and click the corresponding buttons above the table. Lastly, to map the run type to MFP, go to the Map train stop and click the + icon to create a new mapping.
When configuring forecasts for the MFP base implementation, the following list of forecast runs may be required, and you will want to configure and test each run type following the general workflow above. Additional runs can be added to satisfy your MFP implementation requirements.
Note:
The “Channel” level in MFP is often referred to as “Area” level in RI and AI Foundation, so be sure to select the correct levels which align to your hierarchy.MFP Plan | MFP Levels | Method | Data Source | Measure |
---|---|---|---|---|
MFP Merch Target |
Department-Channel-Week |
Auto ES |
Store Sales |
Regular and Promotion Gross Sales Amt |
MFP Merch Target |
Department-Channel-Week |
Auto ES |
Store Sales |
Clearance Gross Sales Amt |
MFP Merch Target |
Department-Channel-Week |
Auto ES |
Store Sales |
Regular and Promotion Gross Sales Unit |
MFP Merch Target |
Department-Channel-Week |
Auto ES |
Store Sales |
Clearance Gross Sales Unit |
MFP Merch Target |
Department-Channel-Week |
Auto ES |
Store Sales |
Total Returns Amount |
MFP Merch Target |
Department-Channel-Week |
Auto ES |
Store Sales |
Total Returns Units |
MFP Merch Plan |
Subclass-Channel-Week |
Auto ES |
Store Sales |
Regular and Promotion Gross Sales Amt |
MFP Merch Plan |
Subclass-Channel-Week |
Auto ES |
Store Sales |
Clearance Gross Sales Amt |
MFP Merch Plan |
Subclass-Channel-Week |
Auto ES |
Store Sales |
Regular and Promotion Gross Sales Unit |
MFP Merch Plan |
Subclass-Channel-Week |
Auto ES |
Store Sales |
Clearance Gross Sales Unit |
MFP Merch Plan |
Subclass-Channel-Week |
Auto ES |
Store Sales |
Total Returns Amount |
MFP Merch Plan |
Subclass-Channel-Week |
Auto ES |
Store Sales |
Total Returns Units |
MFP Location Target |
Company-Location-Week |
Auto ES |
Store Sales |
Total Gross Sales Amount |
MFP Location Target |
Company-Location-Week |
Auto ES |
Store Sales |
Total Gross Sales Unit |
MFP Location Target |
Company-Location-Week |
Auto ES |
Store Sales |
Total Returns Amount |
MFP Location Target |
Company-Location-Week |
Auto ES |
Store Sales |
Total Returns Units |
MFP Location Plan |
Department-Location-Week |
Auto ES |
Store Sales |
Total Gross Sales Amount |
MFP Location Plan |
Department-Location-Week |
Auto ES |
Store Sales |
Total Gross Sales Unit |
MFP Location Plan |
Department-Location-Week |
Auto ES |
Store Sales |
Total Returns Amount |
MFP Location Plan |
Department-Location-Week |
Auto ES |
Store Sales |
Total Returns Units |