Guide to spare parts evaluation based on the ABC-XYZ analysis
The LSM tool ‘Spare parts evaluation’ provides a basic overview of how spare parts can be evaluated using an ABC-XYZ analysis. Management strategies can then be derived for the spare parts groups resulting from the evaluation in order to achieve the economic optimum for each group.
The procedure for such an evaluation in Microsoft Excel is described in detail below. It should be noted that the data shown are only sample data. These must be replaced with the data of the spare parts to be evaluated.
For detailed documentation, please refer to the guide in PDF format.
<< [ Back ]