Solver add-in

Поиск решения в excel

Create a model for solving the Transportation problem (Transportation Problem, Shipping Routes). The solution of the Transportation problem allows to determine the most cost effective routes for transportation of goods from manufacturers to the warehouse. The calculation will be done using the add-in solver.

Determine optimal size at which the cost of production is minimal. Solution find using add-ins solver.

Determine the critical path of the project using add-in solver.

you Need to define the routes in which the cost of network operations is minimal. Build a linear model and using add-ins solver solve the problem.

it is Necessary to find the maximum throughput of the network pipeline. Build a linear model and using add-ins solver solve the problem.

it is Necessary to find the shortest path between 2 given cities. Build a linear model and using add-ins solver solve the problem.

Choose one of the variants of the traveling salesman problem for a small number of cities (5-10) using the add-in solver. Construct a linear model.

Choose one of the variants of the traveling salesman problem for a small number of cities (5-10) using the add-in solver. Construct the nonlinear model.

Solve linear programming problem using the add-in solver.

the Company is pursuing a reorganization in order to enhance the professionalism of the staff. Reorganization is carried out by admission of new employees, layoffs and retraining. It is necessary to minimize the costs of the reorganization. The calculation will be done using the add-in solver.

the Workers are distributed in shifts. Each session lasts 1 week, which is 5 working days and 2 weekends. It is important to ensure a certain amount of work every day of the week. To determine the minimum number of workers. The calculation will be done using the add-in solver.

the Company distributes new staff offices. Each employee expressed their preference for each of the offices. It is necessary to distribute employees to offices so that it was less dissatisfied. The calculation will be done using the add-in solver.

a Small airline needs to establish regular flights between the three cities. You want to schedule flights so as to minimize the costs of the company. The calculation will be done using the add-in solver.

the Company transports the products from their factories to warehouses. The total capacity of the plants is sufficient to meet existing demand, however the level of transport costs too high. Wanting to optimize the transportation costs, the Company is considering the option of opening a new plant. The calculation will be done using the add-in solver.

Build a model for decision-making: the company plans to open in several regions of their offices, which will receive payments from its customers. It is required to determine the best option to open offices in which the total costs will be minimal. The calculation will be done using the add-in solver.

the Company has a choice of 6 projects with different profitability and investment. To determine the best investment option in which the total income from projects will be the maximum. The calculation will be done using the add-in solver.

capital Management — the model search scheme of obtaining the maximum profit at the short-term and long-term investments. The calculation will be done using the add-in solver. As a basis we take the example from a file solvsamp.xls supplied with MS EXCEL.

Create a model for solving the following tasks: the company wants to minimize the cost, is it worth it to close one of its plants? The calculation will be done using the add-in the solver.

let's Create a model to solve an applied problem: post file DVD optimally, so that there's less empty space. This task is one kind of knapsack problem. The calculation will be done using the add-in solver.

let's Create a model for one of the versions of the classic knapsack problem: laying as many things into a backpack provided that the total volume (or weight) of all items that can fit in a backpack, is limited. The calculation will be done using the add-in solver.

let's Create a model to optimize transportation costs. The calculation will be done using the add-in solver.

let's Create a model for the optimization of the cost of buying and shipping goods. This is a very common problem, the effective solution saves companies millions of rubles. The calculation will be done using the add-in solver.

let's Create a model for optimal selection of channel of distribution of advertising. The calculation will be done using the add-in solver.

let's Create a model to determine the optimal lot size of the product at which the total variable costs are minimal. Costs associated with the ordering process and storage of the party in the warehouse, and depend on the size of the party. Also take into account the limitation related to the size of the warehouse. The calculation will be done using the add-in solver. For the simplest case of the problem we give an analytical solution.

let's Create a model to determine the optimal procurement option. The calculation will be done using the add-in solver.

Create a model for finding ways of cutting tape set to pieces of a certain length, so that total waste after cutting was minimal. The calculation will be done using the add-in solver.

Create a model for finding the best resource allocation, which minimizes the costs incurred over multiple periods (Allocation Problem). As restrictions on the use requirements of the order (quantity of each product and run time). The calculation will be done using the add-in solver.

Create a model for finding the best resource allocation, which minimizes the costs incurred over multiple periods (Allocation Problem). As restrictions on the use of requirements to the quality of the products. The calculation will be done using the add-in solver.

Create a model for finding the best resource allocation, which minimizes the costs incurred over multiple periods (Allocation Problem). As restrictions on the use of requirements to the quality of the products. The calculation will be done using the add-in solver.

Create a model for finding the best resource allocation, which minimizes the costs incurred over multiple periods (Allocation Problem). The calculation will be done using the add-in solver.

Create a model for finding the best resource allocation, in which costs are reduced (Allocation Problem). The calculation will be done using the add-in solver.

the Company shall execute the order for supply of several types of products, make them available in the warehouse materials. Unfortunately, the material is not enough to fulfill the order completely. You need to determine which products should make yourself, and what to buy-side, below the company's costs were minimal. The calculation will be done using the add-in solver.

let's Create a model to determine the Optimal structure of production (Product Mix) that revenue is maximum. The calculation will be done using the add-in solver. As a basis we take the example from a file solvsamp.xls supplied with MS EXCEL.

Search for solutions - this Microsoft Excel add-in which  you can find the optimal solution of the problem taking into account user-specified constraints.