Perhitungan Ongkos Pemesinan Konvensional Menggunakan Macro Vba Excel pada Studi Kasus (Produk Roda Gigi Payung Ø65mm × Z24)
DOI:
https://doi.org/10.37859/jst.v11i1.6802
Abstract
In the conventional machining process, production costs are essential to know to determine the cost of making a product in any industrial manufacturing such as the SMK N 2 PEKANBARU machining workshop. Machining production costs are calculated based on machining time per product and machining operation costs. In calculating conventional machining costs, the VBA Excel macro is an application that can be used to calculate production costs. The Ø65mm × z24 umbrella gear product which is the research case study is a product that is machined by two conventional machining processes, namely lathe machining and milling machining. From the results of the research, the cost of conventional lathe machining, namely making gear wheels, is IDR 47,841/product, and the conventional milling process, namely making Z24 gears, is IDR 40,002/product, while the machining cost for lathe mastercam simulation is IDR 33,187/product and the machining cost for milling mastercam simulation is IDR 20,340/product. Machining costs are the product of operating costs per minute (cm) and machining time (tm). So, from the results of calculating machining and production costs, it is known that the product manufacturing costs or production costs for Ø65mm × Z24 umbrella gears are in the range of IDR 111,827 - IDR 146,143/product.
Downloads
References
Rochim, T. 2007. Optimasi Proses Pemesinan: Ongkos Operasi, Buku 3. ITB. Bandung.
Niazi, A. 2006. Product Cost Estimation : Technique Classification and Methodology .Departement of Mechanical Engineering , School of Physical Sciences and Engineering. University od London.
Dinana, A. 2016. Sistem Pengelolaan Nilai Rapor Berbasis VBA Di MTS Ali Maksum. Tugas Akhir Skripsi, Program Studi Pendidikan Teknik Informatika, Fakultas Teknik Universitas Negeri Yogyakarta.
Ardian, M. 2021. Pedoman Penyusunan Dokumen Administratif Penerapan Badan Layanan Umum Daerah (Blud) Sekolah Menengah Kejuruan. Jakarta, 22 oktober 2018.
Kirono, S. 2011. Pengaruh Tempering pada Baja ST 37 Yang Mengalami Karburasi Dengan Bahan Padat Terhadap Sifat Mekanis dan Struktur Mikro. Jurusan Teknik Mesin, Universitas Muhammadiyah Jakarta.
Atmadio, N. 2018. Optimasi Jalan Pahat Dan Analisis Biaya Produksi Proses Pemesinan CNC Lathe Pembuatan Piston Master Cylinder Rem Sepeda Motor Yamaha Menggunakan CAM. Jurusan Teknik Mesin, Universitas Riau. Jom Fteknik Volume 5 No.1 April 2018.
Azminur. 2015. Analisa Perhitungan Waktu dan Biaya Produksi pada Proses Drilling. Jurusan Teknik Mesin, Politeknik Negeri Lhokseumawe: LJTMU: Vol. 02, No. 02, Oktober 2015.
Fauzi, A. 2018. Pengaruh Feed Rate pada Proses Slot Milling Dengan Metode Minimum Quantity Lubrication Terhadap Kekasaran Permukaan Aluminium A6061. Skripsi Teknik Mesin, Fakultas Teknik Universitas Brawijaya.
