Purpose of the Report
The Top 10 Spare Parts By Usage Volume dashboard is designed to help users identify the most frequently used spare parts across the business. By highlighting the top 10 Stock Keeping Units (SKUs) based on the quantity booked, the dashboard provides valuable insight into spare parts consumption patterns, inventory demand, and purchasing requirements.
This report supports inventory management, stock planning, and procurement activities by helping users understand which spare parts are being consumed most frequently within the selected reporting period and branch locations.
How to Access the Dashboard
From the main navigation menu, select the Self Service module.
Open the All Standard Dashboards folder.
Locate Top 10 Spare Parts By Usage Volume.
Click Preview to open the dashboard.
Apply any desired filters. The dashboard will automatically refresh based on the filters selected.
Dashboard Filters & Descriptions
The dashboard includes filters that allow users to refine the data displayed and focus on specific locations or reporting periods.
Branch Name
Type: Drop-down selection
Description: Filters the dashboard to display spare parts usage information for a selected branch or operational location.
Date Range
Type: Date range selector
Default Value: Last 7 days
Description: Filters the report based on the Stock Issue Date. Only spare parts issued within the selected date range will be included in the analysis. Adjusting the date range updates both the chart and pivot table.
Column Chart – Top 10 Spare Parts by Usage Volume
The column chart displays the Top 10 SKUs based on the total quantity booked during the selected reporting period.
How It Works
Calculates the total quantity booked for each SKU.
Displays the ten highest-ranking spare parts based on usage volume.
Sorted in descending order by the sum of Quantity Booked.
Provides a quick visual overview of the most frequently consumed spare parts.
Use Case Examples
Identify high-demand spare parts.
Monitor inventory consumption trends.
Support stock replenishment planning.
Assist purchasing teams with forecasting future demand.
Highlight parts that may require increased stock levels to avoid shortages.
Column Field Definitions (Pivot Table)
The pivot table provides detailed information about the top spare parts displayed in the chart.
Column Name | Description |
Rank | Displays the ranking position of each SKU based on total Quantity Booked. Rank 1 represents the highest usage volume within the selected reporting period. |
SKU | Unique Stock Keeping Unit identifier assigned to the spare part. |
SKU Description | Description or name of the spare part. |
Primary Supplier | Preferred supplier associated with the spare part. |
Manufacturer Part Number | Manufacturer's reference number used to identify the spare part. |
Branch Name | Branch or location where the spare part usage was recorded. |
Quantity Booked | Total quantity of the spare part booked or issued during the selected reporting period. |
Pivot Table Sorting & Ranking
The pivot table is configured to provide a ranked view of spare parts usage.
Sorting Logic
The data is sorted in:
Descending order by Quantity Booked
This ensures that the spare parts with the highest usage volume appear at the top of the table.
Ranking Column
The pivot table includes a row numbering feature displayed as the Rank column.
Rank 1 represents the SKU with the highest total Quantity Booked.
Subsequent rows are ranked sequentially (2, 3, 4, and so on).
The Rank column appears as the first column in the table, making it easy for users to identify the highest-consuming spare parts at a glance.
Final Remarks
The Top 10 Spare Parts By Usage Volume dashboard provides valuable insight into spare parts consumption across the business. By identifying the most frequently used SKUs, users can make informed decisions regarding inventory management, stock replenishment, and procurement planning.
Regular review of this dashboard can help prevent stock shortages, improve inventory availability, and support efficient maintenance operations by ensuring that high-demand spare parts remain readily accessible when required.