Development of spreadsheet simulation models of gas cylinders inventory management
Open Access
- 31 March 2022
- journal article
- Published by OU Scientific Route in EUREKA: Physics and Engineering
- No. 2,p. 116-127
- https://doi.org/10.21303/2461-4262.2022.002266
Abstract
The solution of the problem of managing the inventory of an enterprise whose activities are related to the purchase and sale of gas cylinders is considered. To solve the problem, it was necessary to investigate and choose the best inventory management strategy that provides the minimum value of the average inventory balance in the warehouse with the established upper limit of the average deficit. The problem of determining the best strategy is presented as a discrete programming problem, the required variables of which depend on the replenishment method. With a periodic replenishment strategy, the controlled variables are the volume of the delivery line and the delivery interval, with a threshold one, the minimum inventory level and the volume of the delivery line. Let’s also consider replenishment with a predicted inventory level, where the delivery level and the minimum inventory level are used as control variables. Three tabular simulation models with a given delivery time and random demand are proposed. Using the Chi-square test, it was found that the quantity demanded has a normal distribution law. By carrying out computational experiments, the optimal values of controlled variables were determined. The best objective function values were obtained using a model with a predicted inventory level and a threshold replenishment strategy. Experiments conducted on the basis of historical data have shown the advantage of the two model strategies compared to the strategy currently used in the enterprise. The use of a model with a predictable inventory level would reduce the average inventory balance by 46 %, and, consequently, save working capital. The results of the study can be useful for managers of enterprises whose activities are related to inventory managementKeywords
This publication has 20 references indexed in Scilit:
- Heuristics for a periodic-review policy in a two-echelon inventory problem with seasonal demandComputers & Industrial Engineering, 2019
- Modeling and optimization of multi-item multi-constrained EOQ model for growing itemsKnowledge-Based Systems, 2018
- An EOQ model for decaying item with full advanced payment and conditional discountAnnals of Operations Research, 2017
- A three-product model to manage inventory with random demandEconomic Analysis: Theory and Practice, 2017
- Investigation of RFID investment in a single retailer two-supplier supply chain with random demand to decrease inventory inaccuracyJournal of Cleaner Production, 2017
- Applying queuing approach for a stochastic location-inventory problem with two different mean inventory considerationsApplied Mathematical Modelling, 2016
- Abdominal surgery process modeling framework for simulation using spreadsheetsComputer Methods and Programs in Biomedicine, 2015
- Simulation-based optimization framework for multi-echelon inventory systems under uncertaintyComputers & Chemical Engineering, 2015
- Modeling Pooled Purchasing Strategy in Purchasing Consortium to Optimize Total Purchasing CostProcedia Manufacturing, 2015
- Hybrid Mathematical Programming Discrete-Event Simulation Approach for Large-Scale Scheduling ProblemsIndustrial & Engineering Chemistry Research, 2011