The Implementations of Spreadsheet Modeling for Generalized Critical Path Method

Khairul Annuar Abdullah, Wan Azlan Wan Hassan, Mohd. Fahmi Mohamad Amran, Suziyanti Marjudi, Norhawani Ahmad Teridi, Zuriati Yusof

Abstract


Using Excel or any form of spreadsheet for project scheduling is a convenient approach. The approach is dynamic compared to traditionally manual computations. It is also less complicated and mechanistic and rather straightforward compared to advanced programming languages. This paper intends to investigate numerous implementations of spreadsheet modeling ever worked and resulted for generalized critical path method. The approaches produced have significantly contributed to the advancements of teaching and learning and computerized applications in management science and industrial engineering. The approaches are comprehensively discussed, the advantages of respective approaches are thoroughly reviewed, their limitations are carefully addressed, and significant findings from the approaches presented are evidently derived.

Key words: Critical path method; Spreadsheet modeling; Project scheduling; Operations research; Management science; Quantitative method; Industrial engineering


Keywords


Critical path method; Spreadsheet modeling; Project scheduling; Operations research; Management science; Quantitative method; Industrial engineering

References


[1] Taha, H. A. (2007). Operations Research: An Introduction. New Jersey: Pearson Education.

[2] Institute of Chartered Accountants of Nigeria (ICAN) (2009). Costing and Quantitative Techniques. Nigeria: VI Publishers.

[3] Baker, B. M. (2005). Computer-Aided Learning and Assessment for Spreadsheet Modeling of Critical Path Analysis. INFORMS Transactions on Education, 6(1), 3-12.

[4] Taylor III, B. W. (1996). Introduction to Management Science. New Jersey: Prentice Hall.

[5] Shtub, A. (1997). Project Segmentation – A Tool for Project Management. International Journal of Project Management, 15(1), 15-19.

[6] Bodily, S. E. (1986). Modeling as a Stepping Stone. Interfaces, 16(5), 34-52.

[7] Hillier, F. S., & Lieberman, G. J. (2001). Introduction to Operations Research. New York: McGraw-Hill.

[8] Hegazy, T., & Ersahin, T. (2001). Simplified Spreadsheet Solutions: Overall Schedule Optimization. Journal of Construction Engineering and Management, 127(6), 469-475.

[9] Powell, S. G., & Baker, K. R. (2009). Management Science: The Art of Modeling with Spreadsheets. New Jersey: John Wiley & Sons.

[10] Seal, K. C. (2001). A Generalized PERT/CPM Implementation in a Spreadsheet. INFORMS Transactions on Education, 2(1), 16-26.

[11] Winston, W. L., & Albright, S. C. (1997). Practical Management Science: Spreadsheet Modeling and Applications. Duxbury Pr.

[12] Hillier, F. S., & Hillier, M. S. (2004). Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets. New York: McGraw-Hill.

[13] Fung, W. H., Huang, Ivan, C., & Tam, C. M. (2011). Application of GA Optimization for Solving Precedent Relationship Problem in Project Scheduling. Mathematical and Computer Modelling. doi:10.1016/j.mcm.2011.06.022

[14] Marchewka, J. T. (2010). Information Technology Project Management. New Jersey: John Wiley & Sons.

[15] Carter, M. W., & Price, C. C. (2001). Operations Research: A Practical Introduction. Florida: CRC Press.

[16] Ragsdale, C. T. (2003). A New Approach to Implementing Project Networks in Spreadsheets. INFORMS Transaction on Education, 3(3), 76-85.

[17] Davis, R. E. (2005). A Fast Spreadsheet Implementation of the Critical Path Method. INFORMS Transactions on Education, 5(2).




DOI: http://dx.doi.org/10.3968%2Fj.mse.1913035X20120604.889

Refbacks

  • There are currently no refbacks.


Reminder

How to do online submission to another Journal?

If you have already registered in Journal A, then how can you submit another article to Journal B? It takes two steps to make it happen:

1. Register yourself in Journal B as an Author

Find the journal you want to submit to in CATEGORIES, click on “VIEW JOURNAL”, “Online Submissions”, “GO TO LOGIN” and “Edit My Profile”. Check “Author” on the “Edit Profile” page, then “Save”.

2. Submission

Go to “User Home”, and click on “Author” under the name of Journal B. You may start a New Submission by clicking on “CLICK HERE”.


We only use three mailboxes as follows to deal with issues about paper acceptance, payment and submission of electronic versions of our journals to databases:
caooc@hotmail.com; mse@cscanada.net; mse@cscanada.org

Copyright © 2010 Canadian Research & Development Centre of Sciences and Cultures
Address: 730, 77e AV, Laval, Quebec, H7V 4A8, Canada

Telephone: 1-514-558 6138
Http://www.cscanada.net Http://www.cscanada.org