The Important Role of Microsoft Power Business Intelligence Tool for Analyzing Unit Cost
DOI:
https://doi.org/10.31098/icmrsi.v1i.849Keywords:
Unit Cost, Microsoft Power BI, Meta data, Idle CapacityAbstract
Problematic problems in calculating unit cost for institution can lead the wrong decision taken by management. Those problems such are lack data information for analyzing, difficulties in querying meta data, illiterates in using tools of technology, and still many other problems. Management’s leader will be difficult to make decision if the meta data as the sources of information cannot be crystalized as requested. This research is conducted for answering the curiosity regarding determination of unit cost that be mining from meta data sources. The originality value of this research is for answering the curiosity in determining unit cost. This research takes place in the higher institutional education along with the name of State University of Jakarta. As Educational Institution, State University of Jakarta is not fully funded by the government of Indonesian Republic. This institution is considered as public entity that part of its funding come from government and the rest of funding come from the ability of institution in generating income. Economics, efficient, and effective are the most determination that should be achieved by State University of Jakarta that is not fully funded by The Indonesian Government. For this reason, State University of Jakarta should be aware in managing available income for institution survival. In analyzing meta data for the consumption of decision making, the researcher has explored the usage of Microsoft Power Business Intelligence (BI) tool for determining unit cost each unit in this institution. Through this tool, then researcher analyzing and describing the crystalized meta data that supported calculation for unit cost. The value result of this research shows that almost 65% of the total units cannot surviving its own entity. In the conclusion, this institution should be able to querying cost in each unit. Determination of direct cost and indirect cost for each unit should be placed proportionally. Also, tuition fee should be able to cover the idle capacity of unit that in the previous time suffering deficit.References
Amanda, Rizki, Perdana. (2021). Penerapan metode projected unit credit tipe constant dollar pada perhitungan aktuaria dana pensiun: Buletin Ilmiah Math. Stat. dan Terapannya (Bimaster) Volume 10, No. 2 (2021), hal 203 – 208.
Arens, Alvin A., et al. (2020). Auditing and assurance services 17th edition. Pearson.
Aziza, Nurul. (2021). Akuntansi biaya. Konsep dasar dan manajemen. Diandra Kreatif.
Collie, Rob, Avi Singh. (2019). Power pivot and power BI. Merritt Island. Holy Macro:11
Deckler, Greg. (2019). Learn power BI. Livery: Packt Publishing
Easterita, Arwani. (2020). Pengembangan data warehouse dan online analytical processing (olap) untuk data artikel pada jurnal teknologi informasi dan ilmu computer. Jurnal Sistem Informasi Teknologi Informasi dan Edukasi Sistem Informas.
https://doi.org/10.25126/justsi.v1i1.2.
Ferrari, Alberto, Marco Russo. (2017). Analyzing data with Microsoft Power BI and Power Pivot for Excel. Washington:Microsoft Press:12.
Gondodiyoto, Sanyoto. (2023). Audit sistem informasi + pendekatan cobit. Jakarta: Mitra Wacana Media.
Hariyani, Arum. (2022). Analisis sistem pengolahan data elektronik mengenai barang milik negara pada komisi aparatur sipil negara. SERASI Volume 20, Nomor 02, Oktober 2022.
Hermawan, Eviyanti. (2023). Analisis perhitungan biaya kualitas (cost of quality) untuk meningkatkan kualitas produk. Jurnal Aktual Akuntansi Bisnis Terapan. Vol. 6 No. 1 Mei 2023.
Irawan. (2019). Model Analisis Data dengan Power BI Deskstop. Jakarta: Direktorat Pemeriksaan dan Penagihan V.1: 18–24.
Jadhav, Monal D., Ashlesha B. Shelar, Assistant Prof. Sujeet More. (2022). HR people data analytics using power BI data visualization tool. International Journal of Research Publication and Reviews, Vol 3 No 4: 3335–3338.
Jessica S. (2023). Analisis perhitungan biaya produksi menggunakan metode variabel costing PT Asrindo Citrasubur Makmur (ACM). Inspirasi Ekonomi Jurnal Ekonomi Manajemen 5(2):74-83
Muassar, Mifta Zulfahmi. (2022). Implementation of dashboard power BI for data visualization of graduates during COVID-19 pandemic in the faculty of tarbiyah and teaching sciences IAIN Palopo. Palopo: Journal of Information Technology and Its Utilization, Vol 5.
Nur, Sri Wahyuni. (2020). Akuntansi dasar: Teori dan teknik penyusunan laporan keuangan. Makassar: Cendekia Publisher: 58.
Okafor, Afomachukwu E. (2021). Influence of monitoring and evaluation system on the performance of projects: IJRDO – Journal of Social Science and Humanities Research, ISSN: 2456–2971.
Osman, Ahmed M. Shahat, Ahmed Elragal. (2021). Smart cities and big data analytics: Data – Driven Decision – Making Use Case. Switzerland MDPI: 286-313.
Pamungkas, Ghozali I, et al. (2018). Corporate governance mechanisms in preventing accounting fraud: A study of fraud pentagon model. Journal of Applied Economic Sciences 13 (2), 549-560
Purwanti, Sudarto, Rusmana. (2022). Penerapan metode activity based costing dalam perhitungan unit cost sebagai metode alternatif pada penentuan tarif pemeriksaan laboratorium dan radiologi (studi kasus di RSOP). Jurnal Ekonomi, Bisnis dan Akuntansi (JEBA) Volume 24 No 1 Tahun 2022.
Purwanto, Watini. (2020). Analisis harga pokok produksi mmenggunakan metode full costing dalam penetapan harga jual (studi kasus unit usaha regar fruit). Journal of Applied Managerial Accounting vol. {4}, No. {2}, {2020}, {248-253} ISSN: {2548-9917} (online version).
Rahayu, Murtinah. (2022). Pelaksanaan pengadaan barang/jasa secara elektronik di unit layanan pengadaan biro umum, sekretariat presiden. Journal of Business Administration Economics and Entrepreneurship (JBEST) Vol. 5, No.2 (2023).
Roy, Sharma, et all. (2019). Pre-processing: A data preparation step. Reference Module in Life Sciences 2019.
Titarsole, Nangoy, Kalalo. (2019). Analisis dampak electronic data processing (edp) terhadap pelaksanaan audit internal pada PT. BPR Bank Prisma Dana Manado. Jurnal Riset Ekonomi, Manajemen, Bisnis dan Akuntansi, Vol. 7 No. 3 (2019): JE VOL 7 NO 3 (2019).
Tito IM. Hakim. (2018). Activity-based costing and its derivatives and significance in the cutting-edge environment. The International Journal of Applied Business. Volume 2 Nomor 2, November 2018.
Zunaidi, Arif, Andriani, Oktaria Ardika Putri. (2022). Peran monitoring dan evaluasi audit mutu internal dalam upaya mewujudkan good university governance IAIN Kediri. Kediri: Abdimas Galuh, Vol 4 No.1: 1–9.
