Rancangan Pembuatan Program Perhitungan Packing Material Menggunakan Macro Excel pada PT Trias Sentosa

William Goentoro(1*), Karina Agustin(2),


(1) Industrial Engineering Department, Petra Christian University
(2) Industrial Engineering Department, Petra Christian University
(*) Corresponding Author

Abstract


Packing material calculation is an important things to be considered by the company. Company still uses a manual method to calculate packing material. Calculation program only calculate four type of packing material which is plywood, pallet, fitting and box. These four packing materials must be adjusted with the company products characteristics that makes these four packing materials have special calculation to increase productivity. Program was made using software called Macro Excel. Designing program provides convenience for company to minimize time and human error. This program also accompanied with a digital dashboard that give information about reorder point and economic order quantity of these four packing materials. 


Keywords


packing material; macro excel; dashboard; reorder point; economic order quantity

Full Text:

PDF

References


Walkenbach, J., Excel VBA Programming for Dummies 3rd ed., John Wiley and Sons, Hoboken, New Jersey, 2004.

Ramussen, N., Bansal, M., and Chen, C. Y., Business Dashboard: A Virtual Catalog for Design and Development, John Wiley and Sons, Hoboken, New Jersey, 2009.

Montgomery, D. C., Design and Analysis of Experiments 8th ed., John Wiley and Sons, Arizona, United States of America, 2013.

Murphy, P. R., and Wood, D., Contemporary Logistics 9th ed., Pearson Education, New Jersey, 2008.

Fitzsimmons, J. A., and Fitzsimmons, M. J., Service Management: Operations, Strategy and Information Technology 3rd ed., McGraw-Hill, Boston, New York, 2001.

Petty, J. W., Keown, A. J., Martin, J. D., and Scott, D. F., Foundations of Finance: The Logic and Practice of Financial Management 6th ed., Prentice Hall, New Jersey, 2008.


Refbacks

  • There are currently no refbacks.