Automating Raw Material Ordering for Ready‑to‑Eat Food Production
The assortment includes 80 ready‑to‑eat SKUs, and demand must be forecasted per store, per day, with a six‑week horizon. The number of stores is 1,260.
Step 1. Forecasting demand by SKU and store
Demand forecasting is performed using machine learning methods that take into account factors such as promotions, seasonality, trends, weekdays, holidays, and weather conditions. Manually accounting for all these factors is practically impossible, so using ML models at this stage is justified due to their flexibility and ability to identify complex dependencies.
Step 2. Translating demand for finished products into ingredient requirements
Each dish has a recipe that defines its ingredients and proportions. Once demand for the dish is forecasted based on sales, the required amount of each ingredient can be calculated.
Step 3. Mapping ingredients to purchase SKUs (raw materials and supplies)
An ingredient is an abstract concept in the accounting system that links the recipe to a specific SKU. For example, a dish may contain tomatoes. Depending on the season, these may be “Turkish” or “domestic” tomatoes. For the dish, the specific SKU does not matter, but for the business it does — and priorities may change over time. For such cases, a mapping directory is needed. It allows converting an ingredient into a specific purchase SKU.
Step 4. Calculating purchase requirements for each SKU
Recipes allow calculating the ingredient requirement per unit sold. The mapping directory allows converting ingredients into purchase SKUs. Thus, based on direct sales forecasts, the required amount of raw materials (linked to specific SKUs) for production can be obtained.
Step 5. Automatic generation of purchase orders
Forecasting and order generation are moved outside the accounting system and the transactional data storage layer — ideally into a cloud environment. This approach avoids overloading the system when running ML algorithms and significantly speeds up calculations.
Generated orders are transmitted via API to the accounting system, where centralized purchase orders for suppliers are created.
Forecasting ingredient consumption using machine learning reduces labor intensity by automating the planning process. As a result, labor costs were reduced by half. Forecast accuracy improved, which allowed reducing markdowns and write‑offs by 25%.