Advertisement

Inventory Control Through ABC/XYZ Analysis

  • Esra Agca AktuncEmail author
  • Meltem Basaran
  • Gozde Ari
  • Mumin Irican
  • Sahna Gungor
Conference paper
Part of the Lecture Notes in Management and Industrial Engineering book series (LNMIE)

Abstract

In this study, inventory and production control of a group of products from a major manufacturer of domestic and industrial gas meters is examined. ABC and XYZ analyses are carried out for the inventory items to determine the production strategy of each item class and the Economic Order Quantity (EOQ). After this examination, one of the end products of the company is chosen to develop the Materials Requirement Plan (MRP) for. The Bill of Materials (BOM) for the chosen product is created and MRP is developed according to the BOM levels. The monthly demand data for the final product is obtained based on the annual demand and the required quantities for all sub materials of the final product are calculated with MRP. Finally, after the ABC/XYZ analysis, BOM structuring, and MRP calculations, a user interface is developed in Excel using Visual Basic for Applications (VBA) to access, edit, and add the desired information easily.

Keywords

Inventory control ABC/XYZ analysis Item classification Materials Requirement Planning (MRP) 

References

  1. Flores, B. E., & Whybark, D. C. (1986). Multiple criteria ABC analysis. International Journal of Operations & Production Management, 6(3), 38–46.CrossRefGoogle Scholar
  2. Hopp, W. J., & Spearman, M. L. (2008). Factory physics (3rd ed.). New York, NY: McGraw-Hill/Irwin.Google Scholar
  3. Johnston, F. R., & Boylan, J. E. (1996). Forecasting for items with intermittent demand. Journal of the Operational Research Society, 47(1), 113–121.CrossRefGoogle Scholar
  4. Liu, J., Liao, X., Zhao, W., & Yang, N. (2016). A classification approach based on the outranking model for multiple criteria ABC analysis. Omega, 61, 19–34.CrossRefGoogle Scholar
  5. McKay, K. N. (2011). The historical foundations of manufacturing planning and control systems. In Kempf, K., Keskinocak, P., & Uzsoy, R. (Eds.), International Series in Operations Research & Management Science, Vol. 151. Planning production and inventories in the extended enterprise. Boston, MA: Springer.Google Scholar
  6. Millstein, M. A., Yang, L., & Li, H. (2014). Optimizing ABC inventory grouping decisions. International Journal of Production Economics, 148, 71–80.CrossRefGoogle Scholar
  7. Min, H., & Zhou, G. (2002). Supply chain modeling: Past, present and future. Computers & Industrial Engineering, 43(1–2), 231–249.CrossRefGoogle Scholar
  8. Nahmias, S. (2005). Production and operations analysis (5th ed.). New York, NY: McGraw-Hill/Irwin.Google Scholar
  9. Orlicky, J. (1975). Material requirements planning. New York, NY: McGraw-Hill.Google Scholar
  10. Partovi, F. Y., & Burton, J. (1993). Using the analytic hierarchy process for ABC analysis. International Journal of Operations & Production Management, 13(9), 29–44.CrossRefGoogle Scholar
  11. Reiner, G., & Trcka, M. (2004). Customized supply chain design: Problems and alternatives for a production company in the food industry—A simulation based analysis. International Journal of Production Economics, 89, 217–229.CrossRefGoogle Scholar
  12. Scholz-Reiter, B., Heger, J., Meinecke, C., & Bergmann, J. (2012). Integration of demand forecasts in ABC-XYZ analysis: Practical investigation at an industrial company. International Journal of Productivity and Performance Management, 61(4), 445–451.CrossRefGoogle Scholar
  13. Silver, E. A., Pyke, D. F., & Peterson, R. (1998). Inventory management and production planning and Scheduling (3rd ed.). New York, NY: Wiley.Google Scholar
  14. Teunter, R. H., Babai, M. Z., & Syntetos, A. A. (2010). ABC classification: Service levels and inventory costs. Production and Operations Management, 19(3), 343–352.CrossRefGoogle Scholar
  15. van Kampen, T. J., Akkerman, R., & van Donk, D. P. (2012). SKU classification: A literature review and conceptual framework. International Journal of Operations & Production Management, 32(7), 850–876.CrossRefGoogle Scholar
  16. Vollmann, T. E., Berry, W. L., Whybark, D. C., & Jacobs, F. R. (2005). Manufacturing planning and control for supply chain management. New York, NY: McGraw-Hill/Irwin.Google Scholar
  17. Yu, M. C. (2011). Multi-criteria ABC analysis using artificial-intelligence-based classification techniques. Expert Systems with Applications, 38(4), 3416–3421.MathSciNetCrossRefGoogle Scholar

Copyright information

© Springer Nature Switzerland AG 2019

Authors and Affiliations

  • Esra Agca Aktunc
    • 1
    Email author
  • Meltem Basaran
    • 1
  • Gozde Ari
    • 1
  • Mumin Irican
    • 1
  • Sahna Gungor
    • 1
  1. 1.Department of Industrial Engineering, Faculty of Engineering and Natural SciencesKadir Has UniversityIstanbulTurkey

Personalised recommendations