# Spare Part Usage Analysis

### **Report Module Guide: Spare Part Usage Analysis Report**

#### **Module Location**

#### Fixed Asset > Reports > Spare Part Usage Analysis Report

#### **Module Objective**

#### The **Spare Part Usage Analysis Report** module is an advanced analysis tool used to analyze the patterns and frequency of spare part usage. Unlike a regular usage report that only lists what was used, this report helps to analyze how often replacements occur, the durability of spare parts, and to predict future maintenance needs.

### **1. Report Parameters (Filter)**

#### The main page of this module is a form containing various parameters to focus your analysis.

#### Here is an explanation for each parameter:

- #### **Date**:
    
    
    - #### Specify the date range of the maintenance data to be analyzed.
- #### **Specific Filters**:
    
    
    - #### You can focus the analysis by selecting specific filters for **Spare Part, Asset, Supplier,** or **Maintenance Type**. Choose **All** for a general analysis or **Select...** for a targeted analysis.

### **2. Steps to Generate the Report**

#### **Step 1: Set Report Parameters**

#### Define the date range and other relevant filters. For a good analysis, it is recommended to use a long date range (e.g., 6-12 months).

#### **Step 2: Generate the Report**

#### After all parameters are set, click one of the two buttons at the bottom:

- #### **\[Display Report\]**: To preview the analysis report directly on your screen.
- #### **\[Export to MS Excel\]**: To download the report data in an Excel file format.

### **3. Reading the Report (Report Content)**

#### The generated report will be an analysis table that summarizes the performance and usage patterns of spare parts.

#### Pay attention to key analysis columns such as:

- #### **x times**: Shows how often (frequency) the spare part was replaced in the selected period and for the selected filters.
- #### **Durability (days)**: Calculates the average lifespan of the spare part (in days) from one replacement to the next.
- #### **Next Maintenance Date**: Predicts when the next maintenance will likely be needed based on historical durability data.

### **Tips & Important Notes**

- #### This report is an analysis tool for shifting from reactive maintenance to **predictive maintenance**.
- #### The **Durability (days)** data is very useful for evaluating the quality of spare parts from different suppliers. If a spare part from Supplier A has a longer durability than one from Supplier B, this can be a basis for purchasing decisions.
- #### This is a highly strategic report for **Maintenance Managers** and **Reliability Engineers**.