Publication detail

Implementation of the PERT Method in MS Excel

DOSKOČIL, R. DOUBRAVSKÝ, K.

Original Title

Implementation of the PERT Method in MS Excel

Type

conference paper

Language

English

Original Abstract

The paper deals with a time and probabilistic analysis of PERT network graphs. The paper describes the implementation of the traditional PERT algorithm for finding the probabilistic analysis, the node and activity criticality by use of software MS Excel. The paper shows how relative comfortably to work with the PERT method. Benefit of this approach evaluate especially end-users. Case study describes a project which includes 14 subactivities. The completion time of each activity is not know certainly (only estimates are available). Model of the project consists of a network graph, which comprises 18 activities (4 fictitious activities) and 14 nodes. These data serve as inputs for spreadsheet in MS Excel. The program can be used to solve various large projects.

Keywords

PERT method, MS Excel, time analysis, probability analysis, node criticality

Authors

DOSKOČIL, R.; DOUBRAVSKÝ, K.

RIV year

2012

Released

9. 5. 2012

Publisher

International Business Information Management Association

Location

Istanbul, Turkey

ISBN

978-0-9821489-7-6

Book

Innovation and Sustainable Economic Competitive Advantage

Edition number

18

Pages from

1262

Pages to

1271

Pages count

10

BibTex

@inproceedings{BUT93049,
  author="Radek {Doskočil} and Karel {Doubravský}",
  title="Implementation of the PERT Method in MS Excel",
  booktitle="Innovation and Sustainable Economic Competitive Advantage",
  year="2012",
  number="18",
  pages="1262--1271",
  publisher="International Business Information Management Association",
  address="Istanbul, Turkey",
  isbn="978-0-9821489-7-6"
}