Optimization Solutions - Distribution Examples

Distribution Examples Workbook

This free Distribution Examples workbook contains six example models from the area of distribution and logistics.  In nearly any browser, you can click the links below to display each worksheet model in the browser area.  Click the Back button to return to this page, or visit the Solver.com Home Page.

You can use the worksheet that most closely models your situation as a starting point.  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, right-click Distribution Examples and select Save Target As... from the context menu.  You can then actually solve these small example models in Microsoft Excel, using either the standard Excel Solver or the Premium Solver or Premium Solver Platform.

• 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
• 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
• 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
• 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
• 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
• Prodtran - Production / Transportation Model:  Determine how many products to produce in each factory and ship to warehouses and customers, to minimize overall costs while meeting demands and not exceeding warehouse capacities and factory supplies

On each example worksheet, read the description at the bottom, then select Tools Solver... to examine the decision variables, constraints, and objective in the Solver Parameters dialog.  To find the optimal solution, click the Solve button.

We're here to help -- contact us if you'd like more information or advice on your application.

< Back to Solutions Overview