Abstract

According to one of the most interested of inventory management issue in industrial and logistics management in today competitive environment, the aim of this work is to develop a determination tools for inventory parameters calculation and analyze the applicable of those parameters into various probability distributed demand. The calculation program incorporated in Microsoft Excel are developed and a series of simulation experiments are also conducted using the developed program in order to compare the total inventory relevant cost of these policies The studies are conducted for different cases of inventory problem with 3-different probability distributions of demand and the obtained results are analyzed and concluded. The program are developed for comparing 8 inventory policies for discrete demand pattern comprising of Adaptation EOQ, Lot-For-Lot, Periodic Order Quantity, Wagner-Whitin, Silver-Meal Algorithm, Least Unit Cost, Part-Period, and Incumented Part-Period. Visual Basic Application (VBA) code, a part of Microsoft Excel, is constructed in order to receive input data, to calculate the inventory policies and relevant total cost and to display program outputs. After verified and validated, the program is implemented for determining inventory policies of various scenarios of problems, including uniform, normally, and discrete distributed demand pattern. The analysis results obtained from program can be concluded that the Wagner-Whitin Algorithm is the best way to provide the lowest total cost by determining the order quantity in all appropriate periods. However, when demand in the first period is equal to 0, we found that the Silver Meal Algorithm may provide the better results than those of Wagner-Whitin. So, in those cases, total relevant cost of the two policies should be compared.

Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call