基于Excel的物资库存管理系统的设计与开发

Excel-based logistical inventory management

市面上商用物资库存管理系统功能复杂、价格昂贵,对中小企业来说性价比较低.利用Excel为物资管理员定做的库存管理系统包含出入库管理模块、库存结余模块、系统设置模块三大部分.使用时,采用下拉列表进行数据选择输入,保证信息的准确性;用冻结窗格功能保证信息输入的便捷性;用数学函数保证物资存量信息的实时更新;用单元格锁定功能保证历史记录的安全性;用筛选功能助力统计分析与查询.

The commercial logistical inventory management is complicated and costly for a small and medium-sized enterprise.However,the Excel-based logistical inventory management that includes a storage management module,an inventory balance module and a system setting module is more applicable.By using the drop-down list for data input,freezing panes,mathematical functions,cell lock function and screening function,one may complete the statistical analysis and query.