2nd Indian International Conference on Industrial Engineering and Operations Management

Development of Scheduling Optimization Tool using Excel VBA and Solver for Productivity Improvement of Slitting Machines for PVC/PVDC film

Shraddha Chavan & Dattaji Shinde
Publisher: IEOM Society International
0 Paper Citations
1 Views
1 Downloads
Track: Operations Research
Abstract

Scheduling is one of the most important aspects for the efficient operation of any manufacturing industry. Scheduling deals with both time allocation as well as resource allocation to produce required quantity. Scheduling task in the Polyvinyl chloride film manufacturing industry was not established any standardized process. This task was person dependent and produced required quantity without using optimum resources. The proposed model aims at automation of scheduling of slitting machines in Polyvinyl chloride film manufacturing industry to minimize total processing time by using Integer Linear Programming technique. Slitting is the process of cutting of bigger length and width of jumbo roll to the smaller length and width of baby spools. Slitting machines handle a variety of materials, although each machine has its own constraints and capabilities. The proposed model is developed by using MS Excel VBA and Solver for optimum utilization of resources. This helps decision makers in planning and decision-making process of machine allocation.

Published in: 2nd Indian International Conference on Industrial Engineering and Operations Management, Warangal, India

Publisher: IEOM Society International
Date of Conference: August 16-18, 2022

ISBN: 978-1-7923-9160-6
ISSN/E-ISSN: 2169-8767