Frontline solver tutorial
There is a fixed profit per unit for each product, so the objective function (the quantity we want to maximize) is:īuilding each product requires a certain number of parts of each type. The decision variables are the number of products of each type to build: x1 for TV sets, x2 for stereos and x3 for speakers. The Algebraic Form – The problem can be described in algebraic form as follows. Our goal is to produce the mix of products that will maximize profits, given the inventory of parts on hand. Each product is assembled from parts in inventory, and there are five types of parts: chassis, picture tubes, speaker cones, power supplies and electronics units. Our factory is building three products: TV sets, stereos and speakers. Risk Solver Platform works with any 32-bit version of Microsoft Excel.Ĭonsider the following problem. Problem size limits in combination with Premium Solver Platform are 1000 decision variables and 1000 constraints.
#Frontline solver tutorial pro#
Problem size limits in combination with Premium Solver Pro are 500 decision variables and 250 constraints. It includes all of the simulation functionality of Risk Solver Platform including the Psi Interpreter for simulations.
#Frontline solver tutorial upgrade#
Premium Solver Pro – Premium Solver Pro is Frontline’s basic upgrade for the standard Excel Solver, for conventional optimization.It has no Monte Carlo simulation, simulation optimization, stochastic programming or robust optimization. It includes the PSI Interpreter, five built-in Solvers (LP/Quadratic, SOCP Barrier, LSGRG Nonlinear, Interval Global, and Evolutionary), and it supports plug-in large-scale Solver Engines. Premium Solver Platform – Premium Solver Platform is Frontline’s most powerful product for conventional optimization.All these products use one set of program files, and share a common user interface the product you ‘experience’ is determined by your license code. Premium Solver Platform and Premium Solver Pro for optimization, and Risk Solver Pro for simulation and simulation-optimization are available as subsets of Risk Solver Platform. Risk Solver Platform from Frontline Systems combines all the capabilities of Premium Solver Platform for optimization, Risk Solver Pro for simulation, and several powerful methods for optimization of uncertain models.