Yes… supply chain Excel models are sometimes your best choice!
For the right type of problem, nothing beats a good spreadsheet model.
What do we mean by “the right type of problem”?
Well…. Here are some pointers:
- Small and medium size supply chain design problems
- Problems where the scope is not 100% clear and can benefit from prototyping
- Certain simulation or combined simulation+optimization problems
- “One-off” type studies (such a a logistics network design project)
- Compact optimization problems where risk analysis is critical
Complex and/or large planning or scheduling problems are not good candidates for spreadsheets. These type of problems need a robust database environment within an integrated planning and optimization application.
Examples of Supply Chain Excel Models
Check Our Complete Portfolio of Projects
The custom Technologix model used in Dyno Nobel’s business was configured not only to allow us to optimize our distribution network, but also for long-term capacity planning. As such, it has become a key tool for our business.
Technologix’s experience and expertise has proven to be invaluable from design, through configuration, and onto operating maintenance.The company’s relative small size enables them to provide cost-effective and responsive service when compared to their much larger competitors.
Vice President, Nitrogen Products
Dyno Nobel Inc.