Interactive Excel-Based Procedure for Line Balancing

John F. Wellington () and Stephen A. Lewis ()
Additional contact information
John F. Wellington: Indiana University—Purdue University Fort Wayne, Fort Wayne, Indiana 46805
Stephen A. Lewis: Mongrel Works, LLC, Columbus, Ohio 43209

INFORMS Transactions on Education, 2018, vol. 19, issue 1, 23-35

Abstract: The assignment of tasks to workstations that results in the assembly of an item or provision of a service is a common topic of discussion in operations management (OM) courses. In this paper, we present an interactive Excel spreadsheet assisted procedure for assigning the required tasks. The procedure actively engages the student in the process and serves as a tool for learning how to effectively and efficiently assign the tasks to a series (line) of connected workstations. The Excel implementation provides more flexibility in selecting tasks than textbook or other Excel based methods that rely on certain priority rules, and is considerably easier to use than math programming models. The procedure and its spreadsheet implementation are illustrated and discussed, with an example.

Keywords: assembly line balancing; interactive mode; excel-based line balancing methodology (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/ited.2017.0192 (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:orited:v:19:y::i:1:p:23-35

Access Statistics for this article

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