Development of a model that determines the optimal production lot size using nonlinear programming and proposal of resolution with a spreadsheet
Keywords:logistics, production, lot size, economic order quantity (EOQ), economic production quantity (EPQ), logistic index, supply chain
To facilitate the cost reduction effort that the global crisis has led in companies around the world, in this paper we propose a model to streamline production, a key area of the supply chain. The proposed model determines the optimal lot size considering activities of different areas of the supply chain, many of which were not previously considered. In order to facilitate the implementation of the proposed model in several companies, including SMEs, we show how to solve this model with a conventional spreadsheet.
A. Baykasoglu, V. Kapanoglu. “Developing a service costing system and an application for logistics companies”. Int. J. of Agile Manufac. Vol. 9. 2006. pp. 13-18.
E. Gutiérrez, H. Fuquen, D. Hernández. “Planificación integrada de producción y distribución para un conglomerado industrial”. Rev. Fac. Ing. Universidad de Antioquia. Vol. 53. 2010. pp. 88-105.
F. Harris. What quantity to make at once. In The Library of Factory Management, Operation and Costs. 1st ed. Ed. A. W. Shaw Company. Chicago, USA. 1915. pp. 47-52.
H. M. Wagner, T. M. Whitin. “Dynamic version of the economic lot size model”. Management Science. Vol. 5. 1958. pp. 89-96.
W. Hopp. “Ten most influential papers of Management Science’s first fifty Years”. Management Science. Vol. 50. 2004. pp. 1763.
E. Taft. “The most economical production lot”. The Iron Age. Vol. 101. 1918. pp. 1410-1412.
P. Yuan, L. Shang, C. Chun, C. Huei. “Mathematical modeling for determining the replenishment policy for EMQ model with rework and multiple shipments”. Mathematical and computer modeling. Vol. 54. 2011. pp. 2165-2174.
L. Moussawi-Haidar, M. Salameh, W. Nasr. “An instantaneous replenishment model under the effect of a sampling policy for defective items”. App. Mathematical Modelling. Vol. 37. 2013. pp. 719-727.
M. Lambán. Determinación de costos de procesos de la Cadena de Suministro e influencia de factores productivos y logísticos. Tesis (Ph.D.). Universidad de Zaragoza. Zaragoza, España. 2010. pp. 1-380
M. Lambán, J. Royo, J. Valencia, L. Berges, D. Galar. “Modelo para el cálculo del costo de almacenamiento de un producto”. Dyna. Vol. 179. 2012. pp. 23-32.
M. Darwis. “EPQ models with varying costs”. IJPE. Vol. 113. 2008. pp. 297-306.
V. Pando, J. García, L. San José, J. Sicilia. “Maximizing profits in an inventory model with both demand rate and holding cost per unit time dependent on the stock level”. Computers & Industrial Engineering. Vol. 62. 2012. pp. 599-608.
H. Laniado, D. Castañeda, D. García. “Aplicación del orden de mayorización a un problema de producción-inventario”. Rev. Fac. Ing. Universidad de Antioquia. Vol. 39. 2007. pp. 112-117.
T. Roy, M. Maiti. “A fuzzy EOQ model with demand-dependent unit cost under limited storage capacity”. EJOR. Vol. 99. 1997. pp. 425-432.
N. Mandal, T. Kumar, M. Maiti. “Inventory model of deteriorated items with a constraint: A geometric programming approach”. EJOR. Vol. 173. 2006. pp. 199-210.
A. Taleizadeh, S. Niaki, R. Nikousokhan. “Constraint multiproduct joint-replenishment inventory control problem using uncertain programming”. App. Soft Comp. Vol. 11. 2011. pp. 5143-5154.
How to Cite
Copyright (c) 2018 Revista Facultad de Ingeniería
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Revista Facultad de Ingeniería, Universidad de Antioquia is licensed under the Creative Commons Attribution BY-NC-SA 4.0 license. https://creativecommons.org/licenses/by-nc-sa/4.0/deed.en
You are free to:
Share — copy and redistribute the material in any medium or format
Adapt — remix, transform, and build upon the material
Under the following terms:
Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
NonCommercial — You may not use the material for commercial purposes.
ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
The material published in the journal can be distributed, copied and exhibited by third parties if the respective credits are given to the journal. No commercial benefit can be obtained and derivative works must be under the same license terms as the original work.