Cipasung Techno Pesantren: Scientific Journal
Vol 16 No 1 (2022): Cipasung Techno Pesantren: Scientific Journal

Analisis Beak Even Point dan Perancangan Alat Bantu Pencatatan Penjualan dan Barang Kembali Menggunakan Template Excel di Toko Korea Silver

Salim (Program Studi Teknik Industri Sekolah Tinggi Teknologi Cipasung)
Agus Tri Santosa (Program Studi Teknik Industri Sekolah Tinggi Teknologi Cipasung)
Nisa Nur Apipah (Program Studi Teknik Industri Sekolah Tinggi Teknologi Cipasung)



Article Info

Publish Date
05 Sep 2022

Abstract

Korea Silver Store was established on March 09, 2017, located at Panyingkiran number 55 Singaparna, is a business engaged in the sale and purchase of silver jewelry. The Korea Silver shop still records daily data manually, namely writing in the cash book tends to be ineffective, so the owner has not been able to analyze the minimum sales volume of silver so that the business carried out does not suffer losses. The research method used to calculate the volume of silver sales using break-even analysis and the method of recording daily data using an excel template. The results of the excel template design show that sales data display, returned goods, and daily total sales and goods returns are obtained. While the results of the calculation of the break-even point obtained a silver sales volume of 16,577.5893 grams or Rp. 341,692,333.

Copyrights © 2022






Journal Info

Abbrev

CTP

Publisher

Subject

Computer Science & IT Engineering Environmental Science Industrial & Manufacturing Engineering Materials Science & Nanotechnology

Description

Cipasung Techno Pesantren (CTP) which is published biannually is a scientific journal that contains scientific articles from community services, original research, and literature review in the fields of engineering, science, and technology, especially in the following area: Industrial Engineering ...