 ### MS EXCEL Solver. 1.8. Transportation Problem

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.

### MS EXCEL Solver. 6.8. Optimal Design

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

### MS EXCEL Solver. 6.7. Critical Path in Project Management

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

### MS EXCEL Solver. 6.6. Minimum-cost flow problem

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.

### MS EXCEL Solver. 6.5. Pipeline Throughput

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

### MS EXCEL Solver. 6.4. CriticalPath (Incomplete graph), linear model

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

### MS EXCEL Solver. 6.3. The travelling salesman problem (TSP), 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 a linear model.

### MS EXCEL Solver. 6.2. The travelling salesman problem (TSP), nonlinear 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.

### MS EXCEL Solver. 6.1. Linear Programming

Solve linear programming problem using the add-in solver.

### MS EXCEL Solver. 5.4. Company Reorganization

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.

### MS EXCEL Solver. 5.3. Personnel scheduling (with shifts)

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.

### MS EXCEL Solver. 5.2. Personnel scheduling considering the employee work preferences

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.

### MS EXCEL Solver. 5.1. Personnel scheduling

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.

### MS EXCEL Solver. 4.4. Plant Opening Optimization

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.

### MS EXCEL Solver. 4.3. Optimal New Office Location

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.

### MS EXCEL Solver. 4.2. Capital Budgeting

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.

### MS EXCEL Solver. 4.1. Working Capital Management

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.

### MS EXCEL Solver. 3.4. Plant Closing Optimization

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.

### MS EXCEL Solver. 3.3. Minimize free space on Disk (Subset Sum)

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.

### MS EXCEL Solver. 3.1. Minimize the cost of shipping a product

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

### MS EXCEL Solver. 2.4. Purchasing/Transportation Model

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.

### MS EXCEL Solver. 2.3. Optimal value of advertising

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

### MS EXCEL Solver. 2.2. Economic Order Quantity (EOQ)

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.

### MS EXCEL Solver. 2.1. Purchasing Optimization

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

### MS EXCEL Solver. 1.7. Cutting Stock Problem

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.

### MS EXCEL Solver. 1.6. Resource Allocation Model (Customized Order)

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.

### MS EXCEL Solver. 1.5. Resource Allocation Model (Meeting Quality Requirements, Several Periods)

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.

### MS EXCEL Solver. 1.4. Resource Allocation Model (Meeting Quality Requirements)

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.

### MS EXCEL Solver. 1.3. Resource Allocation Model (Several Periods)

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.

### MS EXCEL Solver. 1.2. Resource Allocation Model

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.

### MS EXCEL Solver. 1.1a. Optimal Product Mix (not enough capacity to satisfy current demand)

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.

### MS EXCEL Solver. 1.1. Optimal Product Mix

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.

### MS Excel Solver Tutorial

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