物料存量管理自动化程序开发及应用  

Development and Application of Material Inventory Management Automation Program

作　　者：韦小丽 王桥先 赵俊才 Wei xiaoli;Wang qiaoxian;Zhao juncai

机构地区：[1]上汽通用五菱汽车股份有限公司,重庆市400000

出　　处：《时代汽车》2020年第21期7-8,共2页Auto Time

摘　　要：伴随着市场需求的变化,产品配置丰富化、多样化,零部件种类也随之增多,在有限的仓库场地,灵活的存量设置,不仅提高物料在厂内的周转率,减少多余库存浪费,并能提高仓库的利用率。通过对存量回顾方法、存量设置原则的研究,应用office软件,将传统人工测算的方式转变为程序,改善人员的而传统的存量操作,同时提升物料厂内库存的管理水平。With the change of market demand,the product configuration is enriched and diversified,and the kinds of parts are also increased.In the limited warehouse site,the flexible stock setting can not only improve the turnover rate of materials in the factory,reduce the excess inventory waste,but also improve the utilization rate of the warehouse.Through the study of inventory review method and inventory setting principle,office software is applied to transform the traditional manual measurement method into a program,so as to improve personnel and traditional inventory operation,and enhance the management level of inventory in the material factory.

关 键 词：存量管理 VBA 车型节拍 时间窗 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]