A DBMS based inventory model and its timeframe study in automobile spare parts import management

Abstract

The present study is aimed to study the delay that arises in automobile spare parts import system. This is a case study of FIAT dealership, Batas Brothers Motors Pvt. Ltd (BBMPL) based on import of Nepal-India custom. Study includes comparative research design of FIAT general import model, principal standard import model and Database Management System (DBMS) based import model. Input data taken for DBMS model is sales, warranty, clipping, sub-dealership demand data of FY 2069/70 BS, 70/71 BS (2013/014 AD, 2014/2015 AD). These data are used to forecast demand, cost of freight and custom duties for FY 2071/72 and determine the import time information. An accumulated order of forecasted data is generated by DBMS Model for study of time comparison with standard import model and general inventory model. Statistical summary of study shows that general inventory model takes 2.4 times (108 days) longer duration than that of standard import model i.e, 45 days whereas DBMS model reduces standard time by 0.57 times (26 days). The study suggests DBMS inventory model as best model in comparison with standard import model and general inventory import model. Web based application software of DBMS based inventory model has been developed and its reliability test in import management has been carried out. The model is friendly in business intelligence (BI) and enterprise resource planning (ERP) for import industry. If database of spare parts demand viz-normal workshop sales, warranty sales, clipping sales, sub dealership sales can be collected, the model can be effectively used in other industries also, beside the automobile service.