{"id":266,"date":"2006-01-01T10:00:33","date_gmt":"2006-01-01T10:00:33","guid":{"rendered":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/?p=266"},"modified":"2022-02-20T11:52:45","modified_gmt":"2022-02-20T11:52:45","slug":"spreadsheet-optimization-of-flow-for-wip-goods-at-a-yarn-and-tire-cord-manufacturer-a-case-study","status":"publish","type":"post","link":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/spreadsheet-optimization-of-flow-for-wip-goods-at-a-yarn-and-tire-cord-manufacturer-a-case-study\/","title":{"rendered":"Spreadsheet Optimization of Flow for WIP Goods\u00a0 at a Yarn and Tire Cord Manufacturer: A Case Study"},"content":{"rendered":"

We developed a spreadsheet optimization model to find the optimal material handling policy at a leading yarn and tire cord manufacturer\u2019s 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.<\/p>\n

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

Note: This is the final draft version of this paper. Please cite this paper (or this final draft) as above. <\/em><\/p>\n

Download
\nSpreadsheet Optimization of Flow for WIP Goods at a Yarn and Tire Cord Manufacturer: A Case Study<\/a><\/p>\n

Dr. G\u00fcrdal Ertek recommends the following related books:<\/p>\n

\"\"<\/p>\n


\nSpreadsheet Modeling and Applications: Essentials of Practical Management Science (with CD-ROM and InfoTrac) 1st Edition<\/a><\/p>\n

 <\/p>\n

\"\"
\nNetwork Flows: Theory, Algorithms, and Applications 1st Edition<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

We developed a spreadsheet optimization model to find the optimal material handling policy at a leading yarn and tire cord manufacturer\u2019s 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 […]<\/p>\n","protected":false},"author":1,"featured_media":27,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-266","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/posts\/266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/comments?post=266"}],"version-history":[{"count":0,"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/posts\/266\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/media\/27"}],"wp:attachment":[{"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/media?parent=266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/categories?post=266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ertekprojects.com\/gurdal-ertek-publications\/wp-json\/wp\/v2\/tags?post=266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}