An Approach to Identify Product Purchase Processing Time by Applying Business Intelligence in Steel Coated Production

Abstract

Indirect materials procurement, mostly consist of low volume and high variety still technically they are not a part of the end sale product, even they are having same important as direct material. For example, in an automated production line power grind to a halt without a grinding wheel indirect material, hence procurement and presence of indirect materials at right time is of major importance. The reduction of non-value added activities in this process deduction of non-value added actions would result in the reduction of lead time and buyers administrative efforts. Hence, this study has been interpreted to improving effectiveness and efficiency of the current procurement process. The objective of this study is to analyze and determine different aspects of the process of Purchase Requisition (PR) to Purchase Order (PO) and their analysis. We use power BI for interactive analysis and visualization. We applied our approach on steel coated products. Proposed approach benefits the procurement process and helps to retain conversion time and reduce the breakdown period.