I Need Forecasting. How do I start? Realize these benefits in 2018!


Sales forecasts are the lifeblood of a business. They help you budget and manage your business. With good forecasting, a company can improve its operational performance and cash flow through inventory management. It lays out our assumptions so that changes can be managed effectively and strategic decisions can be made for what is working or not working.

If your company doesn’t currently have forecasting, here are some steps to get you started:

  • Forecasting is a collaborative effort. This is the first step in the Forecasting process. There must be buy-in and input from almost department of the company. Forecasts are influenced by every department of the company and greatly affect every area of the company. For example, there is only so much Production Capacity. But, with good forecasting, receipts can be staggered and priority can be given to the most profitable items.
  • It is imperative to use Clean Data. You do not want “Garbage In, Garbage Out.” Your products should be categorized correctly in a meaningful hierarchy. Attributes should be assigned to all items so that like items can be grouped together and analysis can be performed. It is also important to make sure your sales and inventory records are accurate.
  • Determine your selling curves. This is Time Series Analysis and it is the best method to predict future selling. It is based on previously observed values of the manner in which a product sells – data points are indexed in time order. Each week is given a value in relation to other weeks of the year. Items with similar selling curves can be grouped together. Your company can have many different sales curves: the key is to determine what are the correct attributes to use to determine these curves. For example, it could be seasonality (winter vs. summer) or brand (one brand may sell at different times of the year than another brand due to marketing efforts.)
  • Work with your IT Department. Make sure you are getting accurate imports into your Forecasting Tool, such as Purchase Orders, Receipts, Shipments, Sales Orders, Vendor Information. Sales should be recorded when inventory changes hands and inventory counts should be done periodically.
  • Determine a Starting Forecast for each SKU. You are the expert in your business because of your experience. You could start with LY, but then make adjustments. You know the changes that are happening in your Marketplace and should take these into account when determining your forecast. Some other levers to consider: marketing efforts, new competition, past missed sales. The forecast should be broken out by month (or week) according to the assigned sales curves. Roll these forecasts up and adjust as necessary according to company strategies.
  • You are then ready to begin analyzing current trends against your starting forecast. Using recent sales history (often 4-8 weeks), you can project future sales based on each item’s sales curve. Then, compare that to inventory you have on hand and on order. Do you have enough inventory to cover future sales? Do you have too much? Once future sales are projected, you can pull different levers to ensure profitability is maximized. For example, if you are understocked, you can place more purchase orders or raise prices to slow demand. If you are overstocked, you can try to cancel purchase orders or lower prices and add marketing.

The benefits of good forecasting are far-reaching through a company. It’s not too late to start the Forecasting Process and realize these benefits in 2018!