Perancangan Dashboard SPC Excel Sebagai Alat Analisis Kinerja Mesin Filling Pada PT SMART Tbk.

Ancelloti Alessandro, Nova Sepadyati


PT SMART, Tbk, is an agribusiness company that produce product from processed palm oil, the most well known product is cooking oil. Cooking oil product has quality specification to fulfill customer’s satisfaction, one of them is conformity of actual volume with volume that printed on the label. This quality specification affected by filling machine performance, therefore tool that can help create machine performance evaluation is needed. The purpose of this study is to design a dashboard  that can reduce time to process data into statistic parameters and to test the properness number of samples in current condition. Design of the dashboard will use Microsoft Excel program with Visual Basic for Application (VBA). The performance evaluation  is using statistic parameters (Cp, Cpk, and Sigma), while the properness of sample number is using two sample T-test. Dashboard reduce the processing time from 230% up to 763% and majority of the machine performance are lower than the standard. The result of number of samples’ test showed that total samples of 98 per hour has different significantly against total samples of 5 per hour, so that the sample number must be increased in order to represent the actual condition.


dashboard; SPC; sampling; PT SMART Tbk.

Full Text:



Menteri Perdagangan Indonesia, Barang Dalam Keadaan Terbungkus (NOMOR 31/M-DAG/PER/10/2011), Menteri Perdagangan Indonesia, Jakarta (ID), 2011.

International Organization of Legal Metrology, International Recommendation: Quantity of Product in Prepackages (OIML R 87 Edition 2016), International Organization of Legal Metrology, Prancis, 2016.

Gitlow, H., Quality Management, Third Edition, McGraw Hill Companies, Inc, New York, 2011.

Pande, P. and Holp, L., What is Six Sigma?. McGraw Hill Companies, Inc, New York, 2001.

Harry, M. and Scroeder, R., Six Sigma: Breakthrough Management Strategy Revolutionizing The World’s Top Corportaions. Random House, Inc, New York, 2000.

Anwar, H., Tutorial IndependenT Test dengan SPSS, 2017, retrieved from

/ on 9 May 2019.

Winston, W. L., Microsoft Office Excel Data Analysis and Business Modeling, H.B Fenn and Company Ltd, Washington, 2007.


  • There are currently no refbacks.