Journal of Computer Networks, Architecture and High Performance Computing
Vol. 6 No. 1 (2024): Article Research Volume 6 Issue 1, January 2024

Spreadsheet-Based Automatic Print Cost Calculator

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 Jamaaluddin (Department of Electrical Engineering, Universitas Muhammadiyah Sidoarjo, East Java, Indonesia)
Agus Hayatal Falah (Department of Electrical Engineering, Universitas Muhammadiyah Sidoarjo, East Java, Indonesia)



Article Info

Publish Date
26 Jan 2024

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.

Copyrights © 2024






Journal Info

Abbrev

CNAPC

Publisher

Subject

Computer Science & IT Education

Description

Journal of Computer Networks, Architecture and Performance Computing is a scientific journal that contains all the results of research by lecturers, researchers, especially in the fields of computer networks, computer architecture, computing. this journal is published by Information Technology and ...