Spreadsheet Optimization of Flow for WIP Goods at a Yarn and Tire Cord Manufacturer: A Case Study

July 12, 2014
37 Views
Nylon 6.6 produced at Kordsa; Source: http://www.kordsa.com.tr
Nylon 6.6 produced at Kordsa; Source: http://www.kordsa.com.tr

We developed a spreadsheet optimization model to find the optimal material handling policy at a leading yarn and tire cord manufacturer’s facility. The focus of the study is to optimize the movement of looms of yarn and tire cord between two major manufacturing steps. The considered flow network within the manufacturing facility is a miniature two-stage supply chain, including the middle layer of depots. Movement of material takes place through forklift trucks and cranes, which impose electricity, labor, maintenance, and depreciation costs. After introducing the company, the facility, and the project goals, we present the underlying linear programming (LP) model and our spreadsheet implementation. The results of our model suggest an annual saving of approximately $22,000 for the facility.

Mataraci, B. and Ertek, G. (2006). “Spreadsheet optimization of flow for WIP goods at a yarn and tire cord manfacturer: A case study.” 5th International Symposium on Intelligent Manufacturing Systems, Sakarya, Turkey.

Note: This is the final draft version of this paper. Please cite this paper (or this final draft) as above.
Download
Spreadsheet Optimization of Flow for WIP Goods at a Yarn and Tire Cord Manufacturer: A Case Study

view PDF

Dr. Gürdal Ertek @ Social Web:

Dr. Gürdal Ertek @ TwitterDr. Gürdal Ertek @ LinkedIn

You may be interested

Wind Turbine Accidents: A Data Mining Study
Data Science
351 views
Data Science
351 views

Wind Turbine Accidents: A Data Mining Study

Dr. Gurdal Ertek - December 12, 2016

Fig. 1. The cause-effect relationship and stages where an accident occurs. Wind Turbine Accidents: A Data Mining Study While the…

Perception gap and its impact on supply chain performance
Data Envelopment Analysis (DEA)
292 views
Data Envelopment Analysis (DEA)
292 views

Perception gap and its impact on supply chain performance

Dr. Gurdal Ertek - January 10, 2016

[caption id="attachment_571" align="alignnone" width="843"] Figure 4. SEM modelling for relationship between performance gaps and performance shortfall[/caption] Figure 4. SEM modelling…

New knowledge in strategic management through visually mining semantic networks
Data Science
184 views
Data Science
184 views

New knowledge in strategic management through visually mining semantic networks

Dr. Gurdal Ertek - January 10, 2016

Fig. 5. Outlier objects. New knowledge in strategic management through visually mining semantic networks Today’s highly competitive business world requires…