Simple & Easy Solver for optimization
October 27, 2017
Simple & Easy Solver for optimization
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Analytic Solver
My organisation is using it for optimization problems related to raw material and finished goods for their shipments and production planning purposes. It is used only in my function- sales and operations planning. This tool is useful for the company who wants to build the optimization model in Excel for quick strategic and tactical decisions. Solver is easy to understand and learn. My company is using Solver for product optimization, manufacturing plan and raw material planning. It helps busineses to understand the financial estimates across the distribution network. It helps to provide the feasible solution for production to produce what product at what location in an optimized manner.
- Easy to use and learn.
- Strong optimization platform for business and supply chain problems which can be modeled in Excel
- It can handle multiple objectives and more than 8000 decision variables in a problem.
- Lots of tutorial and examples are available to solve the problem
- Can not handle stochastic modelling
- Difficult to work on the non-linear program
- Managing the data is difficult using the big models in the tool
- Excel Solver and Lingo
We believe in building the models in Excel. A limitation with Excel is that Excel Solver can not take more than 200 decision variables with multiple constraints. It is cheap in terms of license and maintenance fees against other softwares which are available in the market.