Comparing Lot Sizing Techniques for Unstable Demand Inventory of a Hardware Retailer

Main Article Content

Sunitiya Thuannadee Thunyaporn Lekdee Marisa Sarajan Wanvisa Kaensanthia Wanwimon Phracharoen

Abstract

The objective of this research is to compare the inventory costs with the actual ones in a hardware retailer using the optimum Wagner-Whitin algorithm and heuristic methods. The selected heuristic methods for this study are Part-Period Balancing, Silver-Meal Heuristic, and Least Unit Cost. Class A products purchased from three major vendors were chosen for this study and single-item ordering was assumed. The weekly demand from July to December 2017 was used as the input. Also, the retailer’s actual inventory costs during this period were determined to compare with the inventory costs using selected lot sizing techniques. The coefficient of variation of each item was greater than 0.20 demonstrating the fluctuating demand. The results showed that the heuristic methods had lower inventory costs than the actual costs for every item in the study. The average cost penalty using the heuristic methods instead of the optimal Wagner-Whitin algorithm was less than 8%. The overall average inventory cost of Silver-Meal method was the least among the heuristic methods. The difference of the average costs among heuristic methods did not exceed 3%.

Keywords

Article Details

Section
Engineering Research Articles

References

[1] C. H. Glock, E. H. Grosse, and J. M. Ries, “The lot sizing problem: A tertiary study,” International Journal of Production Economics, vol. 155, pp. 39–51, 2014.

[2] W. J. Stevenson, Operations Management, 12th ed., NY: McGraw-Hill, 2015.

[3] H. M. Wagner and T. M. Whitin, “Dynamic version of the economic lot size model,” Management Science, vol. 5, no.1, pp. 89–96, 1958.

[4] E. A. Silver, D. F. Pyke, and D. J. Thomas, Inventory and Production Management in Supply Chains, 4th ed., Boca Raton, FL: CRC Press, 2017.

[5] C. Thavornwat and R. Kanchana, “Improvement of the inventory management system: A case study in make-to-order production system,” Journal of Engineering, RMUTT, vol. 11, no. 2, pp. 13–23, 2013 (in Thai).

[6] K. Phalika and N. Suwannasap, “Inventory management by applying the theory of ABC classification analysis, EOQ model techniques and Silver-method: A case study of XYZ,” Phranakhon Rajabhat Research Journal (Humanities and Social Sciences), vol. 11, no. 1, pp. 102–114, 2016 (in Thai).

[7] J. Uansamer and O. Kittithreerapronchai, “Chemical inventory management in tire cord fabric industry using lot sizing,” The Journal of King Mongkut’s University of Technology North Bangkok, vol. 24, no 2, pp. 308–317, 2014 (in Thai).

[8] P. M. Swamidass, “Wagner-Whitin Algorithm,” in Encyclopedia of Production and Manufacturing Management, Boston, MA: Springer, 2000.

[9] R Core Team. (2013). R: A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria. [Online]. Available: http://www.R-project.org/

[10] M. Marchena. (2018, March). SCperf: Functions for Planning and Managing Inventories in a Supply Chain. R package version 1.1.1 [Online]. Available: https://CRAN.R-project.org/package=SCperf

[11] M. Scherotter. (2015, October) Small Basic 1.2 Released with Kinect Support and Bug Fixes. Small Basic. MSDN Blogs. Microsoft [Online], Available: https://blogs.msdn.microsoft.com/smallbasic/2015/10/01/small-basic-1-2-releasedwith-kinect-support-and-bug-fixes/

[12] M. O’Connor. (2018, September). “Coefficient of variation”. Lean Math: Figuring to Improve Blog, [Online], Available: http://www.leanmath.com/blog-entry/coefficient-variation