Development of a transformer asset management dashboard in upstream oil and gas companies through ABC and FSN analysis
DOI:
https://doi.org/10.59141/jrssem.v4i12.925Keywords:
asset management, transformer, dashboard, Analysis Based Costing (ABC), Fast -Slow-Non Moving (FSN)Abstract
Upstream oil and gas companies face challenges in managing transformer asset data that is vital to operations. The complexity of manual data and transformer information makes it difficult to make optimal decisions. This study aims to develop an effective transformer asset management dashboard using FSN (Fast-Slow-Non Moving) and ABC (Analysis Based Costing) analysis. The research methodology includes identifying system needs, collecting data through observation and interviews, developing solutions using Microsoft Power BI, and testing the User Acceptance Test (UAT). The results showed that the dashboard successfully integrated transformer data with real-time visualization including availability status (2,124 units available, 4,305 ready line units, 2,181 units not ready), ABC-FSN classification (AF 30%, BS 20%, AS 10%, CN 40%), and monthly stock trends. The UAT evaluation of 17 respondents showed an average score of 4.5 with a very appropriate category in the aspects of functional suitability, usability, performance efficiency, reliability, accuracy, visual design, and user satisfaction. Dashboards integrated with the Microsoft 365 ecosystem enable real-time access and support data-driven decision-making for transformer asset management optimization.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Lestari Indah Susanti, Agus Budi Raharjo
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International. that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
