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: 

Tuesday, 09 December 2014 09:53

ABC – VEN analysis using the theory of sets

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:

 

Contacts

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

E-mail: levina-tamara@mail.ru