NotesFAQContact Us
Collection
Advanced
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1188393
Record Type: Journal
Publication Date: 2018
Pages: 7
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0883-2323
EISSN: N/A
Examining Critical and Near-Critical Paths: An Excel-Based Classroom Exercise
Conant, Donald D.
Journal of Education for Business, v93 n6 p285-291 2018
The author's goals in this exercise were to use an Excel project to teach students about the effects of changing states of nature on critical path emergence as well as compare the impact of the PERT beta and triangular distributions on project completion times. Previous research into the PERT (program evaluation and review technique) beta distribution indicated a tendency for this distribution to overstate the impact of the dominant critical path on project completion times. The author used a Monte Carlo simulation and a new Excel function to explore the effects of random variation on critical path emergence. He used both the triangular distribution and the PERT beta distribution to calculate project completion times. The author found that three of the possible five paths became critical in both the PERT beta and triangular distributions. However, the triangular distribution moderated the PERT beta distribution's tendency toward the dominate critical path.
Routledge. Available from: Taylor & Francis, Ltd. 530 Walnut Street Suite 850, Philadelphia, PA 19106. Tel: 800-354-1420; Tel: 215-625-8900; Fax: 215-207-0050; Web site: http://www.tandf.co.uk/journals
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A