In Excel on the Analytic Solver tab on the Ribbon, click the Help dropdown menu and choose Examples. This opens a workbook. Select "Optimization Examples and another new workbook will open which contains the examples used for conventional optimization in the User Guide.
The Link/Worksheet "Inventory Planning" is the one you're interested in. We recommend running this example with Guided Mode on (Help - Operating Mode - Guided Mode), since it will give you a better explanation of what happens, as the Platform first finds the IF functions, then attempts to transform them into equivalent sets of integer and continuous variables and linear constraints, and succeeds and solves the model to optimality.
To read about the transformations that the Platform is making in the Inventory Planning example, click Help - User Guides - User Guide and go to the User Guide's last chapter, "Building Large-Scale Models". In the section "Improving the Formulation of Your Model", read the subsection "Techniques Using Linear Functions and Binary Integer Variables", especially the part about IF functions.
Comments
2 comments
The notes in "Inventory Planning (opt)" says that minimum cost of $3300 can be achieved. I get $5000 consistent results in multiple re-runs. Where am I missing?
Thanks!
Hi Budana,
Apologies for the delay in response. Thank you for bringing this to our attention. As it happens this is a typo in the example itself, $5000 is the correct minimum cost and solution to that particular model. This will be resolve in the next release that is publicly available.
We have created a "ticket" for you in regards to this, if you would like to reply please do so via email in response to the ticket created.
Best,
Brandon T.
Please sign in to leave a comment.