The Establishment of Decision Making Support Tool for Inventory Control and Production Planning with Periodic Review System and Linear Programming Approach

Redy Ardiansyah, I Nyoman Pujawan, Niniet Indah Arvitrida

Abstract


PT. Mortars is an instant cement producer with many product variants. Some problems that PT. Mortars encountered are uncertainty of demand, limitation on production capacity, and inventory capacity, which caused product shortages and high inventory costs. The production scheduling process is produced manually so it requires a long time, relying on the ability and experience of the production planner which is vulnerable to mistakes. Therefore, new methods and tools are needed for inventory control and production scheduling to make sure goods are delivered to customer just in time while maintaining operational efficiency. Periodic review system (R,S) and (R, s, S) methods are proposed in this study to improve inventory parameters and reorder systems that have an impact on service levels and inventory costs. The tools are designed using Microsoft Excel software with solver add-ins functions and linear programming approaches to generate optimal production schedule decisions automatically. In order to determine the level of service and inventory costs generated by each method, a simulation is conducted by using the tools that have been made. The simulation of the existing method produces a service level of 98,64% and a total inventory cost of Rp. 1.167.160.494. The periodic review system (R, S) method resulted in increasing service level of 0,96% and lower inventory cost of Rp. 15.130.801 while the periodic review system (R, s, S) method resulted in increasing service level of 1,29% and a lower inventory cost of Rp. 448.653 compared to the existing method. The periodic review system (R, S) method produces the lowest inventory costs while the method (R, s, S) produces the highest service level compared to other methods.

Keywords


Production Planning and Inventory Control; Periodic Review System (R, S); (R, s, S); Linear Programming

Full Text:

PDF

References


L. I. Nicolae, D. Tanasescu, and V. Popa, “Customer Expectations Management,” Valahian J. Econ. Stud., vol. 4, no. 3, pp. 91–100, 2013.

M. Gansterer, “Aggregate planning and forecasting in make-to-order production systems,” 2015, doi: 10.1016/j.ijpe.2015.06.001.

I. N. Pujawan and E. Mahendrawathi, “Supply Chain Management.” Penerbit Andi, Yogyakarta, 2017.

F. M. Takey and M. A. Mesquita, “Aggregate Planning for a Large Food Manufacturer with High Seasonal Demand,” Brazilian J. Oper.

Prod. Manag., vol. 3, no. 1, pp. 05–20, 2006.

E. A. Silver, D. F. Pyke, and D. J. Thomas, Inventory and Production Management in Supply Chains, 3rd ed. John Wiley and Sons, 1998.

J. Heizer, B. Render, and C. Munson, Operations Management, 10th ed. New Jersey: Pearson Education Inc, 2011.

R. B. Chase, F. R. Jacobs, and N. J. Adequilano, Operation

Management for Competitive Advantage. New York: McGraw-

Hil/Irwin, 2006.




DOI: http://dx.doi.org/10.12962/j23546026.y2020i1.11946

Refbacks

  • There are currently no refbacks.


View my Stat: Click Here

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.