Login Register Cart 0
Generic placeholder image

Recent Advances in Computer Science and Communications

Editor-in-Chief

ISSN (Print): 2666-2558
ISSN (Online): 2666-2566

Back
Journal Home About Journal Editorial Board Current Issue Volumes/Issues
Subscribe
Research Article

A New Approach for EOQ Calculation Using Modified Opportunity Cost

Author(s): Juhi Singh, Mandeep Mittal* and Sarla Pareek

Volume 15, Issue 1, 2022

Published on: 18 August, 2020

Page: [106 - 110] Pages: 5

DOI: 10.2174/2666255813999200818135408

Price: $65

Abstract

Introduction: Optimal inventory levels are necessary for a firm to avoid shortage/ excess of an item. The shortage of an item leads to stock out conditions resulting in loss of profit. When items are correlated with each other, the stock out condition of one item may result in the nonpurchase of its associated items also which, in turn, further brings down the profit. In this paper, this loss in profit is used to modify the opportunity cost of an item resulting in its modified EOQ.

Methods: One illustrative example has been discussed which incorporates purchase dependencies in retail multi-item inventory management. The model discussed in this research paper will be motivational for researchers and inventory managers and provides a method for incorporating correlation among items while managing inventory.

Results: The EOQs of items are estimated both by using the traditional method and then by using modified opportunity cost (modeled as loss profit). Results show that in frequent itemset {A, B, D}, EOQs of all three items increased when correlation among them is considered, resulting in an increase in the profit.

Discussion: In inventory management system, for increasing the profit of a firm, EOQs of items need to be calculated in order to avoid shortage or excess of inventory. For explaining the approach, a very small database is taken consisting of only 5 items and 10 transactions, therefore, the increase in profit is minimal however when this approach is applied on a real database consisting of thousands of items and transactions, the increase in profit will be significant.

Conclusion: One of the major focus areas of inventory management is to determine when and how much quantity of items needs to be ordered so that total inventory cost can be minimized and the profit of a firm can be maximized. However, while calculating the true value of an item and the profit it brings to the firm, it is very essential to analyze its effect on the sale of other items. Association rule mining provides a way to correlate items by calculating support and confidence factor.

Keywords: Terms, Data Mining, Inventory Management, Purchase Dependency, Multi-Item Inventory, opportunity cost.

Graphical Abstract

