Applying Operations Research to Scheduling Work Cells in a Manufacturing Environment

Steffen Heider (), Jakob Heins () and John J. Kanet ()
Additional contact information
Steffen Heider: University Center for Health Sciences at Klinikum Augsburg (UNIKA-T), Chair of Healthcare Operations/Health Information Management, Faculty of Business and Economics, University of Augsburg, 86159 Augsburg, Germany
Jakob Heins: University Center for Health Sciences at Klinikum Augsburg (UNIKA-T), Chair of Healthcare Operations/Health Information Management, Faculty of Business and Economics, University of Augsburg, 86159 Augsburg, Germany
John J. Kanet: Department of Management Information Systems, Operations Management and Decision Sciences, University of Dayton School of Business, Dayton, Ohio 45469

Interfaces, 2018, vol. 48, issue 6, 556-565

Abstract: Constant competition in the manufacturing sector forces companies to continually decrease their costs while satisfying customer needs. These companies could be more efficient and achieve better results if they automated many of the tasks that they now schedule manually. In this paper, we describe how one department of Johnson Electric, a leading manufacturer of electromechanical components, automated and improved its scheduling process through the application of operations research. We created an easy-to-use Excel Solver-based tool for scheduling self-directed work cells. This tool does not require a user to have any knowledge of mathematical programming, because it automatically adds the objective function and constraints in the background. Our results show that the time required to create schedules decreases drastically and that the quality of the schedules improves significantly depending on the chosen objective function. We illustrate how fundamental knowledge of single-machine scheduling can add significant practical value in manufacturing. Moreover, our work shows that advances in computer interface development tools (e.g., Visual Basic for Applications) are making it possible to efficiently implement operations research concepts.

Keywords: Excel Solver; scheduling; single machine (search for similar items in EconPapers)
Date: 2018
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
https://doi.org/10.1287/inte.2018.0965 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:48:y:2018:i:6:p:556-565

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().