Manufacturing cell formation using spreadsheets

Abstract

Many algorithms have been proposed to form manufacturing cells from component routeings. Most of these methods require specialized algorithms for implementation. Some others use well known procedures such as integer programming. However, these may be difficult for practising managers to comprehend. Proposes a simple method that can be implemented using spreadsheet software. The method is based on similarity coefficients and a pair‐wise interchange procedure. Describes the method and the spreadsheet implementation. Compares our procedure with many existing procedures using eight well‐known problems from the literature. Using three evaluation measures shows that the proposed procedure is effective. Given its simplicity and effectiveness, it may be useful to practitioners and researchers.

Citation

Kerr, D.C. and Balakrishnan, J. (1996), "Manufacturing cell formation using spreadsheets", International Journal of Operations & Production Management, Vol. 16 No. 9, pp. 60-73. https://doi.org/10.1108/01443579610125606