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

Authors

  • William Goentoro Industrial Engineering Department, Petra Christian University
  • Karina Agustin Industrial Engineering Department, Petra Christian University

Keywords:

Fotografi Udara, Sejarah, Surabaya

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. 

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.

Downloads

Published

2022-09-26