OVERCOMING SPREADSHEET RISK IN SUPPLY CHAIN MODELING
讨论了管理电子表格模型在供应链优化中带来的风险，这些风险源于非技术经理难以处理优化模型的复杂性，并提出了相应的管理程序。
Spreadsheet optimization modeling plays an important role in the management of today's sophisticated supply chains. However, despite the advantages of spreadsheets (or in some cases because of these advantages) there are significant risks associated with spreadsheet models. Spreadsheet risk is defined as the chance of adverse operational or financial consequences due to erroneous creation, maintenance, and/or use of spreadsheet models. Such errors arise because the intrinsic complexity of optimization models is beyond the expertise of many non‐technical managers. In this article we discuss procedures that we developed for managing the substantial risks associated with the use of spreadsheets for supply chain optimization. The issues we address go far beyond simple data entry mistakes, which are possible in virtually every aspect of business and can never be completely eliminated.