A Generalized PERT/CPM Implementation in a Spreadsheet

Kala C. Seal - kseal@lmumail.lmu.edu
College of Business Administration, Loyola Marymount
University, Los Angles, California 90045

Abstract

This paper describes the implementation of the traditional PERT/CPM algorithm for finding the critical path in a project network in a spreadsheet. The problem is of importance due to the recent shift of attention to using the spreadsheet environment as a vehicle for delivering MS/OR techniques to end-users.

Download the PDF
pdf 10.1287/ited.2.1.16

Supplement Material

vnd.ms-excel Pertcpm.xls
vnd.ms-excel PERTCPMwithG.xls

Citation Information
Seal, K. C. 2001. A Generalized PERT/CPM Implementation in a Spreadsheet. INFORMS Trans. Ed. 2(1) 16-26. Available online at http://ite.pubs.informs.org/.

DOI: 10.1287/ited.2.1.16

spacer_1126896045_gif

INFORMS  •  7240 Parkway Drive, Suite 300, Hanover, MD 21076 USA  •  443-757-3500  •  800-4INFORMS (800-446-3676)  •  informs@informs.org