The ability to extend the functionality of ABC-XYZ analysis

Rate this item
(0 votes)

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: 

Read 4009 times

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