Forecasting for different online delivery methods
These days there are multiple delivery options: customers can still choose delivery to their door step, but equally they can pick items up from a store, a special collection point, or sometimes even the warehouse.
Of course the more options you offer the more complex the supply chain becomes, and that complexity also has implications for the planning side of things.
In most cases a businesss basic operations are unaffected by the choice of delivery method: a retailer sells goods on its website and then delivers them to the customer from its warehouse. Just the delivery address varies. To get a clearer overview of the importance of different delivery options within a business, it is often useful to use the relevant data in your supply chain system to analyse and report on the share and changes in usage patterns of different methods. In some instances it might even be useful to forecast different methods separately as it would enable you to plan your delivery operations more accurately and spot changes in the market more quickly.
With the click & collect-from-store model, adding collection information to each stores sales figures (as a separate time series) can also be useful as it gives you a better idea of which stores are the most popular collection points. The data could even be linked to assortment management: if a certain item is ordered for collection from a particular store with a certain degree of regularity that item could then automatically be added to the stores assortment. That both saves on future delivery costs and ultimately protects a businesses margins.
Especially in e-grocery, click & collect varies a little from the norm as goods are actually picked from a store, rather than delivered from a warehouse. In such a model you would need to organise the process slightly differently: in order to make sure there is sufficient stock in store, its necessary to combine click & collect orders with the store forecast, and integrate the order and inventory management process to include online sales.
In general it is important to build a planning set up for each situation, starting from the primary needs you have identified. With todays forecasting systems it is easy to have several, overlapping forecasts for different purposes, so it is vital to understand what actually drives the operational actions and focus on those drivers first.
We hope you find these ideas useful in your own business we have certainly seen our customers make effective use of the processes outlined here. Read more about solutions for e-commerce and omni-channel retailing.