TEMPORARY IS OUT OF SERVICE!
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.
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:
|C1||N1||Cost/Distance serving C1 from L1||Cost/Distance serving C1 from L2||…|
|C2||N2||Cost/Distance serving C2 from L1||Cost/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:
|Capacity||L1 Capacity||L2 Capacity||…|
|Fixed Cost||L1 Fixed cost||L2 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:
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:
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: