OPTIMIZER.LOCATIONS

You are here:

TEMPORARY IS OUT OF SERVICE!

AXCEL.OPTIMIZER.LOCATIONS function

OPTIMIZER.LOCATIONS is a powerful logistic optimizer that provides an optimal solution when there are several options of serving clients from multiple locations (resources) subject to capacity and fixed cost constraints. The goal is to serve all clients with minimum cost with defined constraints.

Syntax

AXCEL.OPTIMIZER.LOCATIONS(ClientMatrix LocationSpecs, [Output], [Start])


The AXCEL.OPTIMIZER.LOCATIONS function syntax has the following arguments:

ClientMatrix Required. This is a table of clients-location matrix with the following the format:

ClientDemandL1L2
C1N1Cost/Distance serving C1 from L1Cost/Distance serving C1 from L2
C2N2Cost/Distance serving C2 from L1Cost/Distance serving C2 from L2

Each row consist of Client name (C1, C2, …), clients demand (N1, N2, …), cost or distance of serving clients from locations L1, L2, …

LocationSpecs Required. This is a table of locations specifications including their capacity and fixed cost with the following format:

L1L2
CapacityL1 CapacityL2 Capacity
Fixed CostL1 Fixed costL2 Fixed cost

Please note the order of columns is similar to ClinetMatrix and the capacity units is simialr to those defined as demands in ClientMatrix table.

Output Optional. Default is “C” which shows the table of Location <-> Clients. If sets to “L”, it reports the capacity utilized by each location.

Start Optional. By default, Axcel starts with a random point to find the optimal solution. You can define a starting point as a vector of locations in this format:

L4
L2
L1

when you type =AXCEL.OPTIMIZER.LOCATIONS in an Excel cell, the IntelliSense guides you through required and optional (shown in [] brackets) inputs:

In the example above, we have:

=AXCEL.OPTIMIZER.LOCATIONS(A3:G13,B15:G17)

Which means that our Client-Location matrix is located at cells A3 to G13, Location Specifications table is at cell B15 to G17, we would like to have standard location output and leave the starting point as default. Here is the output:

As you can see in the table with a blue header, Axcel reports the optimum solution of serving each client from an available location. Alternatively, we can set the output to “L” and get the utilization result (the percentage column is calculated in Excel) as presented below in the table with a green header: