Why is it necessary to make a Business Forecasting considering global indetermination of business processes? The answer is that all organizations operate in fuzzy conditions; however their managers should make right decisions that affect the future of their organizations. Well-founded assumptions about the future are more valuable for managers than unfounded ones. We suggest such a way of prognosis creation, which is based on logical methods to process the data generated by Microsoft Dynamics AX (Axapta).
All mentioned above does not mean that intuitive prognosis is always bad. Vice versa, ‘intrinsic’ feeling by manager often provides the only acceptable prognosis. We discuss a prognosis approach that could help responsible managers to validate their intuitive decisions. We suppose that a person, who makes decisions based on understanding of quantitative prognosis approach and who is able to use it rationally, undoubtedly has the advantage before the one, who attempts to plan the future without any additional information.
Dynamics AX (Axapta) uses inventory / sales / purchase forecasting data, which are always entered by user manually, to generate planned sales and purchase orders, as well as cash flow forecast in the Ledger module. General idea of our Business Forecasting solution is to automate the creation of forecasting data based on existing historical transactions in various Dynamics AX (Axapta) modules. Supplementary idea is to take a possibility to use any Dynamics AX (Axapta) time series data for forecasting purposes. It could help users to forecast their Budgetary Analysis, Yield Projections, Process and Quality Control, Inventory Studies, Workload Projections, Utility Studies, Census Analysis, and many more.
Time series analysis is mathematical background of the solution.
The first step in the process of trend identification is data smoothing. The most common technique is moving average smoothing that replaces each element of the series by either the simple or weighted average of n surrounding elements, where n is the width of the smoothing "window". Seasonal dependency (seasonality) is another general component of the time series pattern. One way of evaluating the accuracy of forecasts is to plot the observed values and the one-step-ahead forecasts in identifying the residual behavior over time. Widely used statistical measures of error that can help to identify a method or the optimum value of the parameter within a method are mean absolute error and mean squared error. Mean absolute error (MAE) value is the average absolute error value. Closer this value is to zero the better the forecast is. Mean squared error (MSE) is computed as the sum (or average) of the squared error values. This is the most commonly used lack-of-fit indicator in statistical fitting procedures. As compared to the mean absolute error value, this measure is very sensitive to any outlier; that is, unique or rare large error values will impact MSE value greatly.
Technical background of the system is to use described mathematical algorithms from e.g. Matlab or Microsoft Excel. Analyzed data are exchanged between Microsoft Dynamics AX (Axapta) and computational software.
The base of time-series analysis is to use data connected to past time periods to forecast future values.
Forecasting routine of this solution consists of 5 stages:
Data definition interface allows specifying the incoming data source, the incoming data limitation query, the minimal analyzing period, the number of periods for forecast generation.
There are two possible ways for it:
Minimal analyzing period
Minimal analyzing parameter is used to define minimal date interval for building history data series and resulting forecast generation. This parameter is predefined with the following values: day, week, month, quarter, and year.
Fact data calculation normalizes incoming data series according to specified minimal analyzing period. Incoming history data are summarized by specified dimensions per each period. Resulting series are saved as fact data in data storage. This part provides noise reduction from fact table, correlation analysis in later version of calculation, and so on. User can preview a chart diagram of fetched and calculated fact data finally.
Trend line calculation routine calculates the forecasts for trends according to setup of trend group.
Forecast calculation routine calculates the forecast by selected trend type.
Calculated series from fact table, startup parameters of calculation, calculated forecasts are stored in several new tables.
Several chart diagrams are available based on pre-calculated data, trend lines data and calculated forecasts. Visualization is implemented as separate Dynamics AX (Axapta) form with Dynamics AX (Axapta) chart object utilized.
There is a possibility to create standard Dynamics AX (Axapta) forecast records automatically based on selected calculated forecast by trend and dimensions. Field migration rules are defined on level of startup dialog or wizard.
Usage of Business Forecasting (BF) solution gains the following advantages for an enterprise: