# AI Demand Forecasting: Balancing Overstock and Stock-Outs with Data

> AI demand forecasting combines sales history with promotions, seasons and holidays to suggest orders by product and branch. Data, accuracy and set-up steps.

Source: https://digitalbridge.com.tr/en/blog/ai-demand-forecasting.html
Publisher: Digital Bridge Teknoloji (https://digitalbridge.com.tr)
Topic: Artificial Intelligence
Published: 2026-10-11 · Updated: 2026-10-11

AI demand forecasting is the use of machine learning to predict next period's sales by product, branch or customer from past sales, seasonality, promotions, prices, holidays and, where relevant, the weather. The model links the forecast to safety stock and reorder points and gives planners an explained order recommendation. Its value lies in better purchasing and production decisions.

## Is planning still living in one person's spreadsheet?

In many businesses, the answer to "how much should we order?" sits in an experienced planner's spreadsheet and instincts. They look at the same month last year, decide "we will sell a bit more this time" and type in a number. That works while the range is small and the customer base stable. Once the range grows to thousands of items, the number of branches reaches dozens and promotions become frequent, two problems appear:

- **Scale:** one person cannot review hundreds of product-branch combinations every week. Attention goes to best-sellers, and the rest are planned as a copy of last week.
- **Continuity:** the knowledge lives in someone's head. When the planner goes on leave or moves on, the plan falters. It is a textbook case of [outgrowing spreadsheets](https://digitalbridge.com.tr/en/blog/outgrowing-spreadsheets.html).

The data is often not ready either. According to [TurkStat's ICT Usage in Enterprises Survey 2025](https://veriportali.tuik.gov.tr/tr/press/54012), 28.3% of Turkish enterprises with 10 or more employees use ERP software, yet only 6.5% use business intelligence (BI) software. Sales data is recorded but not analysed for decisions. The structure that makes it analysis-ready is a [data warehouse and ETL process](https://digitalbridge.com.tr/en/blog/data-warehouse-etl-guide.html).

## Forecast errors cost money in both directions

A forecasting error loses money whichever way it falls:

- **Overstock** ties up capital on the shelf and fills warehouse space. For products with a shelf life it becomes waste; for fashion or seasonal items it becomes markdowns.
- **Stock-outs** lose sales and send customers to competitors. In manufacturing, a missing raw material stops the line or forces urgent, expensive purchasing.

In food and fresh produce, the loss is visible on a global scale.

> FAO estimates that **13.3%** of food was lost globally in 2023 after harvest, on farms and in transport, storage, wholesale and processing (before reaching retail), rising to 25.4% for fruits and vegetables. ([FAO SDG 12.3.1 Global Food Loss Indicator](https://www.fao.org/sustainable-development-goals-data-portal/data/indicators/1231-global-food-losses/en/))

The consumer end of the chain tells a similar story. According to the [UNEP Food Waste Index Report 2024](https://www.unep.org/news-and-stories/press-release/world-squanders-over-1-billion-meals-day-un-report), 1.05 billion tonnes of food were wasted in 2022, with food services accounting for 28% and retail for 12%. Not all of this is down to forecasting, but decisions on how much to produce and order are among its direct drivers. For processors of farm produce, supply is uncertain as well as demand; estimating incoming volumes before harvest with [drone crop yield estimation](https://digitalbridge.com.tr/en/blog/drone-crop-yield-estimation.html) lets you see both ends of the plan. Other uses in the field are gathered in [AI in agriculture](https://digitalbridge.com.tr/en/blog/ai-in-agriculture-use-cases.html).

Then there is data quality. Data quality expert Thomas C. Redman estimates the cost of bad data at 15% to 25% of revenue for most companies ([MIT Sloan Management Review: Seizing Opportunity in Data Quality, 2017](https://sloanreview.mit.edu/article/seizing-opportunity-in-data-quality/)). In forecasting, this shows up as errors such as treating "zero sales" on out-of-stock days as zero demand, or failing to net returns off sales; we cover these problems in [data quality and duplicate records](https://digitalbridge.com.tr/en/blog/data-quality-duplicates.html).

## Which forecasting method, and when?

| Method | How it works | Best suited to | Limitation |
|---|---|---|---|
| Moving average / same period last year | Averages past periods | Few products, stable demand | Blind to promotions and trends |
| Statistical time series (e.g. exponential smoothing) | Separates trend and seasonality | Products with a regular season | Limited handling of external factors (price, holidays, weather) |
| Machine learning models | Learns sales history together with price, promotions, holidays and weather | Many products, many branches, frequent promotions | Needs clean data with enough history |
| Hierarchical approach | Keeps forecasts consistent across total, category and item levels | Portfolios with many slow-moving items | Requires more design effort |

In practice, a good system does not commit to one method; it tests which method performs best on historical data for each product group. Because sales history already sits in the ERP, demand forecasting is one of the data-ready first projects to consider when [starting with AI in business](https://digitalbridge.com.tr/en/blog/ai-in-business-where-to-start.html).

## A practical framework: demand forecasting in seven steps

1. **Define the decision.** Which decision will the forecast feed: weekly branch orders, monthly raw-material purchasing, [production capacity](https://digitalbridge.com.tr/en/blog/production-scheduling-aps.html)? The horizon and frequency of that decision set the forecast level (item-branch-week or category-month).
2. **Collect and clean the data.** At least two years of sales, returns, out-of-stock days, prices and the promotion calendar. Days when nothing sold because there was nothing on the shelf must not be recorded as "no demand". [Anomaly detection](https://digitalbridge.com.tr/en/blog/anomaly-detection-guide.html) methods help filter out one-off bulk orders and data-entry errors.
3. **Add external factors.** Public and religious holidays, school terms, promotions, competitor activity and, where relevant, the weather. In Türkiye, religious holidays move through the calendar each year, and models built on fixed calendar months often miss them. Using the forecast to set the price itself is the subject of [AI dynamic pricing](https://digitalbridge.com.tr/en/blog/ai-dynamic-pricing.html).
4. **Backtest.** Train the model on part of the history, have it forecast the following period and compare with actuals. Race it against your current method, including the planner's own numbers, over the same period.
5. **Choose the right metric.** Alongside item-level error, track volume-weighted error and bias (whether the forecast is consistently high or low). Percentage errors can mislead on slow-moving items.
6. **Link the forecast to a stock rule.** The forecast and its uncertainty feed safety-stock and reorder-point calculations, and the output is an order recommendation. For products with a shelf life, this rule must work alongside [FIFO and FEFO inventory methods](https://digitalbridge.com.tr/en/blog/fifo-fefo-inventory-methods.html).
7. **Keep the planner in the loop.** The model provides the starting figure; the planner adjusts it for what they know (a new customer, a supply issue). Adjustments are recorded, and the next period shows whether they improved the forecast.

The same method answers other questions too. We show how forecasts turn into order and inter-store transfer decisions in [retail inventory optimisation](https://digitalbridge.com.tr/en/blog/retail-inventory-optimisation.html), and how sites predict their hourly energy needs in [electricity load forecasting](https://digitalbridge.com.tr/en/blog/electricity-load-forecasting.html).

## How we set up AI demand forecasting at Digital Bridge

Our [demand forecasting and predictive analytics](https://digitalbridge.com.tr/en/technology-hardware/demand-forecasting-analytics.html) service starts not with the model but with the decision the forecast will change. However accurate it is, a forecast that does not change a purchasing or production decision is just a report.

- **Data review:** we go through your ERP, POS, e-commerce and warehouse records with you and identify missing or inconsistent data. If data is scattered, we first build the foundations with a [data warehouse](https://digitalbridge.com.tr/en/data-analytics/data-warehouse.html) and [data governance and quality](https://digitalbridge.com.tr/en/data-analytics/data-governance-quality.html) work.
- **Model and backtest:** we build models that combine your sales history with seasonality, promotion effects, public holidays and, where relevant, the weather, and compare them with your current method over a past period. We review the results with you.
- **Tying it to decisions:** we link the forecast to safety-stock and reorder-point calculations and post order recommendations to your [ERP](https://digitalbridge.com.tr/en/software-solutions/erp-enterprise-resource-planning.html). The planning team does not have to move to a new program; they see the recommendation and its reasoning on [BI dashboards](https://digitalbridge.com.tr/en/data-analytics/bi-dashboard.html).
- **The warehouse side:** a forecast only makes sense against a system that knows what is really on the shelf. If your stock records do not match reality, we use [warehouse and inventory management (WMS)](https://digitalbridge.com.tr/en/software-solutions/warehouse-inventory-management-wms.html) to capture every movement by barcode as it happens, so the forecast runs on true stock. Our [warehouse management system guide](https://digitalbridge.com.tr/en/blog/warehouse-management-system-guide.html) covers this in more detail. For other AI uses in the warehouse, see [AI in logistics and warehousing](https://digitalbridge.com.tr/en/blog/ai-in-logistics-and-warehousing.html).
- **The production side:** for manufacturers, we connect the forecast to capacity and shift planning through [production planning and scheduling (APS)](https://digitalbridge.com.tr/en/industry-40/production-planning-scheduling-aps.html). How the forecast becomes a schedule is explained in [AI production scheduling](https://digitalbridge.com.tr/en/blog/ai-production-scheduling.html).

The scenarios we meet most often are branch-level ordering in chain stores, fresh products and waste in food production, dealer shipments in wholesale distribution, pre-promotion stock building in e-commerce, and spare-parts demand in service businesses. Our [retail and chain stores](https://digitalbridge.com.tr/en/industry-solutions/retail-chain-stores.html) page looks at branch-level planning in particular.

## How will you measure the value?

A forecasting project should be judged by [well-chosen KPIs](https://digitalbridge.com.tr/en/blog/how-to-set-kpis.html), not model error alone: stock turnover, number of out-of-stock days, waste and write-off value, number of urgent orders, and the time planners spend on weekly planning. Record baseline values for these before the project starts, or it becomes hard to prove the gain. For the method, see our guide to [measuring AI project ROI](https://digitalbridge.com.tr/en/blog/measuring-ai-project-roi.html).

We also recommend measuring forecast value added: checking whether each step (statistical model, AI model, planner adjustment) actually improves on the one before it. In some product groups a simple method beats a complex model, and some manual adjustments make the forecast worse. Measuring this directs effort to where it really adds value and grounds trust in the model on evidence.

In retail, adding store traffic to sales data can strengthen a forecast; our guide to a [retail people counting system](https://digitalbridge.com.tr/en/blog/retail-people-counting.html) explains how to collect footfall data.

## Next step

Start with the product group that causes you the most trouble: the one with the most waste or the most frequent stock-outs. Export two years of sales, returns and promotion records for it. Then [get in touch](https://digitalbridge.com.tr/en/contact.html); we will review your data together, run a backtest on that product group and show in numbers whether the model beats your current method. For AI use cases beyond forecasting, browse our [complete Artificial Intelligence guide](https://digitalbridge.com.tr/en/blog/topic/yapay-zeka.html).

## Frequently Asked Questions

### How much historical data does demand forecasting need?

At least two years of sales history is recommended to capture seasonality; with one year, only short-term forecasts are realistic. Returns, out-of-stock days, prices and the promotion calendar are needed alongside sales. For new products, the history of similar items is used.

### Will AI demand forecasting replace our planners?

No. The model produces a starting figure with visible reasoning for hundreds of products and branches, and the planner adjusts it with what they know. Adjustments are recorded and measured in the next period to see whether they improved the forecast.

### How is forecast accuracy measured?

By having the model forecast a past period and comparing the result with actual sales. Beyond item-level error, volume-weighted error and bias (a consistently high or low forecast) are tracked. The most meaningful comparison is against how your current method performed over the same period.

### Does demand forecasting work with our ERP?

Yes. Forecasts and order recommendations can be posted to your ERP and BI dashboards through system integration, so the planning team keeps working on familiar screens. Sales, stock and promotion data flow in the same way, automatically, from ERP, POS, e-commerce and warehouse systems, so the forecast refreshes each period without anyone preparing files by hand.

### What does an AI demand forecasting project cost?

Cost depends on the number of products and branches to forecast, how scattered the data is and how much cleaning it needs, the ERP, POS and warehouse systems to connect, whether the forecast drives order recommendations or a production plan, and reporting needs. Digital Bridge does not sell an off-the-shelf package; after a needs analysis, it provides a written proposal covering scope, phases and cost.

### How are promotions and religious holidays reflected in the forecast?

The promotion calendar, price changes, and public and religious holidays are fed to the model as separate variables. That way, the model can learn, for example, the pre-holiday demand spike for a holiday that falls on a different date each year, independent of the calendar month.