Dynamic Earned Value Management: A Diagnostic Framework for Scope Growth and Execution Volatility in Construction Projects
Description
The DEVM Model Dashboard for the Dynamic Earned Value
Files
Steps to reproduce
The study used documentary analysis, expert validation, and numerical simulation to develop and assess the Dynamic Earned Value Management (DEVM) framework. The first stage involved reviewing academic literature, industry publications, case studies, and project-management references related to Earned Value Management (EVM), construction delays, rework, scope changes, and project uncertainty. This review identified limitations of conventional EVM and supported the selection of rework (RR), lost days (LD), unresolved change orders (UCO), and approved variation orders as indicators of project dynamism and scope growth. The preliminary framework was then validated through individual interviews with five construction and project-management practitioners selected based on relevant professional experience. A structured/semi-structured interview guide was used to assess the framework in terms of clarity, logical consistency, completeness, and practical applicability. Responses were manually coded and grouped into recurring themes. Participants were identified as P1 to P5 to preserve confidentiality. A numerical demonstration was subsequently developed to test the computational behavior of the framework. The DEVM dashboard used controlled hypothetical project data rather than data from an actual construction project. Monthly Planned Value (PV), Earned Value (EV), and Actual Cost (AC) were generated to represent a plausible construction S-curve and project-performance pattern. Assumed values were also introduced for approved variation orders, rework, lost days, and unresolved change orders. Because RR, LD, and UCO may use different units, they were normalized into dimensionless ratios before aggregation. The Volatility Factor was calculated as: Vf = (RR + LD + UCO) / 3 Scope growth was represented as: Gt = Cumulative Approved Variation Orders / Original BAC The main DEVM calculations were: DPV = PV × (1 + Gt) DEV = EV × (1 − Vf) dSPI = DEV / DPV dCPI = DEV / AC Microsoft Excel was used to develop the model, formulas, scenario analysis, charts, and dashboard. Separate scenarios were prepared for rework, lost days, unresolved change orders, and their combined effect. Formula-based calculations allowed changes in assumptions to automatically update the outputs. Boundary checks were also performed. When Gt = 0, DPV returns to PV; when Vf = 0, DEV returns to EV; and when both are zero, dSPI and dCPI return to conventional SPI and CPI. To reproduce the study, another researcher may follow the same literature review, expert-validation protocol, variable definitions, normalization method, equations, and Excel workflow. The accompanying workbook may be replicated directly or populated with actual project data while retaining the same computational structure.
Institutions
- Batangas State UniversityCalabarzon, Batangas