MAGAZINE №3 (62) June 2014

AUTHOR KONIKOV A.I., KONIKOV G.A.

CATEGORY Analytics in logistics and SCM Optimization and economic-mathematical modeling

**ABSTRACT**

In logistics, marketing and other areas of the economy people use an approach based on ABC-XYZ analysis. The disadvantages of this approach include its limited functionality. The article deals with ways of overcoming this shortcoming. As an example, we consider ABC-XYZ analysis of commercial products. For solving this problem, we use theory of sets: all products are represented as a set, which then splits into subsets A, B, C, X, Y, Z and others. It is further proposed to combine the operations of the theory of sets with the usual methods used in ABC-XYZ analysis. This allows you to visualize the problem and propose a solution in the form of the relational data model (relational table). In this table fields (columns) there are, on the one hand, the categories of ABC-XYZ analysis and, on the other hand, the usual parameters of the chosen product: price, manufacturer, etc. The article describes the features of working with a table of this kind. As a result, it is possible to radically extend the functionality of the ABC-XYZ analysis, using popular software products. As an example, in the simplest case – MS Excel, in more complex cases – MS Access or Oracle.

**Keywords: **

**MAGAZINE **№5 2014

**AUTHOR **KONIKOV A.I., KONIKOV G.A.

**CATEGORY **Analysis in Logistics and SCM

**ABSTRACT **

The paper considers ABC and VEN analysis, research is carried out using the elements of theory of sets. For example, ABC-VEN ranking construction shows the possibility of combining the methods of analysis. There are specific recommendations for using MS Excel and databases

**Keywords:**

]]>