Spreadsheet optimization of flow for WIP goods at a yarn and tire cord manufacturer:

Mataracı, Berat and Ertek, Gürdal (2006) Spreadsheet optimization of flow for WIP goods at a yarn and tire cord manufacturer:. In: 5th International Symposium on Intelligent Manufacturing Systems, Sakarya, Turkey, Sakarya, Turkey

[thumbnail of 3011800000657.pdf] PDF

Download (1MB)


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.
Item Type: Papers in Conference Proceedings
Uncontrolled Keywords: Manufacturing systems; engineering; decision; support systems.
Subjects: T Technology > T Technology (General)
Divisions: Faculty of Engineering and Natural Sciences
Depositing User: Gürdal Ertek
Date Deposited: 05 Dec 2006 02:00
Last Modified: 26 Apr 2022 08:31
URI: https://research.sabanciuniv.edu/id/eprint/1156

Actions (login required)

View Item
View Item