Teaching Note—Implementing Line Balancing Heuristics in Spreadsheets

INFORMS Transactions on Education

Howard J. Weiss¹ 

[1] Department of Marketing and Supply Chain Management, Fox School of Business, Temple University, Philadelphia, Pennsylvania 19122

关键词: assembly line;    balancing;    heuristic;    priority rule;    Excel;    array formula;    scenarios;   

DOI  :  10.1287/ited.1120.0096

学科分类：社会科学、人文和艺术（综合）

来源: INFORMS

【 摘 要 】

Two previous papers in INFORMS Transactions on Education demonstrated an innovative Excel array formula approach that can be used for the handling of precedences in project management and assembly line balancing models. In this paper I combine the array formula approach with a clever but simple precedence coding system to present an efficient spreadsheet for performing assembly line balancing using the heuristic method that is common in operations management textbooks. In addition, I demonstrate to students a perturbation method to handle ties in algorithms in Excel and also demonstrate the application of Excel's Scenario Manager to line balancing.

【 授权许可】

CC BY