Perancangan Automatic Placement Order Support Tools di PT X

Chelsy Sandrina Clarita Anen(1*), I Gede Agus Widyadana(2),


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

Abstract


PT X is a global bicycle industry that develops, manufactures, and markets bicycles around the world. One of the brands produced by PT X is brand Y. The problem faced by the Supply Department of brand Y is the inaccuracy of scheduling and determining the number of the lot size of bicycle models in placing orders. This inaccuracy is due to a large number of models, model levels, and SKU (Stock Keeping Units) every year. The purpose of this research is to design placement orders as a supporting tool to predict the schedule and optimizing the number of order lot size in the long run. There are two methods that researcher used, which is qualitatively (by interview) and quantitatively (modeling based on data history and designing the system using Visual Basic Excel version 7.1). The result obtained by this research is the estimated order entered by the user in the system can be scheduled and optimized automatically using excel. The main conclusion that can be drawn is the design of placement orders as a supporting tool that can eliminate the inaccuracy planning of placing orders. This design has also been successfully verified and validated.


Keywords


scheduling; lot size; planning; placement order; stock keeping unit

Full Text:

PDF

References


Kiran, D. R. (2019). Elements of Production Planning and Control, in Production Planning and Control (pp. 1–20). Elsevier. https://doi.org/1 0.1016/b978-0-12-818364-9.00001-9.

Türkay, M. Modeling Optimization Problems INDR 262-Introduction to Optimization Method, retrieved from http://home.ku.edu.tr/~mturkay/I ndr262/INDR262_Modeling.pdf on 13 March 20-21.

Galitz, W. O. and R. Barnett, R., The Essential Guide to User Interface Design, 2007, retrieved from https://www.wiley.com/en-us/The+Essential +Guide+to+User+Interface+Design%3A+An+Int roduction+to+GUI+Design+Principles+and+Techniques%2C+3rd+Edition-p-97 80470053423 on 12 May 2021.

Urtis, T. and Alexander, M., Excel VBA 24 Hour Trainer, 2011, retrieved from https://p2p.wrox.co m/book-excel-vba-24-hour-trainer-2nd-edition-78 6/ on 12 May 2021.

Thacker, B. H. et al., Concepts of Model Verification and Validation, 2004. https://doi.org/ 10.2172/835920.

Silberschatz, A. et al., Database System Concepts, 2020, retrieved from https://www.mheducation. com/highered/product/database-systemconcepts-s ilberschatz-korth/M9 780078022159.html on 12 May 2021.

Kleijnen, J. P. C., Verification and Validation of Simulation Models, European Journal of Operational Research, 82(1), 1995, pp. 145–162. https://doi.org/10.1016/0377-2217(94)00016-6.


Refbacks

  • There are currently no refbacks.