Title: Teaching project management using Excel

Authors: Kal Namit, Moula Cherikh, Jim Chen

Addresses: School of Business and Economics, Winston-Salem State University, Winston-Salem, NC 27110, USA. ' School of Business and Economics, Winston-Salem State University, Winston-Salem, NC 27110, USA. ' School of Business, Norfolk State University, Norfolk, VA 23504, USA

Abstract: In this paper, we present an application of Excel spreadsheets in teaching the traditional Program Evaluation and Review Technique/Critical Path Method. This spreadsheet approach can be used in class with little cost in time or effort because it eliminates the need for tedious calculations and extensive algebraic manipulations, yet the students can understand and apply the algorithm without the black-box features that characterise most of the commercial project management software. To maintain a direct relationship with the traditional method, the spreadsheet uses the same familiar forward and backward operations required in the traditional manual calculations to find the critical path. Similar spreadsheet models are combined with the Solver in Excel to perform cost analysis by linear programming.

Keywords: cost crashing; linear programming; project management; program evaluation and review technique; critical path method; PERT/CPM; simulation; spreadsheets; CPM learning; operations management education.

DOI: 10.1504/IJIOME.2007.015286

International Journal of Information and Operations Management Education, 2007 Vol.2 No.2, pp.221 - 233

Published online: 01 Oct 2007 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article