基于DBMS的汽车零部件进口库存模型及其时间框架研究

P. L. Tamang, P. Paudyal
{"title":"基于DBMS的汽车零部件进口库存模型及其时间框架研究","authors":"P. L. Tamang, P. Paudyal","doi":"10.1109/SKIMA.2015.7399987","DOIUrl":null,"url":null,"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.","PeriodicalId":261471,"journal":{"name":"2015 9th International Conference on Software, Knowledge, Information Management and Applications (SKIMA)","volume":"22 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2015-12-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"6","resultStr":"{\"title\":\"A DBMS based inventory model and its timeframe study in automobile spare parts import management\",\"authors\":\"P. L. Tamang, P. Paudyal\",\"doi\":\"10.1109/SKIMA.2015.7399987\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":261471,\"journal\":{\"name\":\"2015 9th International Conference on Software, Knowledge, Information Management and Applications (SKIMA)\",\"volume\":\"22 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2015-12-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"6\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2015 9th International Conference on Software, Knowledge, Information Management and Applications (SKIMA)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/SKIMA.2015.7399987\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2015 9th International Conference on Software, Knowledge, Information Management and Applications (SKIMA)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/SKIMA.2015.7399987","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 6

摘要

本研究旨在研究汽车零部件进口系统中出现的延迟问题。这是菲亚特经销商巴塔斯兄弟汽车有限公司(BBMPL)基于尼泊尔-印度海关进口的案例研究。研究包括菲亚特通用进口模型、主要标准进口模型和基于数据库管理系统的进口模型的比较研究设计。DBMS模型的输入数据是2069/70财年、70/71财年(2013/014年、2014/2015年)的销售、保修、裁剪、次级经销商需求数据。这些数据用于预测2071/72财年的需求、运费和关税成本,并确定进口时间信息。利用DBMS模型生成预测数据的累积顺序,与标准进口模型和一般库存模型进行时间比较研究。研究统计总结表明,一般库存模型所需时间比标准进口模型长2.4倍(108天),即45天,而DBMS模型将标准时间缩短0.57倍(26天)。通过对标准进口模型和一般库存进口模型的比较,研究表明数据库管理系统库存模型是最佳的进口模型。开发了基于数据库管理系统的库存模型Web应用软件,并对其在进口管理中的可靠性进行了测试。该模型适用于进口行业的商业智能(BI)和企业资源规划(ERP)。如果能够收集到零配件需求数据库,即正规车间销售、保修销售、剪接销售、经销商销售,则该模型除了可以有效地应用于汽车服务之外,还可以有效地应用于其他行业。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
A DBMS based inventory model and its timeframe study in automobile spare parts import management
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.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
相关文献
二甲双胍通过HDAC6和FoxO3a转录调控肌肉生长抑制素诱导肌肉萎缩
IF 8.9 1区 医学Journal of Cachexia, Sarcopenia and MusclePub Date : 2021-11-02 DOI: 10.1002/jcsm.12833
Min Ju Kang, Ji Wook Moon, Jung Ok Lee, Ji Hae Kim, Eun Jeong Jung, Su Jin Kim, Joo Yeon Oh, Sang Woo Wu, Pu Reum Lee, Sun Hwa Park, Hyeon Soo Kim
具有疾病敏感单倍型的非亲属供体脐带血移植后的1型糖尿病
IF 3.2 3区 医学Journal of Diabetes InvestigationPub Date : 2022-11-02 DOI: 10.1111/jdi.13939
Kensuke Matsumoto, Taisuke Matsuyama, Ritsu Sumiyoshi, Matsuo Takuji, Tadashi Yamamoto, Ryosuke Shirasaki, Haruko Tashiro
封面:蛋白质组学分析确定IRSp53和fastin是PRV输出和直接细胞-细胞传播的关键
IF 3.4 4区 生物学ProteomicsPub Date : 2019-12-02 DOI: 10.1002/pmic.201970201
Fei-Long Yu, Huan Miao, Jinjin Xia, Fan Jia, Huadong Wang, Fuqiang Xu, Lin Guo
来源期刊
自引率
0.00%
发文量
0
期刊最新文献
Modelling of tumour-induced angiogenesis with regress by immune factor Deep learning based large scale handwritten Devanagari character recognition Performance analysis of various optimization techniques for elliptic curve cryptosystems on resource-constrained devices Collaborative crosschecking system of observed loss estimation for disaster relief management A practical way to integrate simulation based on SCOR model
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1