Production Planning, Inventory and Capacity in PT. WDY and ERP Simulation Open Source
Production Planning, Inventory and Capacity in PT. WDY and ERP Simulation Open Source
Production Planning, Inventory and Capacity in PT. WDY and ERP Simulation Open Source
net/publication/367405355
Production Planning, Inventory and Capacity in PT. WDY and ERP Simulation
Open Source
CITATIONS READS
0 285
3 authors, including:
All content following this page was uploaded by Lina Gozali on 25 January 2023.
Abstract
Production planning is an important activity in the company, production planning at PT. WDY
experienced several problems, namely the company tended to use intuition or experience in
determining lot sizes and sometimes ordered only as needed. This has resulted in several problems
such as increased costs, shortage of raw materials, etc. Therefore, it is necessary to improve the lot
determination process. The improvement process starts with forecasting, where the forecasting
method chosen based on the smallest error rate of 19.46% is the winter method. Then proceed with
the manufacture of MPS, checking capacity using the gross capacity method, calculating the number
of lots and calculating the capacity of each machine. The results of the calculation of factory capacity
show that the factory capacity is larger so that MPS can be implemented. The method of calculating
the number of lots selected is the Wagner within the method with a cost reduction of 14.24%. In the
calculation of machine capacity, it is found that each machine has a capacity greater than what is
needed, which means that each machine can meet consumer demand
Keyword
Production Planning, Forecasting, Capacity Planning, MPS
1. Introduction
PT. WDY is a manufacturing company engaged in printing, this company produces snack food
packaging. The main product produced is in the form of box-shaped snack packaging. not only snack
packaging but also various other product packaging, such as instant noodle packaging, canned
drinks, and mosquito coil packaging. PT. WDY produces tens of thousands of packages in one day
from various orders, seeing many orders, the production process carried out by the company
requires sophisticated and modern machines and tools (Manahan, 2012). The method of planning
and quality control must also be precise, so that it can fulfill a high customer order
Based on information from discussions with the production staff of PT. WDY is known that the
company in determining the lot size of raw materials has not used the right method. Generally,
companies use intuition or experience and order according to consumer demand.
The absence of the right and optimal method and ordering only based on consumer demand, causes
companies to have to order raw materials repeatedly (Kusuma, 2009). Of course, this will cause
ordering costs to rise. In addition, the company also often experiences delays in receiving raw
materials and shortages of raw materials so that the production process is disrupted. The company
also informed that the procurement of raw materials also accounts for 65% of the company's total
costs.
Therefore, the company needs a proposed improvement design for the new lot sizing method
which is expected to help the company overcome the problems that occur. Thus, the purpose of
this study is to determine the right lot sizing method for each material that will be used to make the
product,
make the right material requirements planning to reduce delays and determine the right lotting size
for each material to meet consumer demand, determine the schedule ordering the right raw materials
so that they can be implemented properly.
2. Literature Review
To be able to do research at PT. WDY requires some good knowledge so that it can analyze existing
problems and find solutions to the problems.
Safety stock or safety stock has a very important role in supply chain management. This system is
designed to be able to achieve maximum profit, anticipate changes in market demand and make it
easier to schedule the production of goods (Christifan et.al., 2020).
2.3 Forecasting
Forecasting is the science of predicting future events. Forecasting is done by involving taking
historical data (previous data) and projecting that data into the future with mathematical models
(Agung, 2009).
This demand forecasting activity is an attempt by the company to find out the amount of a product
or group of products in the future under certain constraints or conditions and to minimize the risks
or uncertainties that will be faced (Lefta et.al., 2020).
3. Methods
In the process of collecting data, researchers used observation and interview methods and collected
data through permitted company documents. In conducting this research, the writer uses various
methods in performing calculations and then the results of these calculations are compared with one
another. After making a comparison, then an analysis is carried out to choose which method is the
best that will be suggested to the company.
The method used in the forecast calculation is the single moving average, double moving average,
single exponential smoothing, double exponential smoothing, weighted moving average, quadratic,
decomposition and winter methods.The method used in the calculation of capacity is the method of
capacity planning using the overall factor, bill of labour and resources profile approach.
The method used in determining the number of lots is the fixed lot method, planned order quantity,
lots for lots, economic order quantity, Silver Meal, Wagner Within, Least Total Cost, Least Unit
Cost, and Part Period Balancing. The method used in calculating the required engine capacity and
available engine capacity is the capacity requirement planning method. The ERP simulation carried
out is using an open-source ERP, namely Odoo. The following is a flow chart of the research method
which can be seen in Figure 1 below.
4.1 Forecasting
In forecasting we will use demand data from the previous period, namely data for the past twelve
months. Then, forecasting will be carried out to predict product demand using Minitab software
(Santoso, 2009). The following is the result of demand forecasting for the next twelve months which
can be seen in Table 1 below.
The winter method with an alpha value of 0.9 produces the smallest error value. Therefore, the
authors suggest the company use the Winter Exponential Smoothing method for forecasting.
After the forecasting results are obtained, the next step is to validate the forecasting results. After
the validation of the forecasting results is obtained, then the tracking signal calculation results will
then be plotted (Gunawan et.al.,2020). The plotting results can be seen in Figure 2 below.
Based on the graph above, it can be concluded that the tracking signal value does not cross the upper
and lower control limits. So, it can be concluded that the forecasting results are within the control
limits and can be used.
After the master production schedule has been created, the next step is to validate the master
production schedule that has been made using rough capacity planning or commonly called rough-
cut capacity planning.
May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr
Machine
2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023
Cutting V V V V V V V V V V V V
Printing V V V V V V V V V V V V
Coating
Water V V V V V V V V V V V V
Base
Ponding
V V V V V V V V V V V V
Matic
Gluing
V V V V V V V V V V V V
Machine
After the comparison is made, it can be seen that the demand on the master production schedule can
be met by the factory capacity which is marked with a check mark (V).
Metho
Material
ds
LFL Fixed LUC LTC E
O
Q
Duplex Board
310 GR 610 X Rp21,227,717 Rp22,531,177 Rp19,657,043 Rp16,773,873 Rp17,726,741
650 mm
Liquid Ink
Rp2,543,984 Rp2,112,193 Rp2,223,700 Rp2,132,217 Rp2,295,343
DM-01 Cyan
Liquid Ink
DM-04 Rp1,872,000 Rp2,012,039 Rp1,596,609 Rp1,523,759 Rp2,430,297
Magenta
Liquid Ink Rp2,004,000 Rp2,083,665 Rp2,022,865 Rp1,825,965 Rp2,992,166
DM-08 Yellow
Liquid Ink
DM-06 Pr- Rp1,320,000 Rp1,463,815 Rp1,224,517 Rp1,081,553 Rp2,787,823
Black
DOOS
Rp20,880,000 Rp21,384,702 Rp17,278,170 Rp12,252,855 Rp21,566,611
Packing
Fluid WB
Rp2,232,000 Rp2,607,724 Rp4,129,255 Rp2,815,727 Rp3,350,710
Coating
Lem Perekat Rp1,776,000 Rp1,968,642 Rp2,033,495 Rp2,097,735 Rp2,434,921
Methods
Material
PPB POQ Silver Meal Wagner
Duplex Board 310 GR 610
Rp12,874,580 Rp13,138,578 Rp12,874,914 Rp11,890,806
X 650 mm
Liquid Ink DM-01 Cyan Rp1,813,141 Rp1,857,659 Rp1,930,076 Rp1,522,307
Liquid Ink DM-04 Rp1,539,481 Rp1,605,328 Rp1,620,161 Rp1,379,074
Magenta
Liquid Ink DM-08 Yellow Rp3,262,479 Rp2,548,034 Rp1,754,206 Rp1,718,543
Liquid Ink DM-06 Pr-
Rp1,145,371 Rp1,218,090 Rp1,229,884 Rp1,019,217
Black
DOOS Packing Rp16,284,875 Rp17,383,237 Rp17,561,380 Rp13,871,928
Fluid WB Coating Rp2,343,749 Rp2,553,340 Rp3,072,435 Rp1,659,923
Lem Perekat Rp2,044,383 Rp2,014,274 Rp2,102,524 Rp1,464,462
After looking at the comparison of the costs of each method for each material, the Wagner Withi
method produces the lowest cost compared to all other methods of determining the
size of the number of raw materials ordered. Thus, the authors suggest the factory to use the
Wagner within the method in determining the number of raw materials to be ordered.
Based on the diagram of each machine above, it can be seen that each machine in the factory does
not exceed the total available time owned by the factory, thus each machine can meet consumer
demand.
The implementation of ERP certainly makes the processes within the company easier and more
effective and of course faster. The following is a comparison after ERP implementation which can
be seen in Table 7 below.
The process of calculating whether raw The process of calculating whether or not
materials are sufficient or not in the raw materials are sufficient in the production
production process is carried out manually process is carried out automatically by the
by the operator system
The making of asales, purchases and The making of sales, purchases, and
production invoice are done manually by production invoice are done automatically
operators with different by the system and can
applications be sent directly to consumers
In the calculation of factory capacity, it is found that consumer demand is still below the factory
capacity so that consumer demand can be fulfilled, and the master production schedule can be
implemented.
In the comparison of lot determination methods, it was found that the method with the lowest cost
was the Wagner within the method with a cost reduction percentage of 14.24%.
In the calculation of the capacity of each machine, it can be seen that the production needs for each
machine do not exceed the amount of available time owned by the factory, thus each machine is able
to meet consumer needs.
The application of enterprise resource planning can help improve company performance in planning
and controlling production. Some of the benefits obtained include information on the availability of
raw materials which is always updated automatically, a fast calculation process, open information
sharing between departments, and increased coordination and cooperation between divisions.
6. Conclusion
Based on the research that has been done, several conclusions can be drawn. The following are some
conclusions that can be drawn.
a. Forecasting is an important first step in production planning. The right forecast in this study
based on the smallest error is forecasting with the winter method with alpha 0.9 which has
an error rate of 19.48% MAPE, 87576.90 MAD, and 11225900000.00 MSE.
b. The comparison of factory capacity and required capacity using the RCCP method states that
the total required capacity of 446.58 hours can be fulfilled by the factory of 131152 hours.
c. The method of determining the right number of lots used by the factory is the Wagner Within
method with a cost reduction percentage of 47.5%, a percentage decrease in ordering
frequency by 10%, and a decrease in the amount of inventory by 75.8%.
d. The calculation of the capacity of each machine using the CRP method shows that the time
it takes for each machine to produce consumer demand can be met. The need for 4546 hours
on the cutting machine can be met with a capacity of 16960 hours, the need for 5891 hours
on the printing machine can be met with a capacity of 57701 hours, the need for 10340 hours
on the coating machine can be met with a capacity of 19843 hours, the need for 7432 hours
on the ponding machine can be met with a capacity of 25446 hours and the need for 2136
hours on the glue machine can be met with a capacity of 11200 hours.
e. The implementation of an ERP system in planning and controlling production will make the
company become and. ERP systems can help companies integrate all operational processes
quickly and automatically
References
Agung, A. Penerapan Metode Single Moving Average Dan Exponential Smoothing Dalam
Peramalan Permintaan Produk Meubel Jenis Coffee Table Pada Java Furniture Klaten.
Surakarta. 2009.
Bustami, Bastian and Nurlela. Akuntansi Biaya. Edisi 4. Jakarta: Mitra Wacana Media
2013.Budiastuti, Fatkar. Pengaruh Volume Penjualan dan Biaya Produksi Terhadap
Laba Bersih pada PT Indah Kiat Pulp and Paper Tbk., Jurnal Ekonomi & Bisnis, Vol.
1., No. XXIV, 2016 Christifan, A. J., & Gozali, L. Application of MRP System for
Control of Raw
Material Inventory with EOQ Lot Sizing. In IOP Conference Series: Materials Science and
Engineering (Vol. 1007, No. 1, p. 012029). IOP Publishing. (2020, December).
Fahmi, Irham. Manajemen Produksi dan Operasi.Penerbit Alfabeta, Bandung. 2016.
Gozali, L., Marie, I. A., Hoswari, S., Christifan, A. J., Gunawan, P. A., Elliani, M. F. G. C., &
Natasha, T. Forecasting Using Artificial Neural Networks and Aggregate Production
Planning and Dynamic Model of Inventory Control for Rib and Single Knit Fabric.
In IOP Conference Series: Materials Science and Engineering (Vol. 1007, No. 1, p. 012023). IOP
Publishing. (2020, December).
Gunawan, P. A., Gozali, L., Widodo, L., Daywin, F. J., & Olyvia, C. 2020. Production Planning and
Capacity Control with Demand Forecasting Using Artificial Neural Network (Case
Study PT. Dynaplast) for Industry 4.0. Proceeding IEOM, Singapore
Heizer J, dan Render B. Manajemen Operasi Edisi ketujuh. Jakarta: Salemba Empat. 2006.
Hasan, Irmayanti. Manajemen Operasional: Perspektif Integratif. Malang: UIN-Maliki Press
2011.Handoko, T., Hani. 2011. Dasar-dasar Manajemen Produksi dan Operasi.
Yogyakarta: BPFE Indrajit, Richardus Eko and Richardus Djokopranoto. 2003.
Manajemen Persediaan. PT. Gramedia Widiasarana Indonesia: Jakarta
Kusuma, Hendra. Production Planning and Inventory Control. Jakarta: Gramedia Pustaka Utama.
2009.
Lefta , F., Gozali, L., & Marie, I. A. Aggregate and Disaggregate Production Planning, Material
Requirement, and Capacity Requirement in PT. XYZ. In IOP Conference Series:
Materials Science and Engineering (Vol. 852, No. 1, p. 012123). IOP Publishing. (2020,
July).
Lieberty, A. and Imbar, R. Sistem Informasi Meramalkan Penjualan Barang Dengan Metode
Double Exponential Smoothing (Studi Kasus: PD. Padalarang Jaya). Jurnal Teknik
Informatika Volume 1 Nomor 1, 27-32. 2015.
Manahan, P. Tampubolon. Manajemen Operasional Edisi Pertama. Ghalia Indonesia. 2012.
Putri, N. V., & Gozali, L. Material Requirement Planning on Y-Strainer Production (Case Study at
PT. XYZ). Proceeding IEOM, Surakarta, Indonesia2021.
Rangkuti, Freddy. Manajemen Persediaan: Aplikasi di Bidang Bisnis. Jakarta: Raja Grafindo
Persada 2007.
Santoso, Singgih. Business Forecasting, Metode peramalan bisnis masa kini dengan minitab dan
SPSS. Jakarta: PT. Elex Media Komputindo. 2009.
Sinulingga, Sukaria. Perencanaan & Pengendalian Produksi. Yogyakarta: Graha Ilmu.
Sitompul, Rio, Oloan. Aplikasi Metode Economic Order Quantity (EOQ) untuk Mengoptimalkan
Persediaan Bahan Bakar Minyak di PT Kereta Api (Persero) Medan. Fakultas 2011.
Matematika dan Ilmu Pengetahuan Alam Universitas Sumatera Utara, Medan. 2009.
Wijaya, A. T., Lefta, F., Gozali, L., & Daywin, F. J., December). Forecasting Analysis at PT. Lion
Metal Works Using Artificial Neural Network. In IOP Conference Series: Materials
Science and Engineering (Vol. 1007, No. 1, p. 012184). IOP Publishing. (2020
Biographies
Bratayuda Raya is a final year student at Tarumanagara University majoring in industrial
engineering. He is active in campus organizations. He once become a leader in one of the campus
organizations from 2020 to 2021. He also ever joins the student creativity program about product
designing to get a scholarship from Tarumanagara University.
Lina Gozali is a lecturer in the Industrial Engineering Department at Universitas Tarumangara since
2006 and a free-lance lecturer at Universitas Trisakti since 1995. She got her bachelor’s degree at
Trisakti University, Jakarta - Indonesia, then she graduated master’s degree at STIE IBII, Jakarta –
Indonesia, and graduated with her Ph.D. at Universiti Teknologi Malaysia, Kuala Lumpur –
Malaysia in 2018. Her apprentice college experience was in paper at Kertas Bekasi Teguh, shoe at
PT Jaya Harapan Barutama, automotive chain drive industry at Federal Superior Chain
Manufacturing. She teaches Production System and Supply Chain Management Subjects and her
Ph.D. research about Indonesian Business Incubator. She actively writes for almost 40 publications
since 2008 in the Industrial Engineering research sector, such as Production Scheduling, Plant
LayOut, Maintenance, Line Balancing, Supply Chain Management, Production Planning, and
Inventory Control. She had been worked at PT. Astra Otoparts Tbk as International.