ABC-XYZ-Analysis

Lecture: Industrial logistics

ABC/XYZ Analysis

as a basis of differentiated scheduling

Dr.-Ing. Volker Stich

Dipl.-Wirtsch.-Ing. AndréBrunner

Tel. (0241) 47705 –430

E-mail: Andre.Brunner@fir.rwth-aachen.de

Task

Initial situation

Initial situation The Computer AG would like to optimize inventory costs for the spare parts

business. To decide how materials are to be scheduled a material analysis is needed.

The Computer AG would like to optimize inventory costs for the spare parts business. To decide how materials are to be scheduled a material analysis is needed.Data

provided

Data provided The sales department provides the following data of the last 12 months: Sales per month in units

Average price apiece in €

The sales department provides the following data of the last 12 months: Sales per month in units Average price apiece in €Task

Task Make an ABC- and a XYZ Analysis using the calculation sheets provided. Complete the 9-fields-matrix with the denotation of materials that were assigned to the corresponding item class.

Make an ABC- and a XYZ Analysis using the calculation sheets provided. Complete the 9-fields-matrix with the denotation of materials that were assigned to the corresponding item class.

Initial data

Sequence of the ABC analysis

Graph of ABC –Analysis

Sequence of XYZ analysis

N = Total number of periods

Graph of XYZ –Analysis

Solution: 9 –fields–matrix

Contact

www.fir.de

Thank you for your attention