Spreadsheet-Based Automatic Print Cost Calculator

Mokhamad Ariel Fadilah; Izza Anshory; Jamaaluddin Jamaaluddin; Agus Hayatal Falah

doi:10.47709/cnahpc.v6i1.3492

Authors

Mokhamad Ariel Fadilah Department of Electrical Engineering, Universitas Muhammadiyah Sidoarjo, East Java, Indonesia
Izza Anshory Department of Electrical Engineering, Universitas Muhammadiyah Sidoarjo, East Java, Indonesia
Jamaaluddin Department of Electrical Engineering, Universitas Muhammadiyah Sidoarjo, East Java, Indonesia
Agus Hayatal Falah Department of Electrical Engineering, Universitas Muhammadiyah Sidoarjo, East Java, Indonesia

DOI:

10.47709/cnahpc.v6i1.3492

Keywords:

Spreadsheet, Esp32, TCS 3200, Infrared, Automatic

Dimension Badge Record

Abstract

Production cost calculation is a crucial factor that impacts productivity and profitability in the printing industry. This study presents an automatic print costing tool that runs on a spreadsheet and is intended to increase operational efficiency and calculation accuracy in Small and Medium-Sized Printing Enterprises (SMEs). With the use of Esp32 as a microcontroller, TCS3200 and infrared sensors, this project seeks to create an automated print pricing spreadsheet that would help printing SMEs swiftly and precisely determine product prices. This tool's components include an LCD to show the cost computation findings, an infrared sensor to identify the number of printed sheets, a TCS3200 sensor to determine whether or not colored paper is present, and a push button feature to resume the calculation and upload the entire cost to the spreadsheet. The instrument functions effectively and aids users in doing cost calculations in an efficient manner, according to the findings. Despite some challenges, such as slow internet connections that cause delays, to enable effective cost assessment poor internet connection. This strategy should decrease calculation errors and increase manufacturing cost management effectiveness.

Downloads

Download data is not yet available.

Google Scholar Cite Analysis
Abstract viewed = 125 times

References

Anshory, I., Hadidjaja, D., & Sulistiyowati, I. (2021). Implementation of Automatic Handwashing Waist for Covid-19 Prevention. Jambura Journal of Health Sciences and Research, 3(2), 154–161. https://doi.org/10.35971/jjhsr.v3i2.9798

Hariyanto, M., & Nasution, M. I. (2022). Prototipe Alat Penghitung Harga Pada Print- Out Engan Sensor Warna Tcs3200 Serta Sistem Penyimpanan Data Logger. 7(2), 73–82.

Ibrahim. (2018). Bangka Belitung: Electoral Dynamics in Indonesia, 87–101. https://doi.org/10.2307/j.ctv1xxzz2.11

Jamaaluddin, J. (2019). Sistem Kontrol Pendingin Mobil Ramah Lingkungan Berbasis Android. Cyclotron, 2(1). https://doi.org/10.30651/cl.v2i1.2528

Jamaaluddin, J., & Sumarno, S. (2017). Perencanaan Sistem Pentanahan Tenaga Listrik Terintegrasi Pada Bangunan. JEEE-U (Journal of Electrical and Electronic Engineering-UMSIDA), 1(1), 29–33. https://doi.org/10.21070/jeee-u.v1i1.375

Nasional, S., Elektro, T., Informasi, S., & Informatika, T. (2021). Seminar Nasional Teknik Elektro, Sistem Informasi, dan Teknik Informatika. 219–224.

Putri Riyanto, H. A. (2021). Rancang Bangun Sortir Dan Hitung Lembar Kertas a4 Otomatis Menggunakan Sensor Ldr Dan Aplikasi Blynk. Journal of Energy and Electrical Engineering, 2(2), 37–44. https://doi.org/10.37058/jeee.v2i2.2932

Rochana, I. H., & Utami, A. W. (2021). Rancang Bangun Sistem Pendukung Penghitungan Biaya Produksi dengan Metode TDABC dan MOST. 02(02), 30–36.

Solih, A., & Jamaaluddin, J. (2017). Rancang Bangun Pengaman Panel Distribusi Tenaga Listrik Di Lippo Plaza Sidoarjo Dari Kebakaran Berbasis Arduino Nano. JEEE-U (Journal of Electrical and Electronic Engineering-UMSIDA), 1(2), 61–68. https://doi.org/10.21070/jeee-u.v1i2.1171

Sulistiyowati, I., Findawati, Y., Ayubi, S. K. A., Jamaaluddin, J., & Sulistyanto, M. P. T. (2019). Cigarette detection system in closed rooms based on Internet of Thing (IoT). Journal of Physics: Conference Series, 1402(4). https://doi.org/10.1088/1742-6596/1402/4/044005

Susanto A, Safari I, & Kusumah H. (2018). Alat penghitung jumlah lembar kertas berbasis internet of things menggunakan infra red pada PT Indah Kiat. Teknologi Informasi Dan Multimedia, 1(2), 1–6.

Suwandahwana, R. (2019). Perancangan Dan Pembuatan Alat Penghitung Jumlah Lembar Kertas Hasil Proses Cetak. http://repository.unpas.ac.id/40983/%0Ahttp://repository.unpas.ac.id/40983/1/Ripan Suwandahwana_143030122_Teknik Mesin.pdf

Ulum, M., Anshory, I., Saputra, D. H. R., & Ayuni, S. D. (2021). Arduino Based Multifunction Fan. Procedia of Engineering and Life Science, 1(2). https://doi.org/10.21070/pels.v1i2.1026

Wulandari, S., & Satria, B. (2021). Rancang Bangun Alat Pendeteksi Warna Menggunakan Arduino Uno Berbasis IoT (Internet Of Things). Paradigma - Jurnal Komputer Dan Informatika, 23(1). https://doi.org/10.31294/p.v23i1.9861

Zhou, Yang, & Wang. (2020). No ????????????????????? ?????????????????Title. File:///C:/Users/VERA/Downloads/ASKEP_AGREGAT_ANAK_and_REMAJA_PRINT.Docx, 21(1), 1–9.