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

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

Gregory L Light

Contact

Gregory L. Light

Contact

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

Article Fingerprint

ReserarchID

1F7J3

AI TAKEAWAY

Connecting with the Eternal Ground

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

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.
Jean-Philippe Denis (2019). Vidéo : « Say on pay », solution ou problème ?.
(2006). Effects of Composition and Additives on the Mechanical Characteristics of 3Y-TZP.
is x* with the objective function of value 60, as expected. By the duality theorem of linear programming.
Hasanain Ahmad (2020). Analysis of business networks in project management by using critical path method (CPM).
A Kumar,B Chakraborty (2016). Application of critical path analysis in clinical trials.
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.
Alexandros Kallantzis,Sergios Lambropoulos (2004). Critical path determination by incorporating minimum and maximum time and distance constraints into linear scheduling.
A Van Den Berg,F Smith (2015). Hardware genetic algorithm optimisation by critical path analysis using a custom VLSI architecture.
J Heizer,B Render,C Munson (2020). Operations Management.
Kala Seal (2001). A Generalized PERT/CPM Implementation in a Spreadsheet.
J Sikder,T Mahmud,B Banik,S Gupta (2018). Linear programming to find critical path using spreadsheet methodology.
Mohammed Hammad,Alireza Abbasi,Ripon Chakrabortty,Michael Ryan (2020). Predicting the critical path changes using sensitivity analysis: a delay analysis approach.

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. \u201cA Note on Identifying Critical Activities in Project Scheduling via Linear Programming on Spreadsheets, with Incidental Pedagogical Remarks\u201d. 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 January 31, 2021

Version of record

v1.2

Issue date

February 12, 2021

Language

Experiance 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: 2138

Total Downloads: 1003

2026 Trends

Our website is actively being updated, and changes may occur frequently. Please clear your browser cache if needed. For feedback or error reporting, please email [email protected]