MAGAZINE №3 (62) June 2014


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


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.


Tuesday, 09 December 2014 09:53

ABC – VEN analysis using the theory of sets

MAGAZINE №5 2014


CATEGORY Analysis in Logistics and SCM


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




Postal address:

125 319  Chernуakhovskogo str.16

phone/fax (495) 771 32 58

Working with authors: Levina Tamara Vladimirovna

mob. 8-962-965-48-54