节点文献

基于VBA的供应链牛鞭效应仿真实验系统开发

The Development of Simulation Experimental System for Bullwhip Effect of Supply Chain Based on VBA

  • 推荐 CAJ下载
  • PDF下载
  • 不支持迅雷等下载工具,请取消加速工具后下载。

【作者】 向万里张静芳胡鲲鹏安美清

【Author】 XIANG Wanli;ZHANG Jingfang;HU Kunpeng;AN Meiqing;School of Traffic and Transportation,Lanzhou Jiaotong University;

【机构】 兰州交通大学交通运输学院

【摘要】 针对供应链中的牛鞭效应现象,采用Excel VBA开发了牛鞭效应仿真实验系统,可以实现牛鞭效应中的角色管理、库存控制策略设置、需求管理、仿真结果报告以及牛鞭效应相关现象动态可视化。该系统可以有效辅助教师循序渐进地讲授和学生理解多种复杂条件下的牛鞭效应演变过程,有助于教学效果的提升。同时,也可以作为课外实践教学平台,有益于学生不断自主学习、深入探索。

【Abstract】 Aiming at the bullwhip effect of supply chain,a simulation system of supply chain bullwhip effect is developed by using Excel VBA. Some functions including role management,inventory policy,demand management,simulation record and dynamic visualization in the bullwhip effect are implemented in the system. Furthermore,it is very helpful to help teachers to gradually introduce related concepts. Meanwhile,it is also beneficial to students for understanding the evolving processes of the bullwhip effect under many complex conditions. In this way,the teaching effectiveness is enhanced. At the same time,it is also considered as an extracurricular practical teaching platform,which is helpful to students for further learning and exploration.

【基金】 国家自然科学基金(61563028);甘肃省青年科技基金计划项目(1508RJYA062);中国物流学会教改课题(JZW2016137,JZW2017024);兰州交通大学本科教学改革项目(JGY201602);兰州交通大学实验教学改革项目(201632)
  • 【文献出处】 实验室研究与探索 ,Research and Exploration in Laboratory , 编辑部邮箱 ,2018年03期
  • 【分类号】F274;TP391.9
  • 【被引频次】2
  • 【下载频次】251
节点文献中: