Center of gravity analytic solver platform

#Center of gravity analytic solver platform upgrade
#Center of gravity analytic solver platform download

Facility - Facility Location: Determine which (if any) plants to close to minimize total costs, which include fixed operating costs and shipping costs from plants to warehouses.

Knapsack - Partial Loading (Knapsack Problem) - Decide which sizes or types of products to load into a vehicle, given its size limits, to best meet demand or to minimize wasted space.Transport3 - Multi-Level, Multi-Commodity Transportation Model: Determine how many products of several different types to ship from each factory to each warehouse and each customer, to minimize total shipping cost while meeting demands and not exceeding capacities and supplies.Transport2 - Multi-Level Transportation Model: Determine how many products to ship from each factory to each warehouse and each customer, to minimize total shipping cost while meeting demands and not exceeding warehouse capacities and factory supplies.Transport1 - Transportation Model: Determine how many products to ship from each factory to each warehouse, to minimize shipping cost while meeting warehouse demands and not exceeding factory supplies.Or, if you would prefer to view the examples in your browser, rather than in Excel, click the links below.

#Center of gravity analytic solver platform upgrade

You can then actually solve these small example models in Excel, using the standard Excel Solver, Analytic Solver Upgrade or Analytic Solver Optimization.

Right-click Distribution Examples.xls and select Save Target As.

#Center of gravity analytic solver platform download

To download and save the workbook if you are using Excel 2003 or earlier:

Right-click Distribution Examples.xlsx and select Save Target As.

Solving your real problem may require 'scaling up' the model to include more variables and constraints - but rest assured that you can solve your full-size problem with the power of our Excel Solver upgrades, even if it requires hundreds of thousands of variables! To download and save the workbook if you are using Excel 2007 or later: You can use the worksheet that most closely models your situation as a starting point. Click the model names to display each worksheet model in your browser. This free workbook contains six example models from distribution and logistics.