一种EXCEL环境下的动态库存台账设计

基于EXCEL软件原有的函数语言和算法,通过分析生产中各种参数的内部逻辑关系,建立了一种动态的生产作业平台。利用该平台能够在只跟踪少量参数的情况下,实现对零件生产进度、装配生产进度、计划库存、实际库存、配套架份、库存缺货告警、平均库存数量等一系列关键生产参数的实时和动态监控,具有简单方便,显示准确,实用高效的特点。实践证明,在生产现场的计划和调度管理的各项关键指标中,计划制定时间缩短了80%,零件库存降低了39.3%,计划完成率提高了35.2%,生产均衡性由原来的经常缺件提高到现在的连续8个月生产无停顿,加班减少了70%以上,且产品准时交付率达到了99.04%。

A Dynamic Accounting Based on EXCEL

Based on the EXCEL,it uses the original function and algorithms of the software,by analyzing the internal logic of various parameters in the stock,to establish a dynamic inventory accounting.This accounting can achieve progress on the parts production schedule,assembly schedule,plan inventory,real inventory,supporting inventory,shortage warning,the average inventory and so on in real time and dynamic control,by tracking only a few parameters.It proves working easily,showing accurate,practical and efficient ...