A Note on Identifying Critical Activities in Project Scheduling via Linear Programming on Spreadsheets, with Incidental Pedagogical Remarks

Gregory L. Light

doi:10.34257/GJSFRFVOL21IS1PG1

A Note on Identifying Critical Activities in Project Scheduling via Linear Programming on Spreadsheets, with Incidental Pedagogical Remarks

Gregory L Light * §

Contact

§ Department of Finance, Providence College

A Note on Identifying Critical Activities in Project Scheduling via Linear Programming on Spreadsheets, with Incidental Pedagogical Remarks

Article Fingerprint

ReserarchID

1F7J3

DOI
10.34257/GJSFRFVOL21IS1PG1

Key Research Insights

Synthesized scholarly intelligence & interactive research assistant

This converted HTML version may contain rendering inconsistencies. Please refer to the PDF for the authoritative version, or click here to provide feedback.

Abstract

This note presents a speedy resolution of the critical activities for the critical path method (CPM) in project management by first running Excel Solver to obtain the minimized time of the completion of the project in question and next perturbing the required times of all the involved activities concomitantly to reveal the critical activities by observing the difference in the minimized times. We use extensions of decimal places for the classroom demonstration of the above-said perturbation, and consider additions of log(prime numbers) to the required times of all the activities to serve any large-scale professional analyses without using tailored-made software. As a separate incidental pedagogical note, we show a heuristic approach to constructing exactly three constraints to yield positive optimal values for all the three decision variables in linear programming.

References

13 Cites in Article

Reference Format

1. Cheng Zhang,Zhaoliang Jiang,Li Zhao,Weiwei Guo,Xueqing Gao (2021). Stability, rheological behaviors, and curing properties of 3Y–ZrO2 and 3Y–ZrO2/GO ceramic suspensions in stereolithography applied for dental implants. Ceramics International, 47(10), 13344-13350.
2. Jean-Philippe Denis (2019). Vidéo : « Say on pay », solution ou problème ?. Vidéo : « Say on pay », solution ou problème ?
3. (2006). Effects of Composition and Additives on the Mechanical Characteristics of 3Y-TZP. Journal of the Korean Ceramic Society, 43(10), 640-645.
4. is x* with the objective function of value 60, as expected. By the duality theorem of linear programming. is x* with the objective function of value 60, as expected. By the duality theorem of linear programming
5. Hasanain Ahmad (2020). Analysis of business networks in project management by using critical path method (CPM). Journal of Interdisciplinary Mathematics, 23(4), 851-855.
6. A Kumar,B Chakraborty (2016). Application of critical path analysis in clinical trials. J. Adv. Phar. Tech & Res, 7(1), 17-21.
7. Kazuyo Kusaka,Yuka Kanoya,Chifumi Sato (2006). Effects of introducing a critical path method to standardize treatment and nursing for early discharge from acute psychiatry unit. Journal of Nursing Management, 14(1), 69-80.
8. Alexandros Kallantzis,Sergios Lambropoulos (2004). Critical path determination by incorporating minimum and maximum time and distance constraints into linear scheduling. Engineering, Construction and Architectural Management, 11(3), 211-222.
9. A Van Den Berg,F Smith (2015). Hardware genetic algorithm optimisation by critical path analysis using a custom VLSI architecture. S. Afric. Comp. J, 56(1), 120-135.
10. J Heizer,B Render,C Munson (2020). Operations Management. Operations Management
11. Kala Seal (2001). A Generalized PERT/CPM Implementation in a Spreadsheet. INFORMS Transactions on Education, 2(1), 16-26.
12. J Sikder,T Mahmud,B Banik,S Gupta (2018). Linear programming to find critical path using spreadsheet methodology. IOSR J. Comp. Engin, 20(3), 48-50.
13. Mohammed Hammad,Alireza Abbasi,Ripon Chakrabortty,Michael Ryan (2020). Predicting the critical path changes using sensitivity analysis: a delay analysis approach. International Journal of Managing Projects in Business, 13(5), 1097-1119.

Download References

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Gregory L. Light. 2021. "A Note on Identifying Critical Activities in Project Scheduling via Linear Programming on Spreadsheets, with Incidental Pedagogical Remarks". Global Journal of Science Frontier Research - F: Mathematics & Decision GJSFR-F Volume 21 (GJSFR Volume 21 Issue F1).

More Citation Formats

Select Citation Style:

Download Citation

GJSFR Volume 21 Issue F1

Explore Journals Explore Volume Read This Issue

Journal Specifications

Crossref Journal DOI 10.17406/GJSFR

Print ISSN 0975-5896

e-ISSN 2249-4626

Keywords

Not Found

Classification

GJSFR-F Classification MSC 2010: 91G50

Submission ReceivedDecember 23, 2020
Peer Review Double Blind
Handling Editor
Accepted January 19, 2021
Published February 12, 2021

Version of record

v1.2

Issue date

February 12, 2021

Language

English

Order Article Reprint

Experience in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

View in VR

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

View in 3D

Article Matrices

Total Views: 554

Total Downloads: 37

All Trends