Application of business intelligence technique to manufacturing system with stochastic process (a case study of "product-based" manufacturing company in nigeria with make-to-order strategy)

Abstract

Manufacturing outfit in Nigeria with make-to-order strategy continually contend with the problem of long waiting time of customers for orders, which arose through inability to predict order quantity amount for customers. This indicates the need for the application of business intelligence technique on large amount of unused data in manufacturing databases, to evaluate and validate probability distribution model that is best suitable for prediction of customers' order values and subsequently using the best model to predict daily and yearly customers order amount. Many models were evaluated for data extracted from a manufacturing outfit and the best model was selected based on statistical goodness of fit. The normal distribution model was found most appropriate for the prediction of daily and monthly order quantity amount. Based on this, the application of business intelligence technique on extracted data has made the prediction of customers order for a product-based manufacturing outfit with make-to-order strategy possible.