--- title: "Feature of the month: Building forecasts from history in Dynamics AX" description: Building forecasts from history in Dynamics AX image: https://2044671.hs-sites.com/hubfs/Blogs_photos/Forecasts_from_history.png --- [Support](http://www.adifo.com/support) - [en](http://blog.adifo.com/en) - [nl](http://blog.adifo.com/nl) - [de](http://blog.adifo.com/de) - [中文](http://blog.adifo.com/cn) [![Adifo](https://2044671.hs-sites.com/hubfs/Adifo_May2016/Images/logo-2.svg)](http://www.adifo.com) Menu # Blog # Feature of the month: Building forecasts from history in Dynamics AX by [Janne Denolf](https://2044671.hs-sites.com/en/author/janne-denolf) 11 Feb 2016 [![Building forecasts from history in Dynamics AX](https://2044671.hs-sites.com/hs-fs/hubfs/Feature_of_the_Month/Building_forecasts_from_history.jpg?width=800&name=Building_forecasts_from_history.jpg "Building forecasts from history in Dynamics AX")](http://blog.adifo.com/en/topic/feature-of-the-month) *Every month we publish a "feature of the month" where we ask one of our consultants to highlight a feature in [MILAS AX](http://www.adifo.com/products/milas-ax-logistics-and-financials) (our specific ERP modules for Microsoft Dynamics AX). This month Tim De Ryck shares his insights.* Since most businesses operate in an atmosphere of uncertainty, forecasting is considered a critical and, therefore, an indispensable step. Next to the improved purchase and sales planning, forecasting will allow you – amongst other things – to improve inventory controls and financial planning: - Having valuable forecasting reports at your disposal will lead to improved inventory management, resulting in fewer out-of-stock and overstock situations. - Anticipating sales will stand your business in good stead to better predict your turnover and profits. All in all, more, and especially more accurate, **forecasts will undoubtedly improve your business’ chances of success**. In several industries, such as the feed and food industry, sales and purchase patterns are predictable as they recur over time (e.g. due to seasonality). In such sectors, building forecasts from history provides the business with an accurate outlook on the future. To support the forecasting process, [MILAS AX](http://www.adifo.com/products/milas-ax-logistics-and-financials) offers a user-friendly and flexible tool: “Forecasts from history”. ## **Forecasts from history in MILAS AX** The “Forecast from history” tool allows you to generate a (purchase/sales) forecast per item based on specified transaction types within a specified time range. The following steps are taken when applying this MILAS AX module: - Select a **historical** timespan; - Select the transactions types on which you want to build your forecasts. For instance, for **semi-finished products**, users can select the transaction types “Production consumptions” and “Sales orders”; - Select a calendar. Users can opt for a calendar that excludes weekends and national holidays; - Select a site. Applying these steps results in an average quantity per (work) day. If needed, this quantity can be adjusted automatically by a scaling factor, which can be overruled by the forecaster.Based on this quantity, a (purchase/sales) forecast can be built. To do so, the following steps are taken: - Select a **future** timespan; - Select a forecast model. For instance, users can select a model in which the first half of the timespan has a higher relative weight (due to seasonality); - Select a calendar. **Practical example** To illustrate the theory described above, let’s take the following basic case as an example: - Days = 30 (e.g. the last month); - Working days = 21; - The item was used in 15 production runs. In total = 26780kg; - The item was 10 times sold. In total = 10380kg; - Result: - Quantity per working day: (26780+10380)/21 = 1769,52 Based on this quantity (per working day), forecasts can be built for a certain timespan in the future: - Days = 7 days (e.g. the next week); - Working days = 5; - Forecast model: relative weight of the first and last day = 23%; relative weight of the remaining three days = 18% (in Total = 100%) (See figure 1). In the feed industry for instance, such patterns are observed because animals need to be fed during weekends as well; ![forecasts from history in Dynamics AX](https://2044671.hs-sites.com/hs-fs/hubfs/Blogs_pictures/Forecasts_2.png?width=499&name=Forecasts_2.png "forecasts from history in Dynamics AX") *Figure 1: relative weight of the five working days * - Result: - Forecast for the first and last day of the next week (per working day) = (1769,52 * 5)*23% = 2034,95 - Forecast for the remaining days of the next week (per working day) = (1769,52 * 5)*18% = 1592,57 Thereafter, based on an active recipe, forecasts of the semi-finished product can also be exploded into raw material purchase forecasts. This simple example gives an indication on how forecasts can be built from history in MILAS AX. Conclusion Despite the fact that many business people claim “forecasts are wrong” (in fact they are to a certain extent), organisations should not underestimate the noteworthiness of making accurate forecasts. To support this forecasting process, [MILAS AX](http://www.adifo.com/products/milas-ax-logistics-and-financials) provides a structured, flexible and user-friendly tool. [![Webinar: How to be more profitable in the commodity market](https://no-cache.hubspot.com/cta/default/2044671/bb28017b-1d0b-490e-8880-a0d5432556cb.png)](https://cta-redirect.hubspot.com/cta/redirect/2044671/bb28017b-1d0b-490e-8880-a0d5432556cb) Share this News - [Tweet](https://twitter.com/share) [Back to overview](https://2044671.hs-sites.com/en) [Contact us](http://info.adifo.com/en/contact) ### Subscribe to Email Updates ### Recent Posts ### Posts by Topic - [BESTMIX Feed Formulation (65)](https://2044671.hs-sites.com/en/topic/bestmix-feed-formulation) - [Tips & Tricks Tuesday (50)](https://2044671.hs-sites.com/en/topic/tips-tricks-tuesday) - [MILAS Logistics and financials (37)](https://2044671.hs-sites.com/en/topic/milas-logistics-and-financials) - [Adifo (36)](https://2044671.hs-sites.com/en/topic/adifo) - [BESTMIX Quality Control (33)](https://2044671.hs-sites.com/en/topic/bestmix-quality-control) - [BESTMIX Formulation as a Service (30)](https://2044671.hs-sites.com/en/topic/bestmix-formulation-as-a-service) - [Feature of the month (13)](https://2044671.hs-sites.com/en/topic/feature-of-the-month) - [Integrations (8)](https://2044671.hs-sites.com/en/topic/integrations) - [Labeling (5)](https://2044671.hs-sites.com/en/topic/labeling) - [BESTMIX Academic version (4)](https://2044671.hs-sites.com/en/topic/bestmix-academic-version) - [BESTMIX LIMS (4)](https://2044671.hs-sites.com/en/topic/bestmix-lims) - [Seminar (4)](https://2044671.hs-sites.com/en/topic/seminar) - [China (3)](https://2044671.hs-sites.com/en/topic/china) - [Petfood (3)](https://2044671.hs-sites.com/en/topic/petfood) - [Americas (2)](https://2044671.hs-sites.com/en/topic/americas) - [Award (2)](https://2044671.hs-sites.com/en/topic/award) - [BESTMIX Recipe Management (2)](https://2044671.hs-sites.com/en/topic/bestmix-recipe-management) - [Microsoft (2)](https://2044671.hs-sites.com/en/topic/microsoft) - [BESTMIX Food Quality Control (1)](https://2044671.hs-sites.com/en/topic/bestmix-food-quality-control) [see all](https://2044671.hs-sites.com/en/feature-of-the-month-building-forecasts-from-history-in-dynamics-ax#) ### Address Industrielaan 11B, 9990 Maldegem, Belgium ### Phone [+32 50 303 211](tel:+3250303211) ### E-mail [support@adifo.be](mailto:support@adifo.be) [bestmix.support@adifo.be](mailto:bestmix.support@adifo.be) [milas.support@adifo.be](mailto:milas.support@adifo.be) ### [Helpdesk](https://2044671.hs-sites.com/support) Bestmix: [+32 50 303 201](tel:+3250303201) Milas: [+32 50 303 200](tel:+3250303200) ### Social [facebook](https://www.facebook.com/AdifoSoftware)[twitter](https://twitter.com/AdifoSoftware)[linkedin](https://www.linkedin.com/company/adifo) ### Sign up for our newsletter. - [Home](http://www.adifo.com) - [Feed formulation](http://www.adifo.com/feed-formulation) - [Recipe management](http://www.adifo.com/recipe-management) - [Quality management](http://www.adifo.com/quality-management) - [Logistics and financials](http://www.adifo.com/logistics-and-financials) - [Products](http://www.adifo.com/products) - [Contact](http://info.adifo.com/en/contact) - [About us](http://www.adifo.com/about-us) - [Integrations](https://www.adifo.com/integrations) - [References](http://blog.adifo.com/references) - [Partners](http://www.adifo.com/partners) - [Industry](http://www.adifo.com/industry) - [Jobs](http://www.adifo.com/jobs) - [Events](http://blog.adifo.com/events) - [Blog](http://blog.adifo.com/en) - [Downloads](https://www.adifo.com/downloads) - [Support](http://www.adifo.com/support) - [Newsletter](http://www.adifo.com/newsletter) - [Mission and vision](http://www.adifo.com/about-us/mission-and-vision) - [Values](http://www.adifo.com/about-us/values) [facebook](https://www.facebook.com/AdifoSoftware)[twitter](https://twitter.com/AdifoSoftware)[linkedin](https://www.linkedin.com/company/adifo) - [Privacy](http://www.adifo.com/privacy-cookie-policy)