Solving PERT/CPM Using Excel
Kevin Quinn and Zvi Drezner
California State University-Fullerton, USA
Volume 11: 2017, pp. 107-114; ABSTRACT
In this short classroom note, we introduce a simple way to calculate the PERT/CPM algorithm in Excel. It can be used in an introductory Operations Management class when teaching PERT/CPM to avoid the laborious manual calculation involved in solving PERT/CPM. It can also be used as an interesting example for an advanced class in Excel. The user just needs to enter the data in the white cells and all the results are automatically calculated. We recommend showing students how to calculate the results of the PERT/CPM by hand (not necessarily the example problem), so that they understand the procedure, and then show them how to do it using Excel. When the file was used in class following the manual calculation, students were very impressed by the convenience of the Excel file and that the same results were obtained.
ORDER ARTICLE PERMISSIONS/REPRINTS/OFFPRINTS
To order permissions to include this article in textbooks, edited volumes, course booklets, online/digital course packs, etc., and/or to order multiple individual hard copies for classroom use, please use the appropriate form available on the Order Forms page or alternatively, contact the Publishing Editor pneilson@neilsonjournals.com directly.
© NeilsonJournals Publishing All Rights Reserved
NeilsonJournals Publishing
