Category archives: AIMMS
According to a recent Wall Street Journal article, finance chiefs are cutting back on Excel because it hasn’t “kept up with the demands of contemporary corporate finance units.” “I don’t want financial planning people spending their time importing and exporting and manipulating data, I want them to focus on what is the data telling us” – Adobe Inc.’s finance chief Mark Garrett tells WSJ journalist Tatyana Shumsky. This mood prevails among supply chain executives as well.
Spreadsheets still dominate planning in the supply chain. We recently commissioned Supply Chain Insights to conduct independent research on supply chain network design, and 65% of the companies surveyed are reportedly using spreadsheets to support this process. Spreadsheets are familiar, inexpensive and convenient. But they pose serious setbacks for organizations:
- They are practically never integrated with other systems
- They are not updated automatically
- The logic behind them is often only clear to those who create them and often dies when somebody leaves, making collaboration difficult
- Analyses are often slow given that you can only work with a certain amount of data
- Version control is hard
Perhaps most importantly, spreadsheets are error prone. In fact, as Market Watch reports, close to 90% of spreadsheet documents contain errors. Even after careful development, spreadsheets “contain errors in 1% or more of all formula cells.” In large spreadsheets with thousands of formulas, there are often dozens of undetected errors.