ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637056' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637056' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637056' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637056' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '637056']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '637056'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 637056 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 637056]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 637056 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 637056

Título del libro: 33rd European Modeling And Simulation Symposium, Emss 2021
Título del capítulo: Continual improvement in the insert machining process at a metalworking facility

Autores UNAM:
ANN GODELIEVE WELLENS;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2021

---

Palabras clave:

Design of experiments; Grinding (machining); Integer programming; Machinery; Metal cutting; Metal working; Metals; Powder metals; Productivity; Statistical mechanics; Tungsten carbide; Brainstorming; Company leaders; Design of experiment; Ishikawa diagram; Linear-programming; Machining Process; Metallurgical industry; Optimisations; Powder metallurgy process; Simulation; Linear programming

---

Resumen:

A certain metalworking company, leader in the manufacture and distribution of tools for the metallurgical industry, has had difficulties due to late deliveries and quality related problems in the powder metallurgy process. The areas with productivity problems are pressing and grinding, which present rework and, consequently, long process times and low throughput. This work describes the optimization of the manufacturing process of the inserts with the best sales in the company, and subsequent agent-based simulation, to determine the degree of improvement in the level of rework and the impact of the optimization. The simulation model was developed in Anylogic, considering raw materials and process machinery as agents, as well as additional elements such as transport trucks and inspection tables. As resources, the forklift and the process operators were considered. The real contribution of this job was the possibility to analyze and demonstrate scenarios correspond to the state of the process before and after the improvement through a simulation and some statistical tools like Brainstorming, Ishikawa diagram, DOE (design of experiments) and a linear programing. The Productivity was found to be increased by 350% when using tungsten carbide powder with a density of 3.5 g/cm3, already agreed with the raw material supplier plants. Likewise, a correct allocation of personnel for the sandblasting operation, obtained through an integer programming model, leads to an improved productivity. © 2021 The Authors.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9788885741577
Editorial:
Dime University of Genoa

Tipo de producto:
Conference Paper

DOI:
10.46354/i3m.2021.emss.030