While reporting capabilities have evolved into modern tools like PowerBI & Tableau, integration with sophisticated planning and optimization is still not available to the masses. With the rise of strong data integration tools, gone are the days when we had to work hard to convince our clients about the benefits of moving data in a single integrated environment that has one version of truth.
This whitepaper outlines the fundamentals of building an architecture that encompasses business intelligence and also optimization/simulation capabilities using modern artificial intelligence techniques to allow decision makers to forecast the results of their decisions in the near and far future.
given point of time, but to dwell much deeper to find out its causal factors and perform a root cause analysis so that future disruptions could be anticipated. Needless to say, such insights are extremely important in decision making and process improvements that are to come. This ability along with the speed and frequency of these analytics has increased drastically the possibility of a proactive real time enterprise.
Our team carried out an assessment for an electrical components manufacturing company and it brought out a simple fact – That echelon wise analytics combined with the right optimization would bring about the necessary insights required to meet the end KPI’s such as fulfillment.
The client knew that there was an existing problem of forecast accuracy in the supply chain. Such problems had occurred in the past as well. While it was important to balance the inventory holding cost and the stock out situations, the client recalled that the management had decided to keep the inventory levels very close to the real demand. There were programs conducted in the past to improve the demand management function. With investments in these programs, it was expected that the demand planners would be able to use the newer statistical tools and plan the forecast better.
Yet few orders were not fulfilled; these were lost orders and lost
dollars. Like everyone else, one of the managers of the organization was monitoring the order fill rate for one of the high value product lines. The report showed that the fill rate was impacted adversely in the past few weeks. They key was to figure out first whether the planning left much to be desired, or if the planning was right, where exactly did the Supply Chain snag. Isn’t it a common tendency to recall the events that have occurred in the past and to link them with the current problems? The extant performance was therefore thought to be a problem with demand management and some losses were assumed to be due to poor forecast and hence inaccurate replenishment; resulting in lost sales.
The week went by and to the manager’s surprise, there was a pile up of inventory the next week. The manager could have blamed the demand planners again, but he decided otherwise. With structured analytics it was now possible to link the information consistently to be able to connect the dots. With the hierarchical configuration linkage, the client went further and checked the sales in the region. These were increasing as per the demand projections. The sourcing report linked to this showed the production increase at the manufacturing plant as well. The manufacturing in the previous week was in line with the actual sales. This indeed implied that the demand planners had done their job well but something went wrong elsewhere.
The manager was now intrigued at the situation and dwelled further. With the ability to slice and dice data, it did not take much
This is just one of the examples that demonstrate the synergy of Analytics and Optimization. With such tools the focus of analysis could easily be spread across a wider spectrum rather than recalling the events that are already known. The drill down linkage capability of through a structured dimensional model was the most effective in our case.
Joining the dots backwards we can recall a concept from the
Theory of Constraints, ‘the bottleneck in a process always shifts’. It is this bottleneck that everyone is trying to manage best and it is challenging to control as it keeps moving silently across the supply chain. With Analytics and Optimization and its advanced simulation capabilities, these silent movements can be predicted with high accuracy foretelling roadblocks even before they turn into one.