[1]
P.L. Abad, "Optimal pricing and lot-sizing under conditions of perishability and partial backordering", Manage. Sci., vol. 42, no. 8, pp. 1093-1104, 1996.
[http://dx.doi.org/10.1287/mnsc.42.8.1093]
[2]
P.L. Abad, "Optimal price and order size for a reseller under partial backordering", Comput. Oper. Res., vol. 28, no. 1, pp. 53-65, 2001.
[http://dx.doi.org/10.1016/S0305-0548(99)00086-6]
[3]
S.S. Anand, "Tackling the cross-sales problem using data mining", In Proceedings of the 1st Pacific-Asia Conference on Knowledge, Discovery and Data, vol. 10, no. 7, pp. 449-461, 1997.
[4]
M.R. Asadabadi, "A revision on cost elements of the EOQ model", Stud. Bus. Econ., vol. 11, no. 1, pp. 5-14, 2016.
[http://dx.doi.org/10.1515/sbe-2016-0001]
[5]
P.K. Bala, Data mining for retail inventory management.Advances in Electrical Engineering and Computational Science., Springer: Dordrecht, 2009, pp. 587-598.
[http://dx.doi.org/10.1007/978-90-481-2311-7_50]
[6]
P.K. Bala, S. Sural, and R.N. Banerjee, "Association rule for purchase dependence in multi-item inventory", Prod. Plann. Contr., vol. 21, no. 3, pp. 274-285, 2010.
[http://dx.doi.org/10.1080/09537280903326578]
[7]
P.K. Bala, "An inventory replenishment model under purchase dependency in retail sale", Int. J. Comput. Appl., vol. 37, no. 10, pp. 43-48, 2012.
[8]
T. Brijs, G. Swinnen, K. Vanhoof, and G. Wets, "Using association rules for product assortment decisions: A case study", In Proceedings of the Fifth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, 1999pp. 254-260
[http://dx.doi.org/10.1145/312129.312241]
[9]
E.K. Dewi, M. Dahlui, D. Chalidyanto, and T.N. Rochmah, "Achieving cost-efficient management of drug supply via economic order quantity and minimum-maximum stock level", Expert Rev. Pharmacoecon. Outcomes Res., vol. 20, no. 3, pp. 289-294, 2020.
[PMID: 31203686]
[10]
C.Y. Dye, "Joint pricing and ordering policy for a deteriorating inventory with partial backlogging", Omega, vol. 35, no. 2, pp. 184-189, 2007.
[http://dx.doi.org/10.1016/j.omega.2005.05.002]
[11]
B.C. Giri, A.K. Jalan, and K.S. Chaudhuri, "An economic production lot size model with increasing demand, shortages and partial backlogging", Int. Trans. Oper. Res., vol. 12, no. 2, pp. 235-245, 2005.
[http://dx.doi.org/10.1111/j.1475-3995.2005.00500.x]
[12]
I. Kaku, "A study on inventory policies in a frequent itemset", In Proceedings of 5th Asia-Pacific Industrial Engineering and Management Systems Conference, 2004pp. 16-25
[13]
M. Mittal, J. Singh, A. Aggarwal, K. Kumari, and M. Yadav, "Ordering policy for imperfect quality itemsets using cross selling effects", Int. J. Model. Optim., vol. 4, no. 1, p. 25, 2014.
[http://dx.doi.org/10.7763/IJMO.2014.V4.342]
[14]
D. Rosenberg, "A new analysis of a lot‐size model with partial backlogging", Naval Research Logistics Quarterly, vol. 26, no. 2, pp. 349-353, 1979.
[http://dx.doi.org/10.1002/nav.3800260214]
[15]
K.S. Park, "Inventory model with partial backorders", Int. J. Syst. Sci., vol. 13, no. 12, pp. 1313-1317, 1982.
[http://dx.doi.org/10.1080/00207728208926430]
[16]
D.W. Pentico, and M.J. Drake, "The deterministic EOQ with partial backordering: A new approach", Eur. J. Oper. Res., vol. 194, no. 1, pp. 102-113, 2009.
[http://dx.doi.org/10.1016/j.ejor.2007.12.004]
[17]
D.W. Pentico, and M.J. Drake, "A survey of deterministic models for the EOQ and EPQ with partial backordering", Eur. J. Oper. Res., vol. 214, no. 2, pp. 179-198, 2011.
[http://dx.doi.org/10.1016/j.ejor.2011.01.048]
[18]
A.K. Pujari, Data Mining Techniques., Universities press, 2001.
[19]
E.A. Silver, D.F. Pyke, and R. Peterson, Inventory Management and Production Planning and Scheduling., vol. 3, Wiley: New York, p. 30, 1998.
[20]
G. Suciu, C. Dobre, V. Suciu, G. Todoran, A. Vulpe, and A. Apostu, "Cloud computing for extracting price knowledge from big data", 2015 Ninth International Conference on Complex, Intelligent and Software Intensive Systems, 2015pp. 314-317
[http://dx.doi.org/10.1109/CISIS.2015.44]
[21]
K. Wang, and M.T. Su, "Item selection by “hub-authority” profit ranking", In Proceedings of the Eighth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, 2002pp. 652-657
[22]
H.M. Wee, "Optimal inventory policy with partial backordering", Optim. Control Appl. Methods, vol. 10, no. 2, pp. 181-187, 1989.
[http://dx.doi.org/10.1002/oca.4660100208]
[23]
R.C. Wong, A.W. Fu, and K. Wang, "Data mining for inventory item selection with cross-selling considerations", Data Min. Knowl. Discov., vol. 11, no. 1, pp. 81-112, 2005.
[http://dx.doi.org/10.1007/s10618-005-1359-6]

Rights & Permissions Print Cite
Article Metrics
13
1
© 2024 Bentham Science Publishers | Privacy Policy