1 Introduction: Demand Forecasting
Oracle Retail Inventory Planning Optimization Cloud Service-Demand Forecasting (IPOCS-Demand Forecasting) provides accurate forecasts that enable retailers to coordinate demand-driven outcomes that deliver connected customer interactions. With a single view of demand, IPOCS-Demand Forecasting provides pervasive value across retail processes, including driving optimal strategies in planning, increasing inventory productivity in supply chains, decreasing operational costs and driving customer satisfaction from engagement to sale to fulfillment. IPOCS-Demand Forecasting is a comprehensive solution that maximizes the forecast accuracy for the entire product lifecycle, the ability to adapt to recent trends, seasonality, out-of-stocks and promotions, and reflect the unique demand drivers of each retailer. Today's progressive retail organizations know that store-level demand drives the supply chain. The ability to forecast consumer demand productively and accurately is vital to a retailer's success. The business requirements for consumer responsiveness mandate a forecasting system that more accurately forecasts at the point of sale, handles difficult demand patterns, forecasts promotions and other causal events, processes large numbers of forecasts, and minimizes the cost of human and computer resources. Forecasting drives the business tasks of planning, replenishment, purchasing, and allocation. As forecasts become more accurate, businesses run more efficiently by buying the right inventory at the right time. This ultimately lowers inventory levels, improves safety stock requirements, improves customer service, and increases the company's profitability.
This guide contains these chapters and appendices for the IPOCS-Demand Forecasting module:
Forecasting Challenges and IPOCS-Demand Forecasting Solutions
A number of challenges affect the ability of forecast demand accurately including:
Selecting the Best Forecasting Method
One challenge to accurate forecasting is the selection of the best model to account for level, trending, seasonal, and spiky demand. Oracle Retail's automatic evaluation of several methods eliminates this complexity. The automated approach can pick the best fit method among a large selection, like Simple Exponential Smoothing, Holt Exponential Smoothing, Additive and Multiplicative Winters Exponential Smoothing, Croston's Intermittent Demand Model, and Seasonal Regression forecasting.
Another approach is to combine the output of the competing methods to create a more robust forecast and minimize the risk of overfitting.
Overcoming Data Sparsity Through Escalation and Pooling Levels
Demand at low levels, such as item/store, is usually too noisy to identify clear selling patterns, both for baseline and promotional sales. In such cases, generating a reliable forecast requires analyzing historical data at a higher level (escalation or pooling levels) in the hierarchy in which demand patterns can be consistently detected. The forecasting components estimated at these high levels, like seasonality curves and promotion effects, are combined with low level information, like base demand and trend, to create the low level forecast that is needed to drive the supply chain.
Forecasting Demand for New Products and Locations
IPOCS-Demand Forecasting also forecasts demand for new products and locations for which no sales history exists. There are several options for new products. First, there is the option to go on auto mode, and the user does not have to do anything. Another option is model the new product's demand based on that of an existing similar product for which you do have a history. The existing item selection can be automatically done by matching item attributes. There is also the option to manually select the item. Forecasts for the new products are copied from one item or can be a combination of multiple items. The level for the new products are copied from Like Item, the seasonal curve, and the promotional effects are from escalation.
Managing Forecasting Results Through Automated Exception Reporting
The IPOCS-Demand Forecasting end user is typically responsible for managing the forecast results for thousands of items, at hundreds of stores, across many weeks at a time. The Oracle Retail Predictive Application Server Cloud Edition (RPASCE) platform provides users with an automated exception reporting process that indicates to you where a forecast value may lie above or below an established threshold, thereby reducing the level of interaction needed from you. The framework for exception management is implemented using multiple features.
First, there are the approval exceptions, where the forecasts are run through business rules to determine if forecasts need review. For the forecasts that need review, a second layer of exceptions is available, to determine the priority in which the review should happen. This is implemented using the rules in the Business Rules Engine. In the exception dashboard profile, a user can filter down to different levels of merchandise/locations to view a hit count and the variance from the desired value of the forecast. She can then go to the Navigation exceptions tiles and launch in a workspace where she can review the exceptions sorted in order of priority as defined by business rules.
In the exception dashboard profile, the user can filter down to different levels of merchandise/locations to view a hit count and the variance from the desired value of the forecast. The user then goes to the Navigation exceptions tiles and launches in a workspace to review the exceptions sorted in order of priority as defined by business rules.
Once in the workspace, the user navigates to flagged positions using the workspace alerts which are synchronized with the exception dashboards. When an exception is resolved, the result is committed to the domain, and the dashboard exception count— upon refresh—reflects the change.
Incorporating the Effects of Promotions and Other Event-Based Challenges on Demand
Promotions, non-regular holidays, and other causal events create another significant challenge to accurate forecasting. Promotions such as advertised sales and free gifts with purchase might have a significant impact on a product's sales history, as can fluctuating holidays such as Easter. The causal forecasting functionality estimates the effects that such events have on demand. The results are used to predict future sales when conditions in the selling environment are similar. This type of advanced forecasting identifies the behavioral relationship of the variable you want to forecast (sales) to both its own past and explanatory variables such as promotion and advertising.Suppose that your company has a large promotional event during the Back To School season each year. The exact date of Back To School varies from year to year; as a result, the standard time-series forecasting model often has difficulty representing this effect in the seasonal profile. The Promotional Forecasting module allows you to identify the Back To School season in all years of your sales history, and then define the upcoming Back To School date. By doing so, you can causally forecast the Back To School-related demand pattern shift.
53 Week Calendar
For the majority of retailers, the business is managed using a calendar (364 days organized into 13 week quarters) that periodically includes an extra 53rd week so that the year end stays in about the same time of the year. It is useful to have some control over how this 53rd week will be managed within the forecasting system's time dimension. Management of this issue causes customers the pain, time and cost of configuring their data every few years that this happens.
The problem described has two implications. The first case is when two years—each with 52 weeks—of historical sales are available, and the retailer needs to forecast for the following year, which has 53 weeks. The second case is when one of the years of historical sales has 52 weeks, and the other has 53 weeks.
The correction for the extra week happens as part of forecasting. IPOCS-Demand Forecasting creates a measure Week 53 indicator with the base intersection that is entered by the user in the IPOCS-Demand Forecasting plug-in. This measure has to be loaded by the user.
There is also the Week 53 options measure, that indicates how to calculate the forecast value for a week that was flagged as 53rd, or extra week. This measure can be accessed in the Forecast Setup Workbook.
Forecasting Process
The forecasting process represents a next generation approach engineered to provide transparency, responsiveness and accuracy through the application of retail sciences using the scale of our modern Retail Cloud Platform.
-
Transparency enables analytical processes and end-users to understand and engage with the forecast. This is accomplished by representing the demand model as the decomposition of intuitive components that include base rate of demand, seasonality and causal effects. The forecasting process provides transparency to the final results, individual model components and underlying decisions by the system and end-user.
-
Responsiveness enables the coordination and simulation of demand-driven outcomes using forecasts that adapt immediately to new information and without a dependency on batch processes. This is accomplished by separating the calculation of the forecast from the analytical processes that determine components within the forecasting model.
-
Accuracy enables retailers to deliver connected customer interactions while driving efficiencies to increase profits. Maximizing forecast accuracy is paramount to IPOCS-Demand Forecasting. This is accomplished through the application of best-fit sciences throughout the forecasting process.
The forecast engine powering IPOCS-Demand Forecasting is the same that powers all solutions in the Retail AI Foundation Cloud Service platform. The separation of the workflow in IPOCS-Demand Forecasting and the forecast engine, allows much more flexibility in evolving the two pieces separately.
Process Summary
Following is a summary of the forecasting process:
-
Prepare Reference Data
The purpose of this step is to prepare reference data for subsequent estimation, pruning and escalation processes. The emphasis in the preparation processes is to treat anomalies in historical data, such as out-of-stock, outliers and promotions, where the objective is to increase reliability of the reference data.
-
Estimated Demand Parameters
The purpose of this step is to estimate all demand parameters and at all possible escalation levels. An escalation level represents a grouping of items and locations for robust parameter estimation to overcome sparsity and sensitivity. Escalation levels can be tied to explicit hierarchy levels (for example, subclass/region) or flexible item/location groupings (for example, optimized analytical clusters). As each demand parameter is estimated, multiple machine learning methods are applied, individually optimized and evaluated for accuracy. The final model can represent the best-fit method or a robust method calculated as an intelligent blending of multiple methods weighted by accuracy.
-
Prune
The purpose of this step is to prune escalation levels that do not pass analytical quality checks. These include data, estimation and correlation quality checks. The result is a candidate pool of high quality parameter estimates for the escalation process.
-
Escalate
The purpose of this step is to select the demand parameter estimate for each component of the forecast model using the candidate pool of escalation levels. The escalation process reflects the optimal balance of richness and reliability.
-
Forecast
The purpose of this step is to calculate the forecast through the application of demand parameter estimates from the analytical processes in conjunction with the known demand drivers and user-overrides. The demand model is completely responsive to changes in demand drivers and updates to the demand model itself (for example, user-defined override). This step also includes support for responsive new-item forecasting, with tailored approaches for new-item scenarios, such as dynamic, repeatable and similar assortments.
User Experience and Workflow
The user experience is delivered on our experience-inspired RPAS Cloud Edition (RPASCE) user interface (UI). RPASCE provides end-users with a next generation cloud-native UI that is purpose-built to accelerate intent into action for planners and forecasters. This includes interactive and visual dashboards to assess priorities, responsive and flexible workspaces to implement decisions and a coordinated exceptions framework that ties business process all the way from dashboard to cell.
The business process is engineered to maximize the productivity of end-users through exception-driven processes and emphasis on workflow simplification. The day-in-the-life processes begin with dashboard views that enable the end-user to assess the effectiveness and quality of their forecasts and prioritize exceptions. From the dashboards, the end-user is able to contextually launch into the appropriate workspace. For exception-driven processes, the end-user is guided to the point-of-resolution, with visibility to progress and the ability to iteratively work through forecasting priorities throughout the day.
Dashboard Views and Workspaces
The dashboard views and workspaces that support day-in-the-life forecasting workflows are summarized as follows:
-
Forecast Overview Dashboard
This dashboard leads with Key Performance Indicators (KPIs) that provide macro-level insight into forecasting priorities and the effectiveness of the forecasts in driving demand-driven outcomes. This enables end-users to assess forecasting complexity drivers, such as frequent promotions, and forecasting performance towards business objectives, such as fill rates.
-
Forecast Scorecard Dashboard
This dashboard provides insight to forecast accuracy (for example, MAPE, Bias) along with clear visibility to system performance and the impact of end-user contributions to the forecasting process. This enables forecast analysts and managers to identify forecast process improvement priorities.
-
Exception Dashboards
The exception dashboards represent the primary starting point for day-in-the-life processes. The approval and navigation exceptions each have a dedicated dashboards that enables end-users to efficiently drive decisions through focused exception-driven processes. From here, end-users can define the scope of exceptions to be managed through dashboard filters and launch directly to workspace views tailored for resolution. As exceptions are resolved, the dashboard is updated to enable end-users to iteratively work through forecasting priorities.
-
Forecast Review Workspaces
The forecast approval workspaces represent the primary point of interaction with the demand forecasts. The navigation exceptions and their workspace counterparts allow you to review forecast information guided by priorities that are dynamically implemented in the Business Rule Engine. This is supported by a rich set of decision support metrics and the ability to responsively simulate forecast updates.
Forecast Engine
Not visible to the end user is the forecast engine, and all the tasks happening behind the scenes. The forecast engine produces a single version of forecast that is used in IPOCS-Demand Forecasting, all Retail AI Foundation Cloud Service solutions, as well as planning and merchandising. The batch is split between estimation and forecasting. Estimation consists of the heavy data mining of historical demand to generate the necessary forecast parameters like seasonality, price and promo effects. Following are tasks which comprise the estimation workflow within the Retail AI Foundation Cloud Service.
Refer to the Oracle Retail Science Cloud Services User Guide for details on the methodology used for forecast generation.
Figure 1-1 IPOCS-Demand Forecasting Estimation
![IPOCS-Demand Forecasting Estimation IPOCS-Demand Forecasting Estimation](img/next_gen_est.jpg)
After estimation is run, the forecast parameters are computed, and everything is available to generate the forecast.
The forecast generation is happening in the forecast engine, while all the workflow-related activities are happening in the IPOCS-Demand Forecasting solution.
Figure 1-2 Forecasting for IPOCS-Demand Forecasting
![IPOCS-Demand Forecasting Forecasting IPOCS-Demand Forecasting Forecasting](img/next_gen_forecast19.jpg)