Simple & Easy Solver for optimization
October 27, 2017

Simple & Easy Solver for optimization

Anonymous | TrustRadius Reviewer
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.
1. It is good tool for a mathematical model which is a single period and deterministic model
2. It is good for the users who are comfortable in handling the Excel Solver and needs to upgrade the Excel Solver for more than 200 variables
3. It works well for the multiple objective problems.
4. Difficult to manage the big model as 100 constraints and 2000 variables can limit the use of the tool's efficiency.
5. Its limitation is that a model designer can not make a big and complex model.

Analytic Solver Feature Ratings