The article presents the possibility of solving a complex Multi Facility Location Problem in Excel and its use in military practice. Based on a simple model example (25 branches, 5 centers), it gradually verifies the individual steps leading to the solution of the optimization requirement of increasing (decreasing) the number of centers, weight of branches, capacity of centers, and forbidden (permitted) areas. These examples are solved using the evolutionary method in Excel. Finally, this method solves an example in the range of 100 to 3 and the result is verified by calculation by the metaheuristic method. This demonstrates the ability to solve this type of tasks in the proposed way.
