基于VBA生成订单并实现整车计划制作的方法  

A Method of Generating Orders Based on VBA and Finalizing the Planning of the Vehicle

作　　者：侯照君 Hou Zhaojun(不详)

机构地区：[1]一汽-大众汽车有限公司,吉林省长春市130000

出　　处：《时代汽车》2021年第4期162-163,共2页Auto Time

摘　　要：通过VBA编程,将大颗粒的销售预测信息转化为小颗粒的订单信息,为生产计划的制作提供基本素材,大量节约生产计划编制时间,生成的订单在完整体现预测信息的同时还更加贴合实际需求。运用此方法生成订单编制的生产计划用时短,信息准确。细化后的订单对计划的调整可快速应对,从而确保了物料需求信息的及时、准确传递。Through VBA programming,the large-particle sales forecast information is converted into the small-particle order information,which provides basic materials for the production plans,which greatly saves the time for preparing production plans.The generated orders not only fully refl ect the forecast information,but also are more similar to the demand.Using this method to generate the production plan for order preparation takes a short time and the information is accurate.The detailed order can quickly respond to plan adjustments,thereby ensuring timely and accurate delivery of material demand information.

关 键 词：VBA 订单 均匀分布 透视表 

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