arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 1802.00484cs.SE
收藏

嵌入周期性业务流程的运营管理模型的替代性设计

Alternative Spreadsheet Model Designs for an Operations Management Model Embedded in a Periodic Business Process

Thomas A. Grossman, Vijay Mehrotra, Mouwafac Sidaoui

摘要:

我们提出了一个广泛使用的运营管理模型,用于供应和分销规划,这是典型的嵌入在一个周期性的业务流程,需要模型的修改和重用。我们考虑三种替代的电子表格实现,数据驱动的设计,规范(教科书)的设计,和一个新的(表驱动)的技术设计。我们评估每一个关于准确性,修改,分析和转移的适用性。我们考虑使用每种设计所需的培训和技术复杂程度。数据驱动的设计提供了对幼稚的建模者的糟糕的电子表格实践的洞察。技术设计可以针对新数据和新结构元素进行修改,而无需手动编写或编辑单元格公式,从而加快修改速度并降低出错风险。该技术设计具有与其他类别的模型一起使用的潜力。我们确定未来研究的机会。

英文摘要:

We present a widely-used operations management model used in supply and distribution planning, that is typically embedded in a periodic business process that necessitates model modification and reuse. We consider three alternative spreadsheet implementations, a data-driven design, a canonical (textbook) design, and a novel (table-driven) technical design. We evaluate each regarding suitability for accuracy, modification, analysis, and transfer. We consider the degree of training and technical sophistication required to utilize each design. The data-driven design provides insight into poor spreadsheet practices by naïve modelers. The technical design can be modified for new data and new structural elements without manual writing or editing of cell formulas, thus speeding modification and reducing risk of error. The technical design has potential for use with other classes of models. We identify opportunities for future research.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