Development of a model that determines the optimal production lot size using nonlinear programming and proposal of resolution with a spreadsheet

Authors

  • Maria Pilar Lambán-Castillo Universidad de Zaragoza
  • Javier Valencia Universidad de Zaragoza
  • Jesús Royo Universidad de Zaragoza

Keywords:

Supply chain, logistics, production, lot size, economic order quantity (EOQ), economic production quantity (EPQ), logistic index

Abstract


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.

|Abstract
= 51 veces | PDF (ESPAÑOL (ESPAÑA))
= 32 veces|

Downloads

Download data is not yet available.

Author Biographies

Maria Pilar Lambán-Castillo, Universidad de Zaragoza

Profesora e Investigadora  

Departamento de Ingeniería de Diseño y Fabricación Área de Ingeniería de los Procesos de Fabricación Instituto Universitario de Investigación en Ingeniería de Aragón

Javier Valencia, Universidad de Zaragoza

Departamento de Ingeniería de Diseño y Fabricación

Jesús Royo, Universidad de Zaragoza

Departamento de Ingeniería de Diseño y Fabricación

References

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.

Published

2014-04-07

How to Cite

Lambán-Castillo, M. P., Valencia, J., & Royo, J. (2014). Development of a model that determines the optimal production lot size using nonlinear programming and proposal of resolution with a spreadsheet. Revista Facultad De Ingeniería Universidad De Antioquia, (72), 134–144. Retrieved from https://revistas.udea.edu.co/index.php/ingenieria/article/view/15545